Basically, I want the user to be able to select criteria on the asp page for their search and then those that match will be shown. I don't know if form is the best way or another method.
Does anyone have any ideas for good resources or know how to do it?
Example:
The database is of stock homes. User can select sq. footage, price range, home style, # of bathrooms, # of rooms, location, etc.
After user submits criteria those homes that match criteria will show.
I'm using APS VBScript web page on an Access2000 database and I am trying to select from a recodset using a date as the criteria. I keep getting ADODB Data Type Mismatch errors no matter what I do to the database field (which hold a date/time) or the URL. My URL looks something like ... result.asp?id='3/20/2005'... The database field is an Access date/time field formatted to mm/dd/yyyy.
I am currently developing a project for a bus company to book seats. I have started this program but have ran into a problem as need to search a criteria e.g. Name , date, Telephone etc so i can choose to edit or delete the record.
I need to use a txtbox to search for the record as their will soon be thousands of records so i will need to search for a record by a criteria to either delete or edit the record i hv uploaded a copy of my http://www.angelviewinn.co.uk/smithy330/customers.mdb i am using it is very simple.
i'm looking to select records based on date, the database stores the date as mm/dd/yyyy time am/pm ie: 08/11/2004 2:42:28 PM and unfortunately the field is called date
this much I know if i want to select based on date:
select from table where [date]=
it's my understanding that i need to put the name of the date field in [] in order to prevent it from confusing it with functions etc... however my problem is this
how do i get it to select records from the month of december i have tried [date]='12/*/2004' and [date]='::12/*/2004::' and many other variants that i have read about on various web sites, but it never seems to work once again the answer is probably not as complicated as i believe it to be,
I am trying to make my update page work, but when i submit the form it comes with this error "mismatch in criteria expression" and the problem i think lies on one of my menu list that is joined to another table in the database.
I have a combo box in an ASP page, there are 7 lists total in the combo box, there is another text box on the page and a search button. I want the users to select an item from the combo box and type a keyword and click search.
The combo item and keyword will be used as an criteria to query a SQL database. I'm familiar with SQL connection and running queries but how do I take the criteria and pass on further.
I am trying to change an existing function that currently only displays records that fall under a criteria of
NOT(now>cdate(OTDate & ' 2:00 AM')
If I wanted to change this function to display entries that are before 6:00 pm the day before the OTDate, how could I modify this part of my code? should is be something like this...
Is it possible (and if so, how?) to have an asp form page that based upon a user's selection on a field, would generate a input field b that the user selects?
For example:
User selects "name" in a select statement which would list the possible names to select from or if the user selects "telephone" in the same select statement then it would list the possible telephone numbers to select from.
Or simpler:
If user selects A then show P to select from or if user selects B then show Z to select from.
Noob question I'm getting errors with the following code
Code:
processevent = Request.QueryString("processevent") SQL = "Select * From shimlog Where ID = '" & processevent & "'" Rs.Open SQL, Conn, 3, 3
Is giving following error
Microsoft OLE DB Provider for ODBC Drivers error '80040e07' [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. /area51/shimlog.asp, line 53
Read MS webpage and using some :'s in there somewhere could not get it to work
This should be an easy one, but I can't figure it out. I am getting the error: Data type mismatch in criteria expression.
Here is my SQL:
SQL = "UPDATE Revision SET Contact='"&Contact&"', ID='"&ID&"', TR='"&TR&"' WHERE TrackingNum='" &TrackingNum&"'"
TrackingNum is an autoNumber in two of my tables in my database (IME_request) the table names are revision and IME_request. I pull the data from IME_request.IME_request and then I update IME_request.revision with the form values.
I did a response.write to make sure I was getting to form values, and I am.
I am trying to search for clients contained within a database using multiple search criteria that the user is able to select using a front end form.
The user is able to select there criteria by selecting one or more check boxes and the results are thus retrieved based on what the user has selected. The search works fine until you try and select multiple client types Code:
I am trying to test a sql statement in Access which gives me the error as stated in the heading.
The sql statement is built as a part of asp login verification, where the userid and password are input in login screen. The password in the database is a number field.
I am writing the dynamic sql statement as follows below. I believe I am going wrong in the password section of the code:
I have a recordset that I loop through all of the data within a table, within the same loop, I am trying to add another loops that pulls information from the first recordset to base the second recordset off of: Code:
I have written some code which should dynamically build a table which is then populated with questionas and possible answers. The format of the answers will vary ie they may be in the form of a radio button which will be rated from 1-5, checkbox or a selectbox.
The first problem I have is if I do not comment out <select></select> I get an error message saying the page can not be found. when I do take it out I get asp timeout. Code:
i have a record that is returned by the database as domain/username. i want to be able to strip off "domain/" and just display "username". is this possible? if so, how would i go about doing this?
i don't know what to do here exactly. i have seen the TRIM function, but i'm not sure if it's the right way to do it. i have a recordset called RSUSEREDIT. in the recordset there is a column called "EMail". i can print out the results using Code:
<%=RSUSEREDIT("Email")%>
the email column always uses the same domain name... - username@domain.com is it possible to remove the part after and including the "@"?
I have a URL... everything returned by the url, I need to write to a file. lets say its 40 lines of text... how can I write it to a text file and save it??
I'm creating a site that pulls details from a database & display it on screen. Problem is that there's sometimes loads of data which makes the page huge. What I want it to do is display ten and a next page link to display the next ten. Like the way Google displays results. Problem is I don't know how to generate pages on the fly. So the question is can it be done and does ne1 know how to do it?
First, thanks to all who have helped me over the last few weeks !! I have a form that allows the user to select multiple options. These are user names:
Fred S Bob D Paul G Dave O
When the form is submitted, I'm getting the details using
user = request.form("user")
this is returning the mutliple options. What I would like to do is pass all the options to 'user' but at one point on the results page only show the first user selected, not the multiple selection
what is an easy way to go about sorting my search results through links, you know, like clicking the link at the top of a column. i know how to pass the order by in a querystring:
but what about all the other links? what do I do with the previous querystring entries like lastname, firstname, and state? i find if i add orderlast to my lastname column and i click on it, i will have 2 orderlast querystrings
I'm using multiple recordsets on a page, and they are all returning correct results and enough of them. My problem is when I try to access the recordcount property rs.recordcount, they all return a result of -1. This would usually mean that no records are returned. So why is showing my recordsets that are displaying records with recordcounts of -1. I can't seem to figure out.
I know how to display results that contain html code on a page. (ie. <br> <b>...)
what i would like to know, is if a result contains bbc code (ie.. [code] [url]..) how would i display that to be readable?
This is not for a forum, but would be the same as if i was writting a forum. I think there is a script that the page has to contain to be able to read it correctly, but I can't find it.
My SQL statement won't return results where any field in a record is blank. What can I do to fix this?
strSQL = "SELECT * FROM newarchive WHERE Program_Title LIKE '%" & program & "%' AND Year_Aired LIKE '%" & yearA & "%' AND Sponsor LIKE '%" & sponsor & "%' AND Month_Aired LIKE '%" & monthA & "%' ORDER BY ID"
It gets its values from a form where some fields can be left blank. If the record itself does not have a blank field, the search will pick it up. But if the record contains a blank field, then it won't be selected unless it matches the Program_Title data.
