Select Multiple Data
Currently I have a combo box that shows records from a Select query using Group By. So it only shows each record type once. I can currently search for records using the combo box but I want to search for multiple records in the combo box.
For example, if in the combo box it shows records: Adam, Bob, Carl,,,etc.. Right now if I click on Adam, the search will bring up all of the Adams. What I want to be able to do is to be able to click on multiple records such as Adam and Carl and have all of the Adam and Carls show up.
View Replies
ADVERTISEMENT
I have a fairly simple problem that I can't find a straightforward solution to. It is a form which is checked server side using ASP to make sure certain fields are valid and then re-outputs the form if it fails with the fields already filled in, including multiple select boxes. The solution using PHP would be: Code:
View Replies
View Related
I am trying to repopulate a multiple select box in a webpage from a recordset.
Say I have the following recordset.
sSQL = "select geoID from table1 where srID = 3"
set adoRS = adoConn.Execute(sSQL)
Lets assume that it returns three records with geoID = 1, 2, 5
Lets say I am building a multiple select as follows: Code:
View Replies
View Related
Is it possible to query a database base on 2 distinct fields
I have tried this, but it did not work My Query:
SELECT DISTINCT rDateTime, DISTINCT rSessionID FROM TBL_RESPONSES WHERE rsID=" & iSID & " AND ruID=" & iUID
the error i got is: Code:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'DISTINCT'.
View Replies
View Related
I use a multiple select in a form in an asp page. When I go to the target page, I want to be able to read out the items selected on the previous page. How can I do that?
<form method="post" action="compare1.asp" name="Compare">
<select name="motorcycle" multiple size="20">
<%While not RSItems.eof%>
<option
value="<%=RSItems("ID")%>"><%=RSItems("Brand")%> <%=RSItems("Type")%>
<%
RSItems.movenext
wend
%>
</select>
</form>
How can I read out the items selected?
View Replies
View Related
I have a form search page with many field options but this one field I would like to select multiple options.
I have this on the search screen for my multiple field where I pull the list of options from my database: Code:
View Replies
View Related
I want to submit items from <select multiple> list into database.Should I use arrays?
View Replies
View Related
I want an ASP page with a dropdown and a simple button. Every time the user
chooses an item from the dropdown and clicks on the button i want that value
written below in list and allow user to select more.
Also how can these choices be saved somehow so tha when the user goes to the
next page the choices he made can be written to the database. For example
The choices in the dropdown may be:
London
Dublin
Paris
New York
When the user chooses Dublin I want ti written below the dropdown. Then when
he chooses New York. I want it added to london. so that it displays
Dublin
London
Then when he click next button these two choices are taken over to the next
page where an insert query can be used to insert them into the db.
View Replies
View Related
I have 4 tables first table category (category_id and category name in it)
second table artist (artist_id, category_id, artistname in it)
third table album (id, artist_id, album_title in it)
forth table song (id, album_id, title in it)
I'm selecting category in first page
I'm selecting artist in second page
I'm selecting album in third page
I'm requesting, collecting and posting all id's to the next page.
this is the question!!
How can I read from database
1- category name when I was selected in first page
2- artist name when I was selected in second page
3- album name when I was selected in third page
View Replies
View Related
How to make multiple select in dropdown list box using asp and access.
View Replies
View Related
I am populating a SELECT list from a result set. I need the same result set to populate a second SELECT list. Only one list is being populated. How can I get this to populate both? Here is my code:
<select name="options" size=10 multiple="multiple">
<% while (!rs.EOF) { %>
<option value="<%=(rs.Fields.Item("FIELD1").Value)%>">
<%=(rs.Fields.Item("FIELD1").Value)%>
</option>
<% rs.MoveNext(); }
if (rs.CursorType > 0) {
if (!rs.BOF) rs.MoveFirst();
} else {
rs.Requery();
}
%>
</select>
View Replies
View Related
I m trying to use multiple option menu using redirect function in ASP.
I managed to do a single option but I need to use multiple options can you please advise on how to do this, so both options apear in the same page. for instance, in the code below a user should be able to select uk and also selects between the other options; population, geography from the same page. Code:
View Replies
View Related
I have a form with two multiple select control (I named the first as cbo_source and the second as cbo_target). Once the form is loaded, the cbo_source loads all items from an MS Access database. Once i click the button >>, all the selected fields from the cbo_source should be transferred on the cbo_target control.
Well, I'm done with that using javascript, my problem is how am i going to get all the items from the cbo_target control once i submitted the form to an asp page(add_new_sched.asp)? I can only get items that are selected on the cbo_target, but what i need is to get all items from the cbo_target regardless if it's selected or not. Code:
View Replies
View Related
I have a multiple select drop down. It will load into it the following information: Student ID, Last Name, First Name
There will be another drop down box that loads with classes, only this is not a multiple select.
I need the user to be able to select all students they need from the first drop down and then select the class they want to insert them into. Then, when they hit the button, it will break up the data from the first, Student ID, Last Name, First Name and insert those three things into the database under those respective column names.
Does anybody know how I can split these up properly when there will be multiple students selected, or does anybody have a better way of doing this?
View Replies
View Related
What I want to do I select one database and the set the Rs1, rs2 etc.. like in Vb6 I would set DB then:
Set rs1 = db1.OpenRecordSet("Table1")
Set rs2 = db1.OpenRecordSet("Table2")
etc...
However how do I do this in asp3? Code:
View Replies
View Related
I am working with an ASP app that creates reports based on data in an SQL Server 200 database. There is a web form with select boxes for the user to select their criteria, and based on that an SQL SELECT statement is generated.
One of the requirements is that some fields need to be multiple selections. The output of these fields are in CSV format (One, Two, Three). These values are all alphanumeric, NOT just numeric....
View Replies
View Related
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?
View Replies
View Related
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:
View Replies
View Related
Say I want to sort the data in both db's according to similiar properties and read the results in a table.
View Replies
View Related
I am using access with sch_time_start,end,start_time,end as text fields not as Date/time....I am getting wrong amount of record...Example:
If db has 6 records like start_time and end_time = 12:00 AM- 05:15 AM,
and person has sch_time_start and sch_time_end = 12:15 AM-05:12 AM.....I am missing smth...maybe logic is wrong.. Code:
View Replies
View Related
i try to get data form access with asp. The select contains 2 Subselects. If i set this SQl statement in Access it works. But if i set this in ASP it doesn't. Why??? There is no error. It's completly the same statement.
View Replies
View Related
I have used ASP code to load data into two select boxes. The code below is used to move the selected data back and forth between the boxes.
I am having problems retreving the data from the boxes after the user has moved any of the data:
If the data has been moved by the below code; when i try and load the data back into the database i cannot retrieve the data using:
request.form("Clients1").item(1) and it will not show up using
request.form("Clients1").count
If i dont move the data i can retrieve it using: Code:
View Replies
View Related
I have a form (which is multipart/form-data) it has a file field and a select. When i submit this form i can get the file but i can't get the value of the select? any ideas?
View Replies
View Related
Is there a way to retrieve the DESCRIPTION in the following code from within the process.asp page without adding additional fields to the form?
<form name="myForm" method="post" action="process.asp">
<select name="Options">
<option value="1">DESCRIPTION</option>
</select>
</form>
View Replies
View Related
How can i pass more then one variable (within "href"), so that i can read the variables in the url using "request.querystring"?
View Replies
View Related
I need to have a table with 3 fields whereby the user can input the data and insert into my database using this website. However, I need this table to be dynamic so that after the user input the info for the first row, the user can click on add another row button and another blank row comes out. then the user can input the info for the second row and so on.
I am using ASP in the end to insert the data. I need some advice on how to create this kind of table where the user can click on one button to add another row and then able to insert all data in the entire table into database using asp.
number filename filesize
1 aaa.asp 123MB
add more data
View Replies
View Related
How do i update multiple records?I used to put the values in an array after splitting them.But what i noticed was , if there are values that are seperated with commas in the field value itself then it is taking the field value to be 2 in number.for eg:
if my field1 has value of abcd,defg and my field2 has value 123.When i update my field1 is updated with abcd and filed2 is updated with defg and so on? How can i overcome this?i want the values to be updated correctly into their respective field.
View Replies
View Related
I have 3 tables, product, industry and plist. product has productID and product, industry has industryID and industry, plist has productID foreign key with productID on product table and industryID foreign key with industryID on industry table.
In the plist table I am storing the productID and the industryID's that relate to that productID..
industryID productID
1 4
1 7
1 9
1 10
etc.
What I want in my ASP page is to return the actual products that each industry serves. So for the above example my script should return the products in the product table that relate to the productID's 4, 7, 9, 10, when I search it by industryID 1. I hope this is making sense. Code:
View Replies
View Related
I thought its more space efficient of displaying the data in multiple columns (let's say 2 columns for now), instead of one loooooooooong column in a table, are there a simple script of coding that can do just that?
How about 3 columns?
View Replies
View Related
how can I display multiple access data on hyperlink in ASP?? For example like I click on Monday link it will only display all the informaton about Monday and click tuesday will only display tuesday information on same page.
View Replies
View Related
I want to pull 2 different recordsets using 2 different stored
procedures using the same Data Connection. Below is the code that I
currently have, but I'm getting an 'Object Required' error message. Am
I doing this correctly, or at least headed in the right direction? Can
someone tell me the most efficient way (provide a code example) to pull
2 different recordsets from the same Data Connection? Code:
View Replies
View Related
I have 6 textboxes where user can input data (or can leave it blank). I need to insert all the data (if not blank) into the database. How should be SQL query be like? ...
View Replies
View Related
i have data in multiple access databases (not multiple tables within one database file) and was wondering if there is a way with ASP to display selected data on one webpage from these different databases?
View Replies
View Related
