Hi all !


i need to implement a search facility....for this i am asking a user to enter details in a text box...


PROBLEM


The backend should be able to take the string and based on what has been entered in the text box see if there are any "AND" , "OR" in the

string .....and then execute the query based on that ....

the code that i am using to find out the "and" or "OR" is

dim indkeywords(10)

k=1

for n=1 to len(keyword)

ch=mid(keyword,n,1)

indkeywords(k)=indkeywords(k) & ch

if ch="and" then k=k+1

else

if ch="or" then

k=k+1

end if

end if

next

but this doesn't find the "and" or "OR"


any ideas ..or if there is any other way of doing this ...i would very much appreciate the help


many thanks

daksh

[email protected]