Creating Multiple Drop-Down

I'm either way too tired or this is a bit above my head. I have a database (access) with four fields. One field is a unique id (rs("id")), one is a category (rs("category")), the third is type (rs("type)), and finally a title (rs("title")). There are and will always be seven types, numbered 1 - 7, with each type identifying a category. To be more specific, 1 = appetizer, 2 = soup, 3 = main dish, etc.

What I am trying to do is to create seven seperate drop down list, one for each type. The options in the drop down list will each be identified with the id (rs("id") and the values for each option will be the rs("title") field. I am having a hard time in the Loop distinguishing when to end one select statement and begin another.

View Replies


ADVERTISEMENT

Creating A Repeated Region With A Drop Down Box,

i have a drop down box, and would like to create a dynamic repeated region with the database field value

(Present_Goods.Fields.Item("quantity").Value)

ie the values of the drop down box woudl be from 1 to the value of the database field Code:

View Replies View Related

Multiple Drop Downs

i guess it depends on the domain for that answer. If it's a box with hundreds of webpages serving thousands of customers you'd want to conserve network bandwidth you'd probably want to do javascript, but i wouldn't consider reloading a page a big hit since if you just open the connection and runing two queries. But if you need the bandwidth you could do it with javascript.

I try to keep things out of javascripts and out of the hands of the client. Mainly because if they're running an older computer it will take longer to load and put unnessary strain on them and also if the client has scripting disabled you have no more drop down boxes and your site is pretty much disabled. With the strickly asp method you'd have at least the options to choose from and not any core functionality taken from it. That's my 2 cents on javascript to asp.

View Replies View Related

Multiple Dynamic Drop Downs

Im getting the functionality of it down first, thats what It looks a little bland. Anyway, the basic idea is that im trying to have a person select a department which brings up a list of class numbers, which brings up a table of tutoring times. Ive just started using ASP a week ago, so don't tear me apart too much. Code:

View Replies View Related

Multiple Drop Downs In A Form

basically what im trying to do is create a form to submit some data to an access db.

In the form i want to be able to have two dynamically populated drop downs (so if a user chooses cars in the first field it comes up with a bunch of car manufacturers, or if he chooses boats it comes up with boat builders etc etc.)

Ive searched high and low, and i the best i can find is javascript to make the drop dows. The java script however uses a form to repost the data back to the page to populate the second drop down. This wont work when its inside a form.

View Replies View Related

Multiple Dynamic Drop Down Boxes

I have a form with 2 drop down menus. the first is populated via a database query and the second gets populated based on the selection made in the first box. (Category/Sub Category)

I am having a difficult time keeping the initial item selected after the page reloads. I thought that this statement would work: Code:

View Replies View Related

Example For A VB Application Creating Multiple ASP Sessions?

We have an IIS+ASP based application server that is capable of providing
complex reports to hundreds of users but in some circumstances these reports
can take a long time to create. However the data for the report is cached
so subsequent calls to view the same report come back with a sub-second
response time.

In order to make use of this caching we pre-prepare some of the reports by
getting back a list of potential users from the server and then executing
reports on their behalf. When the real users log in the report is served
from the cache.

I wrote the warm caching application using VB6 and it uses XMLHTTP requests
to execute the reports. However because ASP serializes the requests to the
server the application can only have a single session open with the server.
To get round this I spawn multiple instances of the application, each
instance then has its own ASP session and the server is loaded more
efficiently.

The question is how can I create multiple ASP sessions from within a single
VB application and have each session handle its own XMLHTTP requests? Its
obviously possible as MACT, OpenSTA and LoadRunner all achieve it.

View Replies View Related

Split Function And Multiple Select Drop Down

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?

View Replies View Related

Multiple Drop Down Boxes Querying A Database

This is the solution needed to have Multiple Drop Down Boxes querying a Database(s) that will not wash out you other textboxes and objects on the select. Copy the code, change the connection to get you data and fly. Code:

View Replies View Related

Multiple Drop Down Boxes Retrieving Data From DB

I have a database with many tables. I have many objects on my form, textboxes, checkboxes etc... I need to populate a second drop down box after selecting the first drop down box with out the user clicking a button, Yes Master I know how to do the JavaScript onchange but every thin I have looked at uses hard coded data in their example. Can you give me a form example using you tutorial DB of multiple DD Boxes.

View Replies View Related

Having A Problem With Creating Multiple Page Results

I am attempting to only show 10 results per page in my results page. I keep on getting the following error. Wrong number of arguments or invalid property assignment: 'MoveFirst'
Does someone know where i am going wrong? Code:

View Replies View Related

Creating A Single Binary Log In A IIS Server Containing Multiple Websites

I am working with IIS 5.0 and would like use the property CentralBinaryLoggingEnabled which if set true will create one single binary log file in place of a separate log file for multiple websites.

This property is available in IIS 6.0. I would like to know if there is a patch available for IIS 5.0 which will create this property in IIS 5.0.

View Replies View Related

Display Drop Down Options Based On The Selected Item From Another Drop Down

The code that I have has 2 drop down boxes dd1 (visible) and dd2 (hidden). Based on the option selected in dd1, dd2 should be visible and populate options. I think I can have OnChange script but how could I return the value and put it in the SQL query (see variable in red in thecode)? Code:

View Replies View Related

SQL Server - Update/Insert Multiple Cols Into Multiple Tables

Just as the title says I am trying to do something impossible with a single SQL statement. I am doing an ASP webpage for internal use at the company I work for.

I want to know if there is a way to insert/update data into multiple tables in 1 SQL statement.

If it requires functions | views or anything else that is fine but I don't want to have 3-4 different SQL statements to update 2-3 different columns in different tables.

View Replies View Related

Searching Multiple Memo Fields In Multiple Tables In Access

I have a search option on my website, which should perform a search on 4 fields, as follows:

tblNews
headline
content

tblDatabank
filename
description

It only needs to return matches which are an exact match of their search criteria. For instance, searching for "I am here" would return a record which contained "I am here", but not just "I" or "I am" etc.

I need to return all these records as part of one recordset preferably, as I want to be able to order them etc., though I imagine you may suggest I use an array somehow to merge two recordets etc., then reorder them?

View Replies View Related

How To Update Multiple Records With Different Multiple Value

i hav problem with updating the data. In the asp page i hav displayed records based on search criteria. in display mode im displaying the to be updated field in combo box for each similar contract_no. each contract_no will hav different no of rows and to be updated combo box.

based on the selected value in the combo boxes of different contract_nos i hav to update the combo value with old value. user select multiple combo values at a time I need anybody's help with detailed programming logic.

View Replies View Related

Disable Drop Down "2" Until You Have Filled In Drop Down "1"

I have 3 drop down boxes on an asp page Dynamically populated fron the db, I need the drop bown boxes to be refreshed when you have picked the first eg I select "Midlands" from the Region drop down and only the "Locations" that are in the Midlands are entered into the Locations drop down.....

View Replies View Related

How To Drop NT

On one of my client's sites, we set up a subdirectory off the
app's root directory that doesn't allow the Anonymous IUSR_
account in. When we (the system admins) follow a link to
that directory, it presents the standard NT Challenge login
screen. We need to know proper Windows credentials to get
in -- and once we do, we have access to higher-order functions
(to change the read/write bit on files, to delete files,
etc. through the web interface). All that works fine.

View Replies View Related

Drop Down Box

I'm want to have a drop down box, for which each item in it have its own URL. I want it to be forwarded to the URL only when the button "go!" is pressed.
Here is my code, not working

<form name="addNewItem" method="" action="">
<td>Add new
<select name="url" onsubmit="">
<option value="publication.asp">Publication</option>
<option value="newsRoom.asp">News Room</option>
<option value="general.asp">General</option>
</select>
item</td>
<td>
<input type="submit" value="Go!">
</td>
</form>

View Replies View Related

Drop Down Box

I created a drop down box, I want to do like when a user select one of the options, it automatically run a query and displays the result.
I hope there is a way to do this

View Replies View Related

Drop Down Box

In one of my ASP pages, I have a Combo box that gets the information from a sql database,
the number of records that is shown in the combo box is too much (around 6000 records),
the user has to select from these records (let say the user is looking for "George", by clicking
"G" the list goes directly to the first records starting with "G", so far everything is ok, now he/she
enters "e" (the second letter of "George"),this time the list goes to the first record starting with
"e", which is not the way that I want the user to find his/hers record.
I hope that I have explained it correctly, what I need is, after entering the second letter of
"George", the list moves to the records starts with "Ge", and by entering the third letter, list
moves to those records starting with "Geo" and so on.

View Replies View Related

Drop Down

1 I want if seleted list of drop down in asp is changed then its related record in table should be displayed simultaniously in a single page.

2How can access the selected value of drop down in another page.

3I want to make a search command in a Sngle page in asp.

View Replies View Related

Drop Down Box

ive written a piece of code that selects everything from the "Departments" table in a DB and it works well. It lists everything in a drop down box. i'm not writing a page where users can edit their details.

i can make the text in the DB appear at the top, but it's listed again further down. is there any way to get rid of it? Code:

View Replies View Related

Drop Down Box

I have made a page in which i have 2 drop down boxes

in first i have got a choice from which i can select subject area eg ( microsoft, cicso , oracle) and after selecting the particular subject area the page reloads and retrive all the courses related to the particular subject area into the other drop down box, and after that when i select the course in the 2nd drop down box and click go then i got the whole information about that course.

Now what i want is that when i select the subject area in the first drop down box, all the courses should come as they are comming now + the 2nd drop down also have the option of "ALL COURSES " and after i select the "All Courses" option and click GO then i get all the courses and details os that subject area. Code:

View Replies View Related

Drop Down

I have my code like this the user enters the country in Upper case like this for example SPAIN

getcountry=Trim(Request.form("txtcountry"))

Response.write getcountry

now when i do a response.write it types the country name SPAIN

then i have a drop down which is been filled from the table and the values in it are lower case so i have to select spain which appears lower case in drop down Code:

View Replies View Related

Drop Down

On my page I have 3 drop downs that are populated with static data. When my user makes a selection in either drop down I want to show my HTML table associated with that drop down selection, also the data in my tables are all static.

For example.

if the user selects CAR - New in dropdown 1 I want to show a list of my new cars
if the user selects TRUCK in dropdown 2, I want to hide my CARS and show my TRUCK list
if the user selects BOATS - Fiberglass in dropdown 3, I want to hide (if shown) CARS, and TRUCKS and show my boat list.

For now all of the data is static (don't ask) so I need to do all of this on the client. Is there a way to do this either using JavaScript, Div tags, CSS, etc.

View Replies View Related

Drop Down Box

I have a drop down box which selects an item. I want to execute an SQL query and display the results depending on which item is selected. I need this to happen as soon as the item is selected, ie without clicking any buttons. How do I go about this?

View Replies View Related

Drop Down Box

I have a sql query that I wish to use in a drop down box. For instance a user would pull down a drop down box and select their name from the list... that would set the name equal to a variable. I know how to do an input box. and I know how to do the sql query ... but how do I put the query in the dropdown box?

The query is roughly this, assume that I have the syntax corrrect for the query (the exact syntax is at work atm and it is working without the box) . I have done my connect statements and such also.

"Select name From Worker"

View Replies View Related

Drop Down Value

I want to select a value (that comes from a query) in a drop down list. I have the drop down list working - but when I click the submit button it goes back to the first value instead of keeping the value that was selected in the field. I want to use this value later to select from another query.

View Replies View Related

Drop Down Box

I have a combo box that has all the models. I would like to select more than 1 model. Can it be done? Or can i use list box instead of drop down box to do it?

View Replies View Related

Drop Down Box

I have a database with fields like; age, hair colour, height, eye colour and more. I wanted to allow a user (on a webpage) to choose from a selection of these catagories, for example age drop down box displays; under 16, 16-21 etc.

The user then selects the one appropriate and when presses a submit button, this is then stored in the database. I want it to be accessible, so the user can edit it if necessary. I realise im going to have to use values in the drop boxes, but am not sure how to approach it.

View Replies View Related

Drop Down Box

Can I open and populate a listing.asp page based on a selection in a drop down box? The value in the dropdown box (ie. Wednesday) needs to locate 'Wednesday' in a database field and list all items that contain 'Wednesday' Anybody know of an article or reference where I can learn about this?

View Replies View Related

Drop Down Box Yet Again

I have 2 drop down boxes on my page but I want the option in dropdown box 2 to appear automatically once dropdown box1 has been selected.

With the code I have I can get the single answer in drop down box 2 but it has a blank / select line above it. I only want the one answer and no other option or blank/select line to be available. Code:

View Replies View Related







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