I am trying to figure out how to pass one selectedIndex value to another select menu on a subsequent page without opening the page in a new window. I know how to pass information from one text field to another using Request.form or a Session, but I am not certain how this works with select menus. I have seen other examples that require you to open a new window, but again I would prefer not to do this.
I have two different select menus. This appears on the first asp page.
The next page has the exact same select menus as above and I would like it to populate the same value the user chooses from the first form page. I should state that the first select menu does redirect the user to different pages, however it should not matter because the above options for the select menus are consistent on all the pages the user is redirected to. I'm assuming the answer to my query will consist of utilizing ASP and JavaScript, however if not, I'm still game.
Im putting my website together, and I have made some simple text buttons that are aligned across the top of my page from left to right.Anyway, I have with this navigation a need to have more navigation options, which I hope to gain by having sub-menus appear when you roll over the button.
What I mean is how do I or can someone point me to a tutorial that will allow me to have a dynamic drop down menu generated via asp with data from a access databse that will allow the user to navigate to that sub menu content.
Hope you can help with a small problem I am having. I have a very simple table displayed on a page -
ID Name 1 x 2 y 3 z
and what I am trying to do is this - Roll over the ID number and display a pop up menu (which has more links to run other ASP scripts) and pass the ID number from the original page, though the pop-up menu and into the final ASP script (as selected on the popup menu) as a parameter for an SQL query.
I want to have a drop down menu, that when you select an option, loads data from the database into another drop down menu. So that's one part I don't know how to do. There will be a total of three options from the first dropdown, which represent different tables in the same database. So that's the other problem, how to load, depending on the table selected, into the drop down menu.
I am trying to write a function on a navigation page so I can just include the nav page on my other asp pages this way I only need to edit one file when I need to update the navigation system.
The problem I have is that if I try and do this with the response write statement how I can't use " inside the strings i.e
How do I store " inside a variable called say SP so I can do this?
Response Write "<form name="&SP&"form1"&SP>"
I am am guessing there must be a way you can store an asci value into a variable. But what is the command for this and what is the ascii code for "?
Finally is there I way I can write a drop down menu purely in ASP so I can avoid putting the HTML code inside strings?
The reason I have to have it the ASP code is simply I want to call the function that outputs the drop down menu in other pages, if I did not do a function it would not work as it would output the drop down menu at the top of the or whereever the include statement is.
I have a simple data entry form that has text boxes and some drop-down menus per row. My problem is the performance of the page.
I give the user the option of displaying 25, 50 or 100 rows at a time. Each row has 12 text boxes and 4 drop-down menus. The OPTIONS for the drop-down menus are being populated with data from our MS SQL database.
I'm using VIEWS to get the data and place them in recordsets, but how can I increase performance. It's taking way too long for the page to load and if the user clicks submits.. that takes a long time too.
I have an asp form that submits information to a database. On this form, I have a drop down box with about 15 options, each with thier own value. The selection is down a bit in the form, after user fills out certain information.
On the same form, I have a hidden value stated for "assigned_to" field. Most of the options in my drop down menu need an "assigned_to" value=35 and one option needs an "assigned_to" value=40 . How can I do this?
How do I make a dependant drop box? For example, when a user selects Item5 on the first drop menu the second one populates with the options for Item5? I know it will probably use Java of some sort but I do not know the code.
I currently have a page with car manufacturers in a dynamic form menu. Users can select one and click submit to find available cars by that manufacturer. What i now need is a second menu on the page where when a manufacturer is selected, the models associated with that manufacturer display for a user to choose. For example if Ford is selected:
Menu One Menu Two ------------------ ----------------- Ford Focus Fiesta Ka....
Can i do this with ASP to say "if menu one is ford, menu two contains...."? Or is there a much easier way which i am somehow missing?
i'm trying to create a dependent dropdown menu based on two objects, packages and steps (the steps dropdown will be dynamically updated/populated when a package is selected). the site uses ASP and since ASP is server-side, i am using JavaScript to handle the client-side "dynamic" change.
i've found several snippets of code that create the dependent dropdown; however, the two examples i have use arrays which are statically defined. the data that will populate the dropdowns is coming from a SQL database, and that data will be updated/changed fairly often. my question is this: is there any way to generate the arrays using ASP (outside javascript tags) and use them in the javascript?
or is there a way to use javascript to generate the correct arrays and fill them with data from my SQL tables? can i use a recordset ojbect in javascript? i have heard that you may use PHP inside javascript tags, but i'm unsure if that is what i want to do.. especially since i am using ASP as the main language for this site. Code:
I've got a problem with asp.net i am trying to make a menu control. and have searched the web for serveral controls but they don't work correctly.
I am pretty new to asp.net building. What am i looking for. i am looking for code to make a dynamical menu with submenus The menu items are stored in a MS SQL Table and when by loading the page the items will be created. i have made a asp table. i want my menu on the left cell, in the middle cell i want to change my pages to the menu item choosen. Code:
I have two menu form elements that need to refelect a parent child relationship. There are 85 zones and 2200 zone-network combinations.
I want to bind the networkid element to an xml datasource that contains only the networks related to that zone. I have read about something like this before but have never implemented it.
I have four pull-down menus and a GO button. Each menu contribute a parameter to an URL query string (like asp?a=1&b=2&c=3&d=4) where variable a is return from menu1, b returns from menu2 etc.
I created the four menus using Dreamweaver's INSERT JUMP MENU function and I find it difficult to modify its auto-generated javascript code to suit my needs. Does anyone has the complete code to accomplish this?
I have written some code which should dynamically build a table which is then populated with questionas and possible answers. The format of the answers will vary ie they may be in the form of a radio button which will be rated from 1-5, checkbox or a selectbox.
The first problem I have is if I do not comment out <select></select> I get an error message saying the page can not be found. when I do take it out I get asp timeout. Code:
does anyone know what I have wrong with this select in my form?
<% sql = "SELECT * FROM [LTAB_CAProcessArea]" Set ProcessAreaRS = Server.CreateObject("ADODB.Recordset") ProcessAreaRS.Open sql, SessionCPRDBConnection, adOpenStatic, adLockOptimistic, adCmdText %>
<select name="processarea"> <% Do While Not ProcessAreaRS.EOF Resonse.Write("<option name='" & ProcessAreaRS("processareaID") & "'>") Response.Write(ProcessAreaRS("txtProcessArea")) Response.Write("</option>")
I don't know if this is in the right section. I hope it is.I have an HTML document that uses tables and stuff. I also have a FORM on there with some input boxes, Radio buttons and <select> options. I have a .asp VB file also that processes the actual form and writes the answered questions to a text file on the server (tab separated) My problem: The input boxes and radio buttons work fine. It writes to the text file on the sever end.
My problem is I am not too sure how to go making the answers from the <select> options to also write to the server. They way I have it set up right now, it jsut writes "NULL" on the text file.
I've recently come across using "Select Last" in an sql query. Does anyone have any info or views on using it? Until now I've relied on "Select Max" but Select Last would have distinct advantages when using random autonumbers. I'm also curious about why there is so little info on it - perhaps I'm looking in the wrong places?
I want to display an editable page extract from MS Access table. Now I want to show the value in Select list, extract from another table. Both tables are joinable with the foreign key.
In simplest, I want to extract and display the exact value from a table and show in Select list for edit.
I could not think of any way. I can bring up data and display in Select list but it would display the first value in the list only.
I have the following SQL SELECT statement below that doesn't like the TOP 50 parameter. When I remove it, all is good. When I put it back I get "Incorrect syntax near '50'". Code: SELECT TOP 50 SSN, LName, FName, License_Certificate, Character_Identifier, CertificateNo, " & _ "tblIndividualInfo.IndividualID, tblLicense.LicenseID FROM tblIndividualInfo " & _ "INNER JOIN (tblLicense INNER JOIN stblLicenseType ON tblLicense.LicenseTypeID = stblLicenseType.ID) ON " & _ tblIndividualInfo.IndividualID = tblLicense.IndividualID " & strWhere & " ORDER BY LName, FName
i attach a pic file to show wat i wanted to do a few data will be listed out i want the total from that particular few records only. not the whole records in database
I know this is an ASP forum but I've also gotten answers to my SQL problems here and I'd appreciate your help very much. I have these two tables in SQL. Both tables have the same two columns (Description and SiebelName). I want to some how write a script that will look for the descriptions that matches the ones in Table1 with the ones in Table2 and if there are any I would like to take the column in Table2, SName, and update the column in Table1, SiebelName, with that of Table2. Here's what I attempted to do but it's not working: -------------------------------- UPDATE tbl_MasterTEST SET tbl_MasterTEST.SiebelName = Siebel.SName WHERE (SELECT tbl_MasterTEST.ProdDesc, tbl_MasterTEST.SiebelName, Siebel.SDesc, Siebel.SName FROM tbl_MasterTEST, Siebel WHERE tbl_MasterTEST.ProdDesc = Siebel.SDesc)
strSQL = "SELECT * FROM mod48 WHERE N_GEN = 5" oRs.open strSQL,oConn,3
this table has alot of fields. I want it to automatically create alot of Text boxes for each field. But i also need the fields names. The only thing is that the field names in the table are well not very user friendly.
n_gen = General Numer pa_name = Client Name pa_surname = Client SurName
So i was wondering is there something i can do. Like a For each that will create alot of tect boxes for each field "with its value in it" and also make it write a description for the lable. Code:
I have a select statement that searches for certain records within a date range entered through a form. what i need to do on another page is count how many records they are and split them into each day within that date range. My original select query is: Code:
objRSError.Source = "SELECT TOP 100 PERCENT TrapPage, TrapLine, COUNT(TrapID) AS ErrorVol, TrapDescription, TrapASPDescription, TrapCategory FROM dbo.tblErrorTraps WHERE (TrapTime >= CONVERT(DATETIME, '" & objRSError__strFrom & "', 103)) AND (TrapTime <= CONVERT(DATETIME, '" & objRSError__strTo & "', 103))GROUP BY TrapPage, TrapLine, TrapDescription, TrapASPDescription, TrapCategory ORDER BY COUNT(TrapID) DESC"
I have an ASP application.Is it right that I am calling all SELECT's AND DML's through stored procedures and in the ASP page I just call the stored procedure.
I am NOT using COM,i.e.I am not calling the procedures through DLL's but directly through ASP as time does not permit me to add this layer.
tell me is this right and is this a common practise followed i.e.calling stored procedures directly thru ASP without COM.Also,what is the main benifit of using SP than dynamic queries as there are plenty of suggestions dont know what is the conclusion.
