I would like to create dropdown box that would populate by query table in excel. Field would be base on names. Second when query is submitted it would return a report for that name with the value I specify as the results for that person name. Is it possible and where can I find information on this subject.
View RepliesHow to display sql database data to dropdown list in asp?
View Replies View RelatedI would like to display 15 items (lines) in the dropdown list, but by
default the list displays only 11 lines. How can I have all the 15 items
displayed in my dropdown list
This is probably really stupid, but I cannot figure it out, and none of the references I've found seem quite right for what I'm trying to do. How do I do the below, but have the option values and Option Choice Text Description pull from the db instead of requiring manual data entry?
<option value="1" <%If (Not isNull((RS.Fields.Item("ID").Value))) Then
If ("1" =CStr((RS.Fields.Item("ID").Value))) Then
Response.Write("SELECTED") : Response.Write("")%>>Option Choice Text
Description</option>
Can anybody point me to some resources for this?
I need to include a variable value that I am getting from the URL into a dropdownlist selection.
<%
Dim strFlagCode 'Holds the vessel Flag Code
strFlagCode = request.QueryString("flag")
'-- Variables we are using
dim objConn, objRS, strSQL
'-- Define our objects
Set objConn = Server.CreateObject("ADODB.Connection")
Set objRS = Server.CreateObject("ADODB.Recordset")
'-- Database path and Data provider
objConn.ConnectionString = Server.MapPath("Static.mdb")
objConn.Provider = "Microsoft.Jet.OLEDB.4.0"
objConn.Open .....
I am trying to list a database (SQL) i a dropdown list but I just cant get it to work... I am writing in ASP. This is some of the code:
mySQL="SELECT ras.raser FROM ras ORDER by raser"
<tr>
<td width="220">Raser</select></td>
<td width="342" height="23">
<select name="idRas">
<%do while not rstemp.eof
pRaser= rstemp("raser")
%>
<option value='??????????' </option>
</select>
</td>
</tr>
I'm trying to build a asp dynamic list were you can select a option in the first list and depeding on that value the second list will change to match. For instance I choose a customer in the first list, the second list then has to give all the codes from that customer. The list is variabel, as the value;s are from a database.
If tried some stuff with ASP and Javascript, but the page reloads after selecting one option, but because it reloads, it delete's the text that is written in the rest of the form.
the problem is tat i have two dropdown list, i have to select an option from one of them and the result will display it in another drop down list base on wad i selected earlier.
Then after clicking the submit button it will insert all this information into the database. but for right now it is inserting all the information once i select the option in my first dropdown list without clicking the submit button. how do i solve this?
i have this code : onchange="document.vForm.submit()"
which is to submit the values from my first drop down list and display it to another dropdown list.
I have a dropdown list where u can add students name inside the listbox. As u can see there is a "Please select one" option in the dropdown list also. When i click on the option, it will be added into the listbox also. Can someone pls help me to solve this in JavaScript. My attachment.
if (document.teamForm.newMember.value == "-- Please Select One --")
{
alert ("You can not select this option.")
teamForm.newMember.focus();
return false;
}
I have an old application ( pre-VB5) that I need to add a select/option list to. This is an edit program so the values for the form will be retrieved from a database. How do I set the value of the dropdown with the value from the database. The value in the database is either new, trial, maint., employee, beta, or null. I need to set the dropdrown to one of these values. An example of the select;
<td>
<select name="ordReason">
<option></option>
<option value="New">New</option>
<option value="Maint.">Maint.</option>
<option value="Trial">Trial</option>
<option value="Employee">Employee</option>
<option value="Beta">Beta</option>
</select>
</td>
i have this error in my form. okay i have two dropdown list which i have to slect an option in one of the drop down list an it will display the result in another drop down list and then by clicking the submit button it will display all the information into the database. but right now, the problem is tat after selecting an option frok the first dropdown list it is submitting into the database without clicking the submit button. how do i solve this?
i have this code : onchange="document.vForm.submit()" which will submit the values and retrieve sum other values and display it into the other dropdown list. i cant take this code away.
I have a drop down list on an asp page. Can I have tooltips for each item so when the user scrolls odwn through the drop down I display a tooltip (as some options are long and I do not want to incrase the width of my drop down).
View Replies View RelatedAn HTML page that have two dropdown list whit different values:
1. Dropdown list 1(tblname1) =values with different location's. After user
has selected one value from the dropdown it should show values from
(tblname2) in the dropdown list2.
2. When user select an value from dropdown list2(tblname2) and click on a
button "GO" it should show all the value's from the database that been
selected in dropdown list1 and 2.
Please someone please help me out with this problem!?
I have what I thought was a simple script but I cant figure it out. Anyway, I want to set the selected item of a drop down list with information i am recieving from request.querystring. Seems like this is a case of when learning asp.net first is a hindrance to what i want to do. Im looking for something to the effect of,
Request.Form("dd_eventdate")= Request.QueryString("event")
What I want is for an action to be triggered when a user selects something on a dropdown box.
The something would actually be two variables. One 'static' in that the drop down would be 1, 2, 3, 4 the other being a variable in the true sense e.g. if selection A is 2 and selection B was 3 then the variable is 5 and this variable is the one I want to use to trigger events.
Using themes I could maybe do it but I am hoping there is a easier, more dynamic way to do it.
I have managed to populate a dropdown box with a list of all files in
the current folder and even filtered them by the extension so that it
only displays the .mdb files. However, the menu seems to be holding
all of the items in the folder and displaying only the .mdb.
This
seems to be a problem with the way I am defining the size of the
array. If I add my .mdb filter to the array loop I get an 'out of
range' error for the n variable?? Can anyone suggest a solution??
Code:
We have dropdown on ASP page. The problem is we have about 900 items in the
dropdown. Users scrolling through the list have become very frustrated in
the past.
Can someone suggest if there is another way of implement a dropdown where
the datalist is as big as ours.
I am looking for something like a listbox in VB where you can start typing
the characters and the databelow moves accordingly until you have found what
you want.
Is there anything in ASP/HTML to achieve a similar functionality.
How to make multiple select in dropdown list box using asp and access.
View Replies View RelatedI am creating a dropdown list in ASP. My problem is how to display tooltip for the drop down list in ASP.
I have used title property but it's not working.
<Select id="cboAction" name="cboAction" title="Select Action Type">
<Option value="0" selected></Option>
<Option value="1">One</Option>
<Option value="2">Two</Option>
</Select>
This is just a test before i apply to my system. I have a student:
Table: Pelajar
pelCode : 1001 (datatype: Number)
pelName : Michael Lee (datatype: Text)
countryCode : US (datatype: Text)
Table: Negara
countryCode : US (datatype: Text)
countryName : United States (datatype: Text)
i want to display this student's country name in the dropdown list as a selected country name and at the same time, populate all country names in the dropdown list. but, i can't make it. i saw the selected country name is country name that at the 1st row of table Negara ......
I have a page that has a form on it which has a dropdown list on it. It connect to an sql database and populate the list. What I would like to do is make the list editable so that if the data returned doesnt contain what I want, I can type in the data I require which will then be updated to the database when the form is posted. Hope I've made sense, you may be able to tell.
View Replies View RelatedAny code snippet or help link available on how to auto resize the dropdown list part of the combo(<select>) ?
Or, is there any alternative techniques for displaying the full lenth text when dropdown the combo?
I am building a link exchagne for a medical web site. To get categories for the link exchange, I Googled "medical categories" and came up with a very, very good list of medical categories. they were seperated by a <br> tag. I went through the code and extracted all but the following (see below).
What I want to do is somehow create a list of "options" for this categories in a select dropdown, with the category being the value for the option AND displayed in the dropdown. You know what I mean. I would think it would involve reading in a text file and inserting the necessary code. Code:
how to show a drop down list with a selected value that is derived from the database? Is this correct? When I do this, it shows "Mastercard" always, even when its "Visa" in the database.
<select name="ccType">
<option value="Visa" selected="<%=rs("cardtype")%>" >Visa
<option value="Mastercard" selected="<%=rs("cardtype")%>">MasterCard
</select>
I am creating one web page which contain a drop down list. It use the data from database. Now my problem is when the user select the drop down list value, I want the current selected value update to the database. How to write the code?
View Replies View RelatedI have an access database and an ASP application. On my add screen I am populating a dropdown box with a field from the database.
I want to use the OnChange event to fill in a textbox below with the corresponding information. I am combining HTML, ASP, and VBScript for my Onchange event.
Below is a working sample of my code, this issue is my RecordSet does not set to the record that is selected in the dropdown box: Code:
I am designing a website to records details of people who visit our company. When entering a visitors details I wish to record the company that they work for, to save the user time a dropdown list of companies is populated dynamically from the backend (Oracle) database. In the event of a company not existing in the database the user would have to go to the page to add a new company and then come back to the form meaning that they would lose anything they have already entered.
What I am trying to do is to enable the user to click on a link which will bring up a pop up window into which they may enter the new company, on closing down this popup the new company will be added to the dropdown list.
So far I have got the popup to display and to accept the user input and I have inserted this new company name into the database with a unique reference number generated by a sequence and before_update trigger. The following code is for the popup window and accepts user input, writes it to the database and closes the window: Code:
I'm trying to populate a dropdown box with the results of a query. There is current code that does this but it populates with team name whereas I want division name.
The database is set up as:
League - connected to - Division - connected to Team
I want to be able to have someone choose a league and then on the next
page populate a dropdown with all the divisions in that league.
Here is the working code:
I am trying set up a page where the user can view records chosen by the year.
I want to use a dropdown menu/list. Having trouble figuring out the sql behind this.
My db table has about 10 fields in it, one of which is the year this record was created. i want the enduser to be able to enter the page, and first step is to select a year to view. Again, i want this to be chosen using a drop down menu. After clicking I would like the page to show a simple table pulling up all the records from that year.
i know this sounds simple enough, but i cannot find this info/tutorial anywhere.. you guys are my only hope.
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:
I have two tables as such:
First table lists all of the stamps in our inventory:
tbl_Stamp
-------------
Stamp_ID
StampNumber
User_ID (person who owns it)
the second table lists every date that each stamp was accounted for (they need to be accounted for on a monthly basis)
tbl_StampAccountability
---------------------------
StampAccountability_ID
Stamp_ID
DateAccounted
The trick is to be able to show all of the stamps that WERE NOT accounted for between two dates.
I am thinking I need to start with a page that has two text boxes on it, one for start date and one for end date, and then pass those values to a second page that will list each stamp NOT accounted for between those two dates. Any ideas?
Can anyone advice if the following is possible: -
...srch=my&srchlist=search+query&submit=search....etc
srch and srchlist are the names of a textfield, and list/menu
Is it possible to amend the URL, so that the URL QS reads
...srch=my+search+query&submit=search....etc
strSrch = Trim(Request.QueryString("srch")) &" "& Trim(Request.QueryString("srchlist"))
This is the snippet I use to achieve the above example, which is fine, when I use this snippet, and make the &""& without space between the quotes, then it returns: -
...srch=mysearch+query&submit=search....etc
i have succesfully exported data from db to excel and dynamically generated
filename, problem is I need a space between the invoice ID and Customer
name, at present it generates the data but joined together eg 311Mackenzie
Centre should read 311 Mackenzie Centre
<%
sData = (request.querystring("InvoiceID")) +
(Customers.Fields.Item("CompanyName").Value)
Response.AddHeader "Content-Disposition","attachment; filename=" + sData
Response.ContentType = "application/vnd.ms-excel"
%>