I have a search page with 5 drop down menus(where data pulled from access database.
how do i give the select query , which will bring out results depending on the search critieria/fields set by user.
for example
the fields are first name, last name ,city, age,education.
if a particular city is choosen i want al the rows that matches the city filed.
if age and city are choosen .i want the results which has the age in that particular citty.
I want to have a drop down menu, that when you select an option, loads data from the database into another drop down menu. So that's one part I don't know how to do. There will be a total of three options from the first dropdown, which represent different tables in the same database. So that's the other problem, how to load, depending on the table selected, into the drop down menu.
View Replies View RelatedI am trying to write a function on a navigation page so I can just include the nav page on my other asp pages this way I only need to edit one file when I need to update the navigation system.
The problem I have is that if I try and do this with the response write statement how I can't use " inside the strings i.e
sub dropnav()
Response Write "<form name="form1">"
Response Write "<div align="right">"
Response Write "<select name="menu1"
etc etc
end sub
How do I store " inside a variable called say SP so I can do this?
Response Write "<form name="&SP&"form1"&SP>"
I am am guessing there must be a way you can store an asci value into a variable. But what is the command for this and what is the ascii code for "?
Finally is there I way I can write a drop down menu purely in ASP so I can avoid putting the HTML code inside strings?
The reason I have to have it the ASP code is simply I want to call the function that outputs the drop down menu in other pages, if I did not do a function it would not work as it would output the drop down menu at the top of the or whereever the include statement is.
I have a simple data entry form that has text boxes and some drop-down menus per row. My problem is the performance of the page.
I give the user the option of displaying 25, 50 or 100 rows at a time. Each row has 12 text boxes and 4 drop-down menus. The OPTIONS for the drop-down menus are being populated with data from our MS SQL database.
I'm using VIEWS to get the data and place them in recordsets, but how can I increase performance. It's taking way too long for the page to load and if the user clicks submits.. that takes a long time too.
I have an asp form that submits information to a database. On this form, I have a drop down box with about 15 options, each with thier own value. The selection is down a bit in the form, after user fills out certain information.
On the same form, I have a hidden value stated for "assigned_to" field. Most of the options in my drop down menu need an "assigned_to" value=35 and one option needs an "assigned_to" value=40 . How can I do this?
How do I make a dependant drop box? For example, when a user selects Item5 on the first drop menu the second one populates with the options for Item5? I know it will probably use Java of some sort but I do not know the code.
View Replies View RelatedI have a search form with a drop-down box that is populated by several location names. Each location name has a corresponding locatino ID in the ACCESS database. The code looks like this:
<select input name="searchLocation">
<option selected>--Select a Location--</option>
<%=TF_GetLocationSELECT(Request.Form("location"))%>
</select>
I now want to do a search of an ACCESS file using this box. The relevant search code looks like this:
If Trim(Request.Form("searchlocation")) <> "" Then
strSQL = strSQL & " AND location = " & Cint(Request.Form("searchlocation"))
End If
Now, if someone selects a location, then EVERYTHING WORKS GREAT! However, if he makes no selection, and leaves the drop-down box with the words "--Select a Location--", then I get an error message saying:
Microsoft VBScript runtime error '800a000d' Type mismatch: 'cInt'
What I want is that when the user doesn't enter a location and leaves the drop-down box with just the words "--Select a Location--" then the search must search of ALL locations.
What do I do?
I have 3 drop down boxes that links to a result.asp page that i want to show the results of the criteria. whenever i hit the submit button, i get this error:
Microsoft OLE DB Provider for ODBC Driverserror '80040e14'
[MySQL][ODBC 3.51 Driver][mysqld-4.0.20a-nt]Unknown column 'Apartment' in 'where clause'
/result.asp, line 34
The line its referring to is like so:
rsResults.Open()
I am creating a "search by category" page using a drop down menu. I am very new at SQL/ASP and am having trouble with the correct syntax for sorting my search results.
Each category in drop down has an id ("catid"). Results need to show all Company names that fall under that specific category in alphabetical order. I have already completed a directory that is sorted alphabetically and tried to "borrow" some of that code:
I'm trying to create a part search for mufflers. I would like to do drop downs ex.
Year
- Make
- Model
- Engine
the end result would bring up the part they are looking for and it would link to that part. Kind of similar to a appsearch.aspx. I'm unsure would would work best with this, so if someone could point me in the right direction, that would be awesome.
I am strugling to make a Multi Drop Down Search boxes. The main concept is to be able to make a search following some pre-defined dropdown boxes. I would like to search for a specific event in mathematics (for exampel) from a specific time (between different centurie).
- boex1 has a series of categories (Doctors, mathematicians..)
- BoxA has a range of centuries from 1500 to 2000 (1500- 1600...)
- BoxB has a range of centuries from 1500 to 2000 (1500- 1600...)
Im putting my website together, and I have made some simple text buttons that are aligned across the top of my page from left to right.Anyway, I have with this navigation a need to have more navigation options, which I hope to gain by having sub-menus appear when you roll over the button.
What I mean is how do I or can someone point me to a tutorial that will allow me to have a dynamic drop down menu generated via asp with data from a access databse that will allow the user to navigate to that sub menu content.
Hope you can help with a small problem I am having. I have a very simple table displayed on a page -
ID Name
1 x
2 y
3 z
and what I am trying to do is this - Roll over the ID number and display a pop up menu (which has more links to run other ASP scripts) and pass the ID number from the original page, though the pop-up menu and into the final ASP script (as selected on the popup menu) as a parameter for an SQL query.
I am trying to figure out how to pass one selectedIndex value to another select menu on a subsequent page without opening the page in a new window. I know how to pass information from one text field to another using Request.form or a Session, but I am not certain how this works with select menus. I have seen other examples that require you to open a new window, but again I would prefer not to do this.
I have two different select menus. This appears on the first asp page.
<form class="fbox-form" name="form" action="" method="post"
<select name="movietype" onchange="this.form.action=this.options[this.selectedIndex].value">
<option value='' "> </option>
<option value="dvd.asp">DVD</option>
<option value="tape.asp">Tape</option>
<option value="reviews">Revews</option>
</select>
<select name="area">
<option value=" ''> </option>
<option value="North">North</option>
<option value="Southwest">Southwest</option>
<option value="East">East</option>
</select>
<input name="continue" type="button">
</form>
The next page has the exact same select menus as above and I would like it to populate the same value the user chooses from the first form page. I should state that the first select menu does redirect the user to different pages, however it should not matter because the above options for the select menus are consistent on all the pages the user is redirected to. I'm assuming the answer to my query will consist of utilizing ASP and JavaScript, however if not, I'm still game.
Does anyone know where I can find any resources for dynamically creating pop out menus using a database backend for the links?
View Replies View RelatedCan anybody help me create a VERTICAL Menu bar please.
View Replies View RelatedI currently have a page with car manufacturers in a dynamic form menu. Users can select one and click submit to find available cars by that manufacturer. What i now need is a second menu on the page where when a manufacturer is selected, the models associated with that manufacturer display for a user to choose. For example if Ford is selected:
Menu One Menu Two
------------------ -----------------
Ford Focus
Fiesta
Ka....
Can i do this with ASP to say "if menu one is ford, menu two contains...."? Or is there a much easier way which i am somehow missing?
what is the best way to highlight menus...as in like being in a particular section? like this:
my menu is database driven and in order for me to show it selected, i have to put something like menuid=12 a querystring.
case.asp?caseid=1323&menuid=12
this is what i'm doing so far but it seems terribly inefficient. does anyone have any suggestions?
i'm trying to create a dependent dropdown menu based on two objects, packages and steps (the steps dropdown will be dynamically updated/populated when a package is selected). the site uses ASP and since ASP is server-side, i am using JavaScript to handle the client-side "dynamic" change.
i've found several snippets of code that create the dependent dropdown; however, the two examples i have use arrays which are statically defined. the data that will populate the dropdowns is coming from a SQL database, and that data will be updated/changed fairly often. my question is this: is there any way to generate the arrays using ASP (outside javascript tags) and use them in the javascript?
or is there a way to use javascript to generate the correct arrays and fill them with data from my SQL tables? can i use a recordset ojbect in javascript? i have heard that you may use PHP inside javascript tags, but i'm unsure if that is what i want to do.. especially since i am using ASP as the main language for this site. Code:
I've got a problem with asp.net i am trying to make a menu control. and have
searched the web for serveral controls but they don't work correctly.
I am pretty new to asp.net building. What am i looking for. i am looking for
code to make a dynamical menu with submenus The menu items are stored in a MS
SQL Table and when by loading the page the items will be created. i have made
a asp table. i want my menu on the left cell, in the middle cell i want to
change my pages to the menu item choosen. Code:
I have two menu form elements that need to refelect a parent child relationship. There are 85 zones and 2200 zone-network combinations.
I want to bind the networkid element to an xml datasource that contains only the networks related to that zone. I have read about something like this before but have never implemented it.
create table tblZone ( zoneid int, zonename varchar(20))
create table tblNetwork ( networkid int, zoneid int, networkname varchar(20))
<select name="zoneid" onChange="reloadNetworks()">...</select>
<select name="networkid">...</select>
I have four pull-down menus and a GO button. Each menu contribute a parameter to an URL query string (like asp?a=1&b=2&c=3&d=4) where variable a is return from menu1, b returns from menu2 etc.
I created the four menus using Dreamweaver's INSERT JUMP MENU function and I find it difficult to modify its auto-generated javascript code to suit my needs. Does anyone has the complete code to accomplish this?
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 Relatedi get the ref url that come to my site and i want to convert it to find
out what was the query in (google or other searcher sites)
foe example : if someone goes to google and search some text and my
site was in his resaults and he click on it , in my site i see his link
ref like
http://www.google.co.il/search?hl=i...91-Google&meta=
i want to know (in asp and save it to DB) what was the word or words
that the user write in search engine.
I am trying to create a parametric search within a table (in the column headings). My first page (search.asp) allows you to choose parameters from a dropdown box, such as package and volts. You click "search" and it reads the Access dbase to yield the results.
The results page (results.asp) displays the information based on the parameters. Under the package column heading, I have the same drop down box, and I am able to once again choose the package I want and the table will refresh. Code:
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 RelatedOn 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.
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>
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
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.
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.
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:
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: