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 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.
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 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 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>
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'm probably doing something wrong here but when I try to get onlyl the records which occur after today's date, I get all of the records from the table, before and after today's date. Code:
View Replies View RelatedI 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?
I need to generate three random numbers between 1 and 100, but they need to be different.
e.g. 3,43,88 would be fine but 5,76,76 would not.
The function I have to generate a single random number is:
function funRandomNumber(intHighestNumber)
randomize
funRandomNumber = int(rnd * intHighestNumber) + 1
end function
called by: funRandomNumber(100)
Can anyone see how this can be modified to do what I need?
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.
THIS IS THE CODE: ....
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.
Does anyone see what is wrong with the code ....
how can i create an option tag whith the onpick event?
View Replies View Relatedif the default value of my my option value i want to retrieve it from the record if it's not empty. how can i do it? for example Code:
View Replies View RelatedIs there a way I can iterate an option value using ASP so I can pass in multiple values on submit to the Federated item? Here's an example of pseudocode of what I'm trying to do:
<SELECT name="grpNm" style="LEFT: 8px; WIDTH: 213px; TOP: 1px">
<OPTION value="XXXXXXXXXXXXXXX">Federated
</OPTION>
</SELECT>
Below is an extract from a form that i am writing. I need the user to be able to have a drop down menu of languages. How do I use the 'option value' command in ASP like you can do in HTML.If someone could amend my code to give me a couple of language options so I can get an idea of how it is down.
<tr id="r_Lang">
<td class="ewTableHeader"><span>Language<span class='ewmsg'> *</span></span></td>
<td class="ewTableAltRow"><span id="cb_x_Lang">
<input type="text" name="x_Lang" id="x_Lang" size="30" maxlength="25" value="<%= Server.HTMLEncode(x_Lang&"") %>">
</span></td>
</tr>
i have a dynamically created drop down menu where the values are pulled from our database. i've been trying with no success to pass those values to the page but it never works.
how do you pass the values from the <option value="<%=...%></option>? i thought you recalled it in the sql statement like:
Code:
" WHERE Something = '" & Request.Form("optionvalue") & "' "
I am trying to get a font of a label to change to times new roman when an option button is clicked, i have tried this:
Private Sub optHigh_Click()
lblHeading.FontName=Times New Roman
End Sub
This is wrong but i cant work out how to get the font to change,
how extract previews option value disable from script.
View Replies View RelatedI have a form named: 'formhandheld' and a select with the name: 'pricing_option'.
I'm trying to make the select <option> thats based on 'axDD3current' selected.
what's the code ? Probably more of a JavaScript question than ASP
document.formhandheld.pricing_option.options[<%=axDD3current%>].selected;
the above doesn't work
Here is my page:
<form name=myForm>
<select onChange="myForm.forename.value = this.options[this.selectedIndex].value;">
<option value="Arnold">Pam
<option value="Mokoena">Joe
<option value="Seth">Pat
</select>
<input type=text name=forename disabled>
</form>
when inserting on the database,the value of the dropdown option is the same as the value of the textbox which is wrong.they must not have the same values example
when Pan is selected,then the value inserted to the database must be "pam" not Arnold.
I have a dropdown list on my page. It is populated with values from database ;some values are unsually long that the DDL extends to the right of the screen where i need to scroll to find the arrow.
if i dont i wudn be able to read the values fully[i.e only half the length can be read]. Hence i wud like to provide a toottip for each <option> in the DDL whch will help me read the values onmouseover event. Hope I am clear abt it.Thus me scrolling to the right can be avioded.
I created one ASP page for Online Test. i get all the questions from database. In home page if user select the topic and no. of questions then its displayed in second page.
My trouble in Second Page, becs I show the questions like:
Ques No. Ques Name
====== =========
1. XXXXXXXXX
(1) ans1(Option Button)
(2) ans2
(3) ans3
(4) ans4
untill the users selection of question numbers. all this are created dynamically. if user submit the answers next page shows the result. How can i get the User answer(Option button) in Text Box or other ways.
I need to pass an Cat_ID and Category from an option field on a form, but can't figure it out. the code on my form:
<select name="Cat" >
<% Do Until rscat.EOF %>
<option value="<% response.write rscat("Category") %>">
<% response.write rscat("Category") %>
</option>
<%
rscat.MoveNext
Loop
%>
</select>
In the database, I have two fields which need to be filled in. The Category field and the Cat_ID field. How do I assign two values to the one field to pass this along?
I want to know if you can write a print this page option to a page. I want to write this function in asp or vbscript. I know you can do this in javascript but I don't want tot use this. I also know there is a print fuinction in the browser this is also not what I'm looking for.
I want a piece of tekst which say something like "print this page" When you click on it a asp or vbscript will print the page to your own printer.
I need to know if this is possible and what the code is.
I have a select list that gets populated from the DB. When the user makes a selection I am able to retrieve this value via Request.Form(...) However, I am wondering if you can retrieve the text value using ASP? I know this can be done in JavaScript using the options text attribute, but it is possible in ASP?
View Replies View RelatedAre there any articles / resources out there about the point of setting the domain when you set cookies? I have been able to find nothing and fail to see the point in setting a domain. As cookies can only be accessed by the domain that set them, what is the point in setting a domain? if the domain is set for say .example.com, can all subdomains read it?
View Replies View Related