I 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 RepliesI'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 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?
I 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 RelatedHow 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 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 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?
currently 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 Relatedi want to develop a small application which will generate a list of
product from a database based on a user web page contents. something
like google adsense but not that extensive. any help or resource
available?
any guidelines. i want to use ASP , access or SQL server .
in short a script page, when called, read the contents and search a DB
for products and diplay it .
I have a table with two columns. ftr_sampler is set as varchar(255). I want the script to search for similar keyword in the ftr_sampler.
sample table:
id ftr_sampler
- -----------
1 I like to eat apple.
<% if RS3("ftr_sampler") = "%apple%" Then %>
Id 1 like to eat apple.
<% else %>
Id 1 does not like to eat apple.
<% end if %>
check the "keyword"s in the attachment? For some reason it's not coming on top of the iframe as I expected to. Could it be that the "action" in the <from> is missing or what?
View Replies View RelatedI'm using the code on:
http://www.aspfree.com/c/a/ASP%20Co...n-by-Meraj-Sami
I want to use two colors on two keywords, one in red, the second in blue.
This is the result:
http://n.1asphost.com/wheelofgod/highlighting.asp
there is a third color with a third keyword but,never mind that.The problem is that it's restarting the text once it has found and replaced the keyword in color.
Is the keyword 'as' supported in ASP? I'm reasonably sure it's valid VBScript (code examples I've downloaded use it) but when I try to use it in ASP I get an error. Is it perhaps a version issue?
View Replies View Relatedi want to search a database containing the keyword entered by the user.
i tried this code:
myquery = "SELECT * FROM articles WHERE author LIKE '%" & Request.Form("keyword") & "%';"
but this one only searches the "author" field. i want asp to search the entire database regardless of the field.
I'm a user of ADO 2.8
Difference between declaring a RecordSet
Dim rs
Set rs = Server.CreateObject("ADODB.Recordset")
and
Using the Set keyword when expecting a RecordSet to be returned during a Command.Execute
Dim rs
Set rs = cmd.Execute 'cmd is a ADODB.Command object
Why is there a need for this?
Im doing a text search, and i need to highlight the word which is being searched for in the results page. How do i do that?
View Replies View Relatedcheck the "keyword"s in the attachment? For some reason it's not coming on top of the iframe as I expected to. Could it be that the "action" in the <form> is missing or what?
View Replies View RelatedCan you please check the "keyword"s in the attachment? For some reason it's not coming on top of the iframe as I expected to. Could it be that the "action" in the <from> is missing or what?
View Replies View RelatedI am now all of a sudden getting an error in this sql connection
string, saying that the Provider keyword is invalid:
<add key="MM_CONNECTION_STRING_isox"
value="Provider=SQLOLEDB;SERVER=xx.xx.xx.xx;UID=xx;PWD=xx x;DATABASE=xxxx;"
/>
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 list of songs in table in asp page. I would like to put a link to each song so when user click on one I can search database for it's data. How to do that?
View Replies View Relatedi have a database with 5 tables,
on my web site i have a search bar..
i wana link that search bar to my tables so..
when ever some 1 searchs for a product, the search bar shows that all the simmuler products to what they searchd for..
I was wondering if there was a way to search pages using ASP or ASP.NET.
I have roughly 5000 static html pages (an online library of sorts) and wants a serch feature. Is there any way to do this?
how to search within the selected category?? Example : Search "bubble clock" in category,Clock and watches.
View Replies View RelatedI have a search page that has ms frontpage database wizard results showing. The thing is, is that I want to have the search form on other pages besides my search.asp page. Does anybody know how to make a search form on a seperate page that submits the search to the database and displays the wizard results on the search page.
View Replies View RelatedNeed help here~ =) ..For -> while not rsConfiguration1.EOF ... blah blah blah
How to write my code so that even if its not End of record, it will still search my db?
In short : I want the db to be able to search under 2 circumstances : EOF and not EOF
How could I try and make the most important result from a search show up on top?
I was thinking of having a result where the strSearch is the most to the left come up on top but else then that vague and not necessarly effective option I have no idea on how to do this.
Intranet tech support system using ASP/VBScript running on W2000 Server,
IIS, and using SQL Server 2000. I need to add a search engine. The problem
with using a regular SQL query is that if you put a phrase, say "red car" in
the text box, to hit submit, my SQL qurey would only look for that phrase,
and would leave out other items where the words red and car appeared
separately. I guess what I am saying is that I would like something like
Google or other search engines, which would find results which seem to fit
the criteria typed into the box, and rank them and highlight key words.
My research so far has shown me that SQL Server has something called
Full-Text searching, and I have tried to read up on that in BOL, but not
really seeing how I can apply it. I wonder if there's already some tutorials
or sample code out there. I have done some looking on the Web, but still
haven't found much.
I have created an asp server page as described in the
Microsoft Article 318387 HOW TO: Query Index Server Data
by Using ASP in FrontPage 2002
(http://support.microsoft.com/?id=318387)
It is running off my IIS server for the search results.
However, the results return only file locations; I would
like it to return a link to the hits. How would I do this?
im now doin a search function... but my problem is... if i didn't enter any data in the textbox and then click search button, it will appear all list from database instead of display "please key in data".
I just want to display "please key in data" but not display all records. Code:
I'm make a search and I want to limt the results to 10 and have a next button.
View Replies View Related