i am doing a database search project. and i would like to know how do i get exact keyword searched from the database. for e.g. if the user enters keyword as "lan" to be searched it should return only records that contain exact keyword "lan" and should not return "plan" and other words like that.
View RepliesI have been searching for a way to search a database based on keywords. All I can seem to find is google searches. All I want to search is my own database.The db contains inventory for a friends store. As list is long he would like to be able to search an item based on item name, supplier, or type.
View Replies View Relatedregarding EXACT search. i want let user search with ANY or EXACT match. i had done any with
instr(products, '"&st&"') > 0
where products is my database field, from where search result come and st is the search string entered by user. now want to provide EXACT search. e.g. machinery will match only machinery and not machine, machineries, machines etc. i had tried LIKE predicate. is there any other way to provie EXACT match ?
i m doing a custom search. i have included SEARCH USING:
1. ALL OF THE WORDS
2. ANY OF THE WORDS
3. EXACT EXPRESSIONS
i m not able to have the search results using option no. 3 EXACT EXPRESSIONS. how to do that thing ?
I've got a search query that involves a kewyord input that searchs 2 db feilds. It works fine if you use one word searches, but draws no records if you have 2 words. How do I set up a search that can include multiple words or multiple individual letters etc... Code:
View Replies View RelatedI am using a keyword search facility which uses the SQL Like operator. The problem with this is that if I enter the search keyword evil, it will match the word devil. I want to match the string from the start of a word, not in the middle or anywhere else. Can I achieve this using wild card operators? If so what is the format?
View Replies View RelatedI read a text file in ASP using readline. The line is stored in a variable. I want to be able to search that line for a specific word.
How do I go about this?
How do i add a keyword list to my website to make it searchable using a user key in certain keyword for a search engine?
View Replies View RelatedI'm uploading a file locally and I'm trying to passing it throug a variable and I'm having a problem with locating the exact file name from the upload_document page. I thought is was "r_title" but for some reason the file name isn't stored there.
View Replies View Relatedim defining a cookie as so:
Response.Cookies("something")("value") = "value";
now i want it expire in 20 minutes.. how do i do that? i tried to give the .Expired property a date object but it faild.
I am using ASP to query access db on IIS5
I need to find exact matches for search terms within a string. EG "cat" will find cat but not catastrophe from within a large string.
I cannot use "=" as that would match the whole string and I only want to find the exact match within the string.
I am trying "like '%[!a-z][search term][!a-z]%'" which is pretty clumsy and also doesn't pick up the search term if it is at the beginning of a sentence.
Can anyone help me with the syntax here? I have racked my brains coming up with all sorts of convoluted solutions that all end up having a flaw. I have been looking around ASP fora and it seems a few people are asking the same question but getting no answers. (you might see my question in some of them...) I am sure there must be some operator within sql as there is in FMP but I cannot find it.
i want to provide exact match. e.g. if user enters pharma machine result only display records containing pharma machine and not records containing either pharma or machine.
database table: company_info
database field: products
user entered search (field name): st
i had tried the following
select * from company_info where products like '"&st&"'
but is shows the wide result
Here's the problem I'm running into:Code:
Set RS = Conn.Execute("SELECT TOP 10 id, score, numvotes FROM [user] WHERE active = '1' ORDER BY (score/numvotes) DESC")
Simple query, nothing to fancy. However it doesn't order highest to lowest correctly. Here's a sample output:
10.00
10.00
9.63
8.00
8.25
8.00
7.00
7.82
7.42
7.86
As you can see it's not correctly ordered from highest to lowest.
I have been thinking about this wee problem for a while now, and usually I figure out what I need to do, but in this case I'm drawing a blank And the most annoying thing is that I don't think it should be that hard! I use this code to search a database: Code:
View Replies View RelatedMy setup is going to be like this:
I have one page that has a few categories on it. When the person clicks on one of the categories it sends the querystring to the next page. That page takes the query string, searches the database and only replies with found results. Thats what I'm trying to setup, I think I'm very close.
I know the request.querystring is being sent properly and receieved properly, because I also have it's name displayed on the next page and that works fine. I know my connection to the database is okay, becasue if I just set it to display the entire database that will display fine.
It's when I try to use the Request.QueryString that was sent to search the database - it returns like it can never find anything. The page displays, no asp or coding errors - just no information.
The database Column I'm trying to have it search is called "Classification". I think that's all the info.. if I'm missing something you need to know let me know. Code:
Does any one know of any good asp database search scripts. What I'm looking for it to search the database on different criteria or phrases. Eg Kane 400 Boiler.
The user could put in kane 400 and it would pick it up, basically something that you don't have to put in the search how it appears in the database, I have worked on this and works fine if you put the exact phrase in, or one work but if i put in kane 400 it does not work. Also if I put % it lists the whole database, this database will hold 10000 > products so want it not to be to heavy etc.
I'm trying to use information that a user enters into an HTML form to search a database. For example, if a user clicks on a check box stating their interests are 'holidays' then this information needs to be used to search the database for entries that match, ie the entry has a category that states it is about holidays.
The entries in the database are linked to pictures that will then be loaded onto a website.
I'm having a problem with a simple search. I have a telephone directory where people can search by first or last name. This works great but when someone tries to search for a name with an ' in it you get an error.
Here's my code for the database connection:Code:
sql = "SELECT Staff.[first_name], Staff.preferred_name, Staff.no_location,
Staff.[last_name], Staff.[location], Staff.business_title, Staff.department,
Staff.phone, Staff.fax, Staff.[email]
FROM Staff WHERE (((Staff.[last_name])like'%"
& Request.QueryString("[search-lastname]") & "%')) "
I'm certain it's just a syntax error so hopefully someone can spot it quick. Using a - in the name search doesn't bring the error.
I've created a search bar on my site to search a database with job information. I dont know what i am doing wrong, i just want what the user types in to display after pressing search. I thought all i would need is Code:
View Replies View RelatedCode:
uery="select top 21 * from profile where enabled='yes' order by mating desc"
I cant get this to woek , it shows all the records when i just want it to show top 21 records based on column mating. I am using access database. Does top keyword work with access?
I am looking for an ASP script that let me to serach all database contents with only one textfield in search page. eg: I have a database with five columns for lessons: Mat, physics, geography, history and sport. Each field have numbers 1 thr 5. I want to search only those students have number eg:3. with entering the number in textfield in serach page. I have no problem in result page.
View Replies View RelatedI would like my ASP-based site to have a search box to bring up a list of relevant pages according to user-defined search criteria.
Q: Do I need to have a d/b like SQL Server 7 at the back end to process and match the search string? Or can I do w/out a d/b somehow and run a search, and somehow still bring up the same results?
If a d/b isn't necc, pls. advise on webpages where I can find such ASP-search codes.... TQ!!
I have built a small cms driven website using asp and access database. There is nothing special about it, it has about 5 tables each containing unique data.
I want to add a search field on all pages which will search the entire database and present the results.
I have been searching for hours now and cant find a script that suits my needs. Can anyone point me in the right direction or reccomend a script?
I have a page that uses the data from the previous pages form to search the data in the database and dispaly any matching results.
On doing so i get this error:
Error Type:
Microsoft VBScript compilation (0x800A03F9)
Expected 'Then'
/IT/searchresults.asp, line 20, column 15
If Request.Form"(Typesearch") = "computer_name" Then
My statement has a then in the statement already.
I'm having trouble figuring out how to do a freetext search in my ms access db table. Code:
View Replies View RelatedWhich is better practice?
Code:
Select * From groups Where groupName LIKE '%bli%' AND cusType LIKE 'CUST%'
or
Code:
Select * From groups Where InStr(groupName,'li')>0 AND InStr(cusType,'CUST')=1
Right now I'm using and Access database but plan to upsize to a MSSQL if that makes any difference. Are there any advantages or disadvantages to either technique?
I would like to get asp code for searching database.I have data in Ms Access. I want to search by catagories. A dropdown list to choose to narrowdown search. If keyword found, create a hyperlink of the location so that easy to view.
View Replies View RelatedI want to do a searching on database some tables' content, is asp have so function or tool to do this?
View Replies View RelatedIm looking for a means to allow the search criteria provided by a user to be checked against fields in more than one recordset table in a ms access database.
Is there a means within asp to check multiple tables at the same time using one set of criteria? So far the only solutions i've seen to this includes the usage of a list box which dictates which recordset is opened. I would like to avoid this.
I am looking for a asp script, that will do an OR search on keywords in two differant columns in an MySQL database. for example if someone searches for joe bloggs I want to bring back all records that have either of the words joe or bloggs in column one or column two.
I have found a script that does exactly what I want but it will only search one column of a database whereas i would want it to search two columns. http://www.4guysfromrolla.com/webtech/052799-1.shtml
how to modify this code or point me in the direction of some other code that will do the same job.
I'm trying to find a Sql query to find a word in all the data of all tables of an microsoft access DataBase.
View Replies View Relatedcurrently doing a wep application that contain of search engine. i did browse through some web applciation's search engine, notice that they can highlighted the keywork for searching when they display the search result.
example,
when i enter keyword 'test' in my search engine and preform search, let say i found a file called testing.asp, i want the word test to be highlighted. may i know how can it be done?
I have been told that I must not use the set keyword if that is the case then what would I use? Has anyone ever heard of that?
View Replies View Related