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