Code:
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'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 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 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 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 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 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'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 RelatedI 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 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 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 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;"
/>