Asp Sql Search

[colinod]

I have a database setup so that we can search audio files using our inranet the problem is if i want to search for more than 1 word e.g. if i search for yourkshir it returns all the items with yourshir listed in the type for the sound file but if i want to search for yorskshire and loud i do not know how to do this i have types set for sound files that include the words yorkshir and loud but cannot find any of the clips if i type both words in the serch box

here is the sql statement

<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<%searchid=Request.Querystring("id")%>
<%
Response.Expires=0
Set yaketyConnection=Server.CreateObject("ADODB.Connec tion")
DatabaseDetails="DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.Mappath("yakety2.mdb") & ";"
yaketyConnection.Open DatabaseDetails
yaketyQuery="SELECT * FROM mp3 WHERE celebname like '%"&searchid&"%' or mp3type like '%"&searchid&"%' or mp3typeb like '%"&searchid&"%' or mp3typec like '%"&searchid&"%'"
Set yaketyRecordset=yaketyConnection.execute(yaketyQue ry)

dlQuery="SELECT * FROM mp3 WHERE celebname like '%"&searchid&"%' or mp3type like '%"&searchid&"%' or mp3typeb like '%"&searchid&"%' or mp3typec like '%"&searchid&"%'"
Set dlRecordset=yaketyConnection.execute(dlQuery)

%>

I hope someone can assist

[jeffstl]

I have a database setup so that we can search audio files using our inranet the problem is if i want to search for more than 1 word e.g. if i search for yourkshir it returns all the items with yourshir listed in the type for the sound file but if i want to search for yorskshire and loud i do not know how to do this i have types set for sound files that include the words yorkshir and loud but cannot find any of the clips if i type both words in the serch box

here is the sql statement

<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<%searchid=Request.Querystring("id")%>
<%
Response.Expires=0
Set yaketyConnection=Server.CreateObject("ADODB.Connec tion")
DatabaseDetails="DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.Mappath("yakety2.mdb") & ";"
yaketyConnection.Open DatabaseDetails
yaketyQuery="SELECT * FROM mp3 WHERE celebname like '%"&searchid&"%' or mp3type like '%"&searchid&"%' or mp3typeb like '%"&searchid&"%' or mp3typec like '%"&searchid&"%'"
Set yaketyRecordset=yaketyConnection.execute(yaketyQue ry)

dlQuery="SELECT * FROM mp3 WHERE celebname like '%"&searchid&"%' or mp3type like '%"&searchid&"%' or mp3typeb like '%"&searchid&"%' or mp3typec like '%"&searchid&"%'"
Set dlRecordset=yaketyConnection.execute(dlQuery)

%>

I hope someone can assist

Not with only 1 search parameter like that.

You will need atleast 2 search boxes, OR you will need to set your search up to handle a deliminated search in 1 search box (Like with a comma delimation such as yorkshir, loud)

Either way you go once you have both parameters then just do this with your query.

yaketyQuery="SELECT * FROM mp3 WHERE celebname like '%"&searchid1 & "%' or celebname like '%" & searchid2 &"%' or mp3type like '%"& searchid1 &"%' or mp3type like '%" & searchid2 & "%' or mp3typeb like '%"& searchid1 &"%' or mp3typeb like '%" & searchid2 & "%' "
 
'and so on after that for your type c, etc....
 

[colinod]

Thanks for that does that mean that if we enter three words in the search box like yorkshir, loud, male that i would need 3 search ids one for each delimited word, if this is the case would you know how to find and posting of any of the words entered in the search box in a string of words i.e. if we typed yorkshire, loud, man could it find yorkshire man and loud even if they were not together in the searched field i was thinking of setting up a search field in my database and just adding all the words we would like the sound clip to be found under.....

[jeffstl]

Thanks for that does that mean that if we enter three words in the search box like yorkshir, loud, male that i would need 3 search ids one for each delimited word, if this is the case would you know how to find and posting of any of the words entered in the search box in a string of words i.e. if we typed yorkshire, loud, man could it find yorkshire man and loud even if they were not together in the searched field i was thinking of setting up a search field in my database and just adding all the words we would like the sound clip to be found under.....

I am not clear on what your question is.

If you need to know how to seperate the string out if you are using comma delimination (though depending on who your "users" are multiple search boxes will be much better) ...but with comma delimination with 1 search box you have to use the split function and string manipulation functions to get each seperate word into a variable.

http://www.w3schools.com/vbscript/func_split.asp

http://www.thescripts.com/forum/thread781497.html