Option Values Show In Selectbox

I have one table which has 3 fields within a SQL Database, the first is ID numbers, the second is Country and the third is City (within that Country)Eg: I have 1; United Kingdom; London

What I am trying to do is have an “optgroup” dropdown box with the Countries as the optGroup label and the cities related to each country under that optGroup. I want to populate the dropdown box with this data, preferably in alphabetical order of city. Is there a way to do this in ASP?

View Replies


ADVERTISEMENT

Show DB Values When Selecting An <option>

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.

View Replies View Related

Dynamic Selectbox - Passing Corresponding Values To What Is Selected

if I create a dynamic selectbox from the table tblRewardsDetail - I can submit what is selected to tblLineItems BUT not the corresponding values.

For example if I select Item2 the corresponding value associated with that Item 50points does not write to the tblLine Items but ItemIden2 does. Code:

View Replies View Related

Select Box Option Values

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.

View Replies View Related

Retrieving Multiple 'values' In A Single OPTION ITEM

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:

View Replies View Related

Show All Values From My Database

I have a problem with show all values from my database into my html page! Code:

View Replies View Related

Combine The Two Variable Values And Show The Result

I have two variables:

UserLastName = request.cookies("UserLastName")
UserFirstName = request.cookies("UserFirstName")

and I'm trying to create a third variable that would strip the first letter of each of the above variables and combine them to create initials. Eg. if FirstName is John and LastName is Doe, the UserInitial variable would be "JD".

View Replies View Related

How To Show A List Of Values In A Seperate Line In Textarea?

I have a textarea that displays the values from the recordset. But how can I display each value in a seperate line

While not rsHires.EOF
Response.Write rsHires("Emp_Name") & "
"
rsHires.MoveNext
wend

I tried <br> too, but they get printed into the textarea.

View Replies View Related

Problem With Multiple Selection In Selectbox

In my asp page i m using 5 dynamic comboboxes i.e one combo boxes gets loaded depending on selection from another combobox. all combo boxes have multiple selection property.

My problem is i am not able to do multiple selection by using ctrl or shift key. if i m using either of the keys even then it captures only first selection on which i have clicked.

if i continuesly do some selection say first 10 records without using any key then its working fine but if i want to do selection say 1,5,8 by using ctrl key then it is capturing only first selection. Code:

View Replies View Related

Client-side, Dynamic SelectBox

I want, that when a user selects 'Poems' in my selectbox, to display another select box next to it containing more options. I also want to do it with other options, such as stories, essays, etc options. how to do it?

View Replies View Related

Populate A Popup Window With Clickable Records From An Access DB And Upon Clicking, Populate A Selectbox On The Original Webpage With The Clicked Record

We have an ASP site that hits up an Access database of categories of
products and products. (e.g. Categories = Napkins, Tablecloths;
Products = 20x20 Napkins, 21x21 Napkins, 54x54 Tablecloths, 60x60
Tablecloths)

We currently have select boxes that when you select a category, it
populates the next select box with the proper list of products (i.e. I
select Napkins as a category, I get a listing of the Napkins)

We would like to put a clickable link before each of these select
boxes that would pull up a pop up with links from the records from the
proper table.

(e.g. I click the categories link and a popup with html
anchor tags of Napkins and Tablecloths appear) I click on the Napkins
anchor and it populates the Categories Select box with Categories and
Napkins being selected.

View Replies View Related

Form Values With A File - Passing Values

I want to call a recordset so you can edit the details and then obviously pass the parameters onwards into the db. However, the user guide just says this:

To process other fields in the form, use the Form collection of the upload object the same way you would use the Form collection of the Request object. For example, if your form had a text element named UserName, your processing code would include: Code:

View Replies View Related

How To Convert Escape Values In To Actual Values

i need to convert the escape values which are by mistake updated in DB.
example:

this is a sample text string
is updated in DB as
this%20is%20a%20sample%20text%20string

here %20 is the space.

like wise there are many entries for :,'

is there way that i can update all this in a update statement?
or use asp to to update the records?

View Replies View Related

Option Tag

how can i create an option tag whith the onpick event?

View Replies View Related

Option Value

if 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 Related

OPTION Value

Is 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>&nbsp;&nbsp;

View Replies View Related

Option Value Tag

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'>&nbsp;*</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>

View Replies View Related

Option Value

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") & "' "

View Replies View Related

Vb 6 Option Button

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,

View Replies View Related

Option Disable Value

how extract previews option value disable from script.

View Replies View Related

Option Selected?

I 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

View Replies View Related

ASP Dropdown Option Value

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.

View Replies View Related

Tooltip For Each Option In DDL

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.

View Replies View Related

How To Get The Value From Option Button

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.

View Replies View Related

Passing 2 IDs Through An Option To Db

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?

View Replies View Related

Option On A Page

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.

View Replies View Related

Option Select

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 Related

Select/Option

I 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.

View Replies View Related

Getting Option's Text Value

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 Related

Domain Option

Are 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

Select/Option

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 Related

Check Box Option

Is it possible that I can create a check box that corresponds with a group of radio buttons which become visible and invisible as the check box is checked and unchecked ?

View Replies View Related

Option In Combo Box

I have some filter fields - when these are chosen it should list the records only with these values that are chosen.

For e.g. I have a filter for month. So, want to list the records only for that month. Also for week. How do I go about?

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved