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 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 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 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 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...)
<%
MyAspString = "HELLO"
%>
<script language=vbscript>
sub RUNCODE()
MyVBScriptString = <%MyAspString%>
msgbox MyVBScriptString
end sub
</script>
Is this possible and if so how can I amend the following line to get it working:
MyVBScriptString = <%MyAspString%>
i want to extract the number 38 from the URL below, using ASP what is the solution?
then store it as a variable.
http://pcol-webtest/default.asp?nc=4098&id=38
I have a parameter, directory, which has value of "dir1/dir2/dir3". How can I extract the values of dir1, dir2, and dir3 from the directory="dir1/dir2/dir3". ?
View Replies View RelatedHow do I do the following action in asp:
Suppose I have a string of word which I have pulled from my MSSQL database - "Super Fine Quality"
But I don't want to show the entire sentence "Super Fine Quality" in my page. I just want to show the word "Super" only, ie I want to display only the first word of the sentence regardless of it's length.
Without manipulating or doing anything in the MSSQL database, is it possible to remove the words "Fine Quality" and show the first word of the sentence "Super" only with the help of asp code? If yes please let me know how.
I have a variable named DressCode. The content of this variable is something like N040602
I want to split this variable into four parts:
DressCodea would be the N part
DressCodeb would be the 04 part
DressCodec would be the 06 part
DressCoded would be the 02 part
How do you do this is ASP, so it'll split the variable, no matter what the content is, as long as it is that format (ie 1 letter then 6 numbers).
I spend more time with other technologies. Could someone please help me with how to hide sections of content on an ASP page? Please keep it simple. I prefer code examples or at the very least point me to a place on the web that can.
View Replies View RelatedThe 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 have an ActiveX control in my ASP page that has not been signed yet, so currently just for testing I set the Security for Intranet to "Low". When I run the ASP page on my machine (the IIS is in my machine), I have no problem, except the page prompted me with "An ActiveX control on this page might be unsafe to interact with other parts of the page. Do you want to allow this interaction?"
But, when I run the ASP page on another machine (even though the other machine is also a development machine that already has the ActiveX control and I set the Security for Intranet to "Low"), it did not prompt me the above message, and I got an error when accesing any method of the AX control (e.g Object doesn't support this property or method 'myAXControl.method').
Is this because I have to create a CAB file and mark the AX control as safe for scripting ?To create a CAB file for this AX control, do I need to create my own VB AX
Control project that contains this control and then create a cab file for this VB project ?
i 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:
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:
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.
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 RelatedI 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"
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 RelatedI 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 RelatedI 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.
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 RelatedI 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: