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 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 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...)
I am trying to change another person's code. I googled my query and read a lot of ideas. But my problem is as I try to change one thing, someother code gets affected. SO I have decided to modify the code I have to do the task. Code:
View Replies View Relatedmy page works fine if the db search finds at least one record that satifies the query. but if it does not find a match I get the following error message.
Error Type:
ADODB.Field (0x80020009)
Either BOF or EOF is True, or the current record has been deleted.
Requested operation requires a current record.
What do I need to change here to make this just display the page with
no data? Code:
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'm trying to make a form that will pull details from a record that is found with (asset Number) but comes up with this error: 2342 "A RunSQL action requires an argument consisting of an SQL Statement"
Dim SQL As String
SQL = "SELECT *"
SQL = SQL + " FROM Computer"
SQL = SQL + " WHERE (((Computer.Asset)=" & TxtAsset.Value & "));"
DoCmd.RunSQL SQL
I am trying to create a very simple search functionality on my site. But I keep getting syntax error. Any one knows what I am doing wrong? Code:
View Replies View RelatedI have to make a site search function for my website. User types a keyword, and the search function searches through all the static pages for the keyword. The result of the search has to display the URL relating to the keyword, which the user can click to read the contents.
I had no idea how to go about doing it, finally I thought of using a textfile containing the word, and its related URL in the format: Code:
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 RelatedI got an error saying
Microsoft VBScript runtime error- Error '800a000d'
Type mismatch
/briansforums/default.asp, line 923
also another error called Code:
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.
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:
I have a dropdown box populated with a list of parents names on a page, and when you select a name, it uses the onChange method to change the names of students in a second dropdown box on the same page (this is done through stored procedures and it does not submit to a new page. this is all done on one page).
My problem is I do not want the student drop down box to appear until after the parents name is selected.