I use a multi-select menu in an ASP so the user can pick several values.
<select multiple name="lbErrorType" size="12">
However, after I have saved the records to the DB, and the user comes back
to edit a prior record, I re-populate the multiple select box and do a
"<option selected>" for each record that is saved to the DB.
<option selected>
But only the last value is selected !?!?
How do I get the select menu to select ALL the appropriate values ?
how I can make a dhtml menu into a dynamic menu that pulls its links from an access database instead of the hardcoded html.
I would like to know because I'm working on a site that needs such a menu and most of my administrators using my site don't understand html and won't be able to update the menu unless I can give them a simple form that allows them to add links.
i need to display results that do not match those in the database.I have an excel file and i upload it,inserting the records in a temp table. han i compare the values in the original table and the temp table.All i want is the values that do not match
sql = "SELECT TempSerial.SerialNo "&_ "FROM TempSerial, Serial WHERE TempSerial.SerialNo <> Serial.SerialNo "&_ "OrderBY TempSerial.SerialNo;" Set RS = objConn.Execute(sql)
i displayed the records with <%=RS("SerialNo")%> but i get all the records in the temp table displyed.
Will the Request.form show the correct order that they were displyed in or will it do something different. I have been testing and it always shows the order they were displayed.Is this just coincidental?
I have two multi-select boxes...selLeft and selRight. The user moves choices from selLeft to selRight with arrow buttons. selLeft is populated using XML.
My question is, when clearing everything on the screen, how do I repopulate selLeft, without losing items in selRight or repeating items left in selLeft.
I'm a newbie and not familiar with the code used to build the multi select box in the first place. Code:
hi there i need to display results that do not match those in the database. I have an excel file and i upload it, inserting the records in a temp table. Than i compare the values in the original table and the temp table. All i want is the values that do not match..i did this:Code:
sql = "SELECT TempSerial.SerialNo "&_ "FROM TempSerial, Serial WHERE TempSerial.SerialNo <> Serial.SerialNo "&_ "OrderBY TempSerial.SerialNo;" Set RS = objConn.Execute(sql)
i displayed the records with <%=RS("SerialNo")%> but i get all the records in the temp table displyed.
I have an Access database which asp pages use which has a number of fixtures and events which take place on certain days, and I want to select all values from the database which occur over a period of a week.
For example, for this week I'd want to select all items which have dates between Monday 26th November and Sunday 2nd December. Code:
I am trying to create a form where you may have more than one person at a meeting, but want to have them be related to the same meeting.
I have a mulitple select text area and if you select more than one, all the records are being added to the same row. so if I picked the following three people:
I have a form where the user selects their EmployeeID from a DB populated dropdown list. Then they fill out some other information and submit the form. I would like to make it possible that when the user selects their EID, other DB information tied to that EID is displayed on that page (Name, Phone #, etc), so that when the EID is selected, the employee can see their name and info, before the form is submitted.
Is it possible for JS/DHTML to show which value is selected (without posting the form) and then use that variable to call the additional information from my DB using SQL? I would probably then show that value using <div> or something.
Sorry, I am familiar with ASP/VBScript & SQL, but I don't know a ton about Javascript. And I don't think what I want to do is possible with only ASP, unless I post my form to another page, and then that page post the final submission for the form... I'd rather keep everything on one page, then submit the form.
This may seem like a silly question but i am now trying to get my data from my oracle database. This is going okay but i have the issue that when i have blank data in some of my fields, when i select it and out it in a table it doesn't seem to read them correctly
I am Trying to use the SQL SELECT Statment to open records from multiple tables into one recordset.
I know the basic syntax of the Select statment but I wanted to know if its possible to recive the table name from the feild or the record that I am readinf from the recordset in any given moment.
To make things more clear, my example:
-Open a connection
SQL = "SELECT * FROM TABLE1,TABLE2 WHERE TABLE1.UserID=" & uid & " And TABLE2.UserID=" & uid
rs.open sql,conn,3,3
while not rs.EOF
-read from record
rs.movenext wend rs.close conn.close
now, in the part that I read from the record, is their any way I can know if that record is from table1 or table2?
Has anybody ever seen or written code for ASP that would mimic Access' multi-column combo box? Specifically, I have a drop down box that lists about 100 five-digit codes. Each of these codes has a long text description that explains what the code represents.
I'd like to be able to show the code plus description when the drop down list is dropped down, but just the code when the list is not displayed, so that I don't have to have a hugely long combo box taking up space. Code:
I am trying to find out how to select an item from a drop down menu after a query is executed. My drop down has 4 options, and what I am trying to do is if the record stored in the database is "option2" I need the drop down menu to have option2 is selected.
What would be the easiest way (JavaScript?) to have the attached form redirect a user to a sample business card on select from the drop down menu and response.write to the new file, carrying over the info the user inputs into the form? I want to change the response.write to the sample1.asp, sample2.asp etc.
I have 2 drop down menus with data populated dynamically from a database.
Category
Subcategory
If i select an appropriate category the subcategory should change instantly to show the subcategories relating to the selected category. But i can't use a form submit, because before the forms are other textboxes with other values that i don't want to wipe on a page refresh.
I need to somehow preload the categories and their related subcategories. I've been trawling through examples, most are harcoded combobox values which won't work for me.
I've writen the code below which displays a drop down select menu and can be displayed by writing the variable 'sjobs'. The code works fine as it is and the menu is populated with the requested info from the database ok. The problem I'm having is adding url links to the menu values. Code:
I am trying to split a mgrgroup field to extract the MD codes. It correctly grabs the MD codes if all records in a mass update are updated, but if only one record in the loop is updated then it puts the last 5 digits of the mgr name in the MD field.
I am using the following code to split/join values in a multi-select field. It is combining all the values in All the records into one long string in each record in recordset.
Example: I have a recordset with 2 records. The 1st contains the split/joined values: Alan Smir, Jeff Karl The 2nd contains the value: Keith Robb
When it updates database, it will put Alan Smir, Jeff Karl, Keith Robb into each record in the recordset. Instead it should be putting Alan Smir, Jeff Karl into the 1st record and Keith Robb into the 2nd record in the recordset.
I was wondering if you could help me with the following problem. I have 2 listboxes in my webpage, 1 has cities, and the other lists the streets of the city from the first listbox.
When I click on a city, I want the 2nd listbox to populate with all streets in the city. The city and streets are saved in a database, so when the user selects the city, I will run a query on the database and populate the 2nd listbox with all streets.
How can I do this with normal ASP? I know how to do this with ASP.NET, but don't know how to activate this with normal ASP?
I have this SELECT box which allows users to select multiple items to delete... however if they select 2 or more items... the values get passed over as 'one, two'
So the sql looks like Delete From Table Where Field='one, two';
How do i do it in such a way that it becomes:
Delete From Table Where Field='one'; Delete From Table Where Field='two';?
I am creating an application in ASP (old school ASP not .NET) and VBSCRIPT connecting to a SQL Server 2000 back end. There is a form on my webpage that has a select box in which <option> tags allow users choose a document type.
Once the document type is determined it is sent off as a parameter in a stored procedure on the databse. The recordset returned holds the values that are required to go in another set of options boxes.
(the next set of option box values depend on the query results). I know it sounds easy...I mean I know how to do it if it where on 2 seperate pages (thats easy) where it passes on the info...but this is for ONE asp page.
I'm having trouble getting a certain value out of my database. Code:
reportID = Request("reportID") sql = "SELECT * FROM reports WHERE reportID =" & reportID set rs=Server.CreateObject("ADODB.recordset") set rs=conn.execute(sql)
I can get every value I want out except for one, rs("courses"), which is a text field that is filled from a multiple select form that enters the ID numbers of courses. The thing is, when I check the actual Access db file, I can see the value there (e.g: 1, 2, 3), but when I try to print it to my page (e.g: <% = rs("courses") %>),
I get nothing. I can't figure out why it won't work especially as I have an identical field in another table which I can get the value for using exactly the same method. Anyone have any idea what could possibly going wrong?
I first retrieve the values stored in a session variable (where I have stored an array). Then I assign the session variable to a local array called "myarray".
Assume that "myarray" now contains 5 records. What would the code look like if I want to create a loop that transfers the 5 values from "myarray" into a select box/dropdown list?
My users have to select an value from a fixed selection of values. The obvious choice of control for such a requirement is to use a <select> (i.e. a combo box).
My problem is that sometimes, these combo boxes will have a *large* number of values. There could be any number of values in them from 5 to 5 million (unlikely it would be this large but possible).
Obviously 5 million is far too much to populate a <select> control with. Does anyone have any suggestion as to how a user could select a value from a *potentially* very large selection of values (i.e a suitable alternative to the <select> control)?
I'd like to have the option that matches the current value in the database field display as the selected option. I know it's easy enough to manually force one option or another to be selected, but how could I change which one it is based on the database contents?
I'm having problems retrieving all the values from a multiple selection field using the freeaspupload component.
I'm creating an online email app that uses the freeaspupload to add attachement functionality, which means the form encoding type is multipart/form-data. I've done something similar with the persits aspupload component, and had no problems with that, but the freeaspupload version seems to handle <select> fields slightly differently. Code:
I am trying to learn and use good DHTML concepts and code (assuming they are needed). My current issue concerns how to handle this situation.
I have a Select List box which displays values based on what value is selected in a dropdown list. For example, my dropdown list contains a class name, and the Select list contains all of the students who are registered for that class.
So what I would like to occur, is when the user changes the class from the dropdown box, the Select List is re-created displaying the students who are enrolled in that class.
I thought I could do this without having to reload the page (with DHTML) but here is my problem. Code:
