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:
i have a list of provinces in an option select right, so when i click one province i want it to chance the header of my page according to the provinces, and i have no idea on how to do that.
View Replies View RelatedI have loaded a combobox (select) with a recordset from SQL Server. I am trying to accomplish two things, so I will break them up.1) Is there a way to allow the user to enter as many characters in the dropdown menu. For example, if you have serveral options in the dropdown menu that start with A, they can key in app.. to got to apples, instead of entering A and then having to keydown or click on the dropdown menu.
Granted there is a solution to #1, could you also allow the user to key information and if it is not apart of the dropdown menu, insert the value back into SQL (kind of like an notonlist event in Access).I have googled this and can't find anything, probably wrong keywords used.
i just want to ask on how will i load the other version of file written in another language (e.g Japanese)upon selecting that particular language from the option box. Like for instance the options are English, Arabic, Japanese and so on...then upon choosing the Arabic language, the page that contains an Arabic language (layout and data)will be displayed.
View Replies View RelatedI am trying to force the last option selected in a drop down!, I basically have a page with a drop down box in which sends to itselfs when selected, the idea is
the selected value updates a postage amount depending on the country selected from the dropdown.
However when it returns to the page it defaults back to 'select country' and I would really like it to be able to display the option selected as this is part of the address form.
the relevant country is correct, and i am putting that into a request.querystring so this variable (destination) is available to test/compare against and maybe force select this way, but i just don;t know how to write the asp/html to make the select value go to either this variable or the last one selected. Code:
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.
Is there a possibilty to use the function <SELECT NAME="user"><OPTION>user 1</OPTION></SELECT>
from a database. I want to get the data out from a table and store the data from that column in a dropdown box. What's the way to do this ?
I am trying to retrieve option values using Request.Form as you do for textboxes! The textboxes work fine... but I can't get it done for select options.
View Replies View RelatedIs there a way to have a drop down menu where u can select an option from the menu or type in ur own??? I am using ASP and SQL
View Replies View RelatedI have an ASP admin script where I'm adding records, and I have a
category that already has set name values hard-coded into a selct option
pulldown, but if the user wants to create a new category and not use the
select pulldown, the value will end up being " , newvalue" when posting
from this sequence of pulldown and input text box:
<select name="CategoryName">
<option selected></option>
<option value="first">first category</option>
<option value="second">second category</option>
</select>
<br>
New Category<br>
<input name="CategoryName" type="text" size="26"
maxlength="255">
What is the best way of not having that extra preceeding comma appear as
the value if the user chooses to add a brand new category?
How can I get a new Option based on a the previous select. When you select a room from selRoom (orange) I want the available equipment (red) that match on a foreign key (CampusID 'Not Displayed') to be displayed. Code:
View Replies View RelatedIs 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>
Reading through the CDO email articles on ASPFAQ. I see .textBody and .htmlBody as properties, was wondering if you can add BOTH to an email so that if a user has HTML enabled (lets say in Outlook) they get the HTML version, and if they dont, then it'll use the plain text version?
If this is the case please let me know as I need to finish this code this evening if possible and it would save me some testing.
I have a difficult technical challenge I'm facing. I need to retrieve multiple values for the very bottom item in the list, 'Federated' (ignore the rest).
The database will query based off the option 'value', however, in this special case I want to perform a retrieval based off of multiple of values. I want to try to use the existing code without reinventing the wheel. Code:
I'm trying to pull the highest 'articleid' value out of an sql table, but the below is giving me an Incorrect syntax near 'articleid' error:
dim sqlid
sqlid = "SELECT max articleid from tblarticles"
Set rsid = Server.CreateObject("ADODB.Recordset")
rsid.Open sqlid,sqlc,3 ...
I'm building a page to update an existing database entry. On the form to do so, I have a basic select option menu as such:
<select size="1" name="ColR" style="width: 115px">
<option value="FFFFFF">White</option>
<option value="000000">Black</option>
<option value="FF0000">Red</option>
<option value="FF9900">Orange</option>
<option value="FFFF00">Yellow</option>
<option value="008000">Green</option>
<option value="0000FF">Blue</option>
<option value="4B0082">Indigo</option>
<option value="9400D3">Violet</option>
</select>
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 currently have designed a web page and inserted some ASP modules into it. But, if I insert more than one ASP module I receive an "Internal Server Error". If I delete the second ASP module the page works perfectly. So, my questions is this. Can you only insert one ASP module per web page? Where is the problem. Code:
View Replies View RelatedI 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 RelatedI 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:
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'.
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.
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?
I want to submit items from <select multiple> list into database.Should I use arrays?
View Replies View RelatedI 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.
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
How to make multiple select in dropdown list box using asp and access.
View Replies View RelatedI 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>
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:
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:
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?
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:
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....
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?