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 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.
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 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:
this is a word search i.e. every word entered as search keyword should be searched in the database...
since it is a word search, i tried to split the string entered as search keyword, and then search for each splitted word in the database.
It worked for only a few records present in the database. some 1034 records were searched out of 1914 i tried the same procedure in PHP and that worked.
I'm having some problems using like to find items in my database for some reason its not finding anything if it has a space in it. Here is my SQL query:
SELECT * FROM Employees WHERE FirstName LIKE '%Dennis Smith%' OR LastName LIKE '%Dennis Smith%'
In this query i'm searching two fields for any occurance of Dennis Smith whom i know is in the database however no results are returned. Also if i just search one field and the search string has a space in it, no results are returned.
I'm trying to design a simple website with 2 dynamic searching functions. The first is the user enters text into a search box, clicks on the search button and then connects to a sql or access database and brings back those records that are LIKE the search phrase. It's my intention to then have a detailsview link on the searches so the user can drill through.I'm designing an online version of my catalog so that the user can browse by page. I also want the user to enter a page number and then click go and that would then take the user to the corresponding page in the catalog. I'm guessing I'll need to declare If 1 then open page1.html, if 2 then open page2.html. I know I'm close but not close enough and my knowledge has been well and truly stretched and I must have read and read my Dummies book about 20 times over the last week.
Just wondering the best way of doing this? are there any dictionary databases laying around somewhere?
I want to change my search so that it corrects typo's and maybe suggests better words to search with... like googles but with more alternative words to make the search more useful - slightly limited so it doesn't become pages and pages of search terms.
What I don't want to do is sit down in front of my computer and type all of this in, going through related words and possible other searches / best searches from the given input.
I need help in retreiving data from database. my form consists of some checkboxes, for eg:- in my form for location three check boxes are there and for the type of house four checkboxes.(houses,apartments,offices etc).Below is my form,
London (north of river) (checkbox here)Central London (checkbox here) Docklands (checkbox here)Ealing, Chiswick & Acton
Number of Bedrooms(text box here)
(checkbox here)Houses (checkbox here)Apartments (checkbox here)Developments & Land (checkbox here)Commercial
My databse consists of all this information. If the user want 2 bedroom flat or apartment in central london he will check central london, 2 bedrooms, house and apartment. for this i need an sql query to retrieve from database the appropriate property they are finding.
A client uploads a document (a msword .doc file) to the server, I need to search a string that document and find specific words in it (this is an Application to a School, most of them look the same, so all you can do is replace the school name in the application, but sometimes people forget to do so and get rejected for sending inappropriate application). So I need to find in each Application possible names of other schools and alert about it.
I'm writing in ASP (I can use ASP.net as well) I DON'T HAVE ACCESS TO THE SERVER (it belongs to the hosting company, and there's no way of installing anything there)
I have a simple intranet for the company I work for and I am attempting to create a phone listing and search tool for it. The list has a simple 500 record access db.
Presently I have a page which displays the entire db. What I'd like to do is have a form at the top of the page that lists the entire db where a person could type in any word... Name, office location etc and have the result ported out on a new page with only items matching the search criteria. Code:
I have a database which has a field called "title". I have made a text input box and set that user submitted text to a variable (call it textvar). How do I say something like this...?
Set rs = conn.execute("Select * from workitem where title contains '" &textvar& "' " )
Of course the word contains is just a guess on my part.. other ideas are "is like". What function/syntax will give me what I want, which is for it to return any title that has the words entered by the user?
I want to search for UserID in 3 table. Searched UserID wil be present in one of any 3 table. Using select * from <table> where UserID = < =userid> allows me to search in only 1 table.
Is there any way .. to join 3 tables and search for the UserID using single SQL Query
I have a code that compares the value in the textfeild of a form with the value in the database table
do until rsData.EOF if trim(rsData("core_contact_fname"))=trim(request.form("txtNumber1")) then%>
i would like to do two things to it one is to compare the two values while ignoring their cases(ignore case) i am not sure how to use the ignore case function.
I also want it to comapre if i want to search for say"L" I should get all the names starting with L from the database.
Has anyone had dealings with setting up website postcode searches such as one that would let a visitor input their postcode and specify a 'within the range of' value such as 20 miles and then be returned a result.
I have an asp page that allows visitors to input their postcode into a field which then refers to an Access tbl and displays the results, but only if there is an exact or LIKE match within the db.
I want to offer the facility of letting them increase the radius if they are unable to find a result matching the exact postcode. Code:
I know how to use the LIKE command in a query but how do I do it in the results of a recordset results="<b>Hello</b> World"
I want to search the above result and if it has a <B> in it, I want set hasabold="Y"
I need to be able to search through a large amount of text so the BOLD marks will not always be at the front of the results. They maybe be on line 50 character 59,
