2. ASPRunnerPro General questions
  3. advanced search - Help me!
This topic is locked

advanced search - Help me!

 		6/22/2008 8:28:34 PM
ASPRunnerPro General questions
V
 virtualkaiser author

hello! i need you search in the advanced search page search one or more text en all field of database! for example:
Database SQL

ID ColumnA ColumnB ColumnC

1 printer soft router

2 mouse LCD speaker

3 soft phone printer
in the advanced search, for example search for printer and soft

and the result is :
page result i need you see :
ID ColumnA ColumnB ColumnC

1 printer soft router

3 soft phone printer
tks!
Sergey Kornilov admin 6/24/2008

I recommend you to use basic search function and BeforeSQLQuery event. In this event you can split search string and build a corresponding SQL query.
For example, someone enters "printer soft" in the search box. You can build the following query:

select ... from ...

where (columna like ('%printer%') or columna like ('%soft%')) and

(columnb like ('%printer%') or columnb like ('%soft%')) and

(columnc like ('%printer%') or columnc like ('%soft%'))
V
 		virtualkaiser author 6/24/2008

Tks! this is correct i now! but ...for example in the page ..\include\mypage_varible.asp !!! this is not work....

and in the simple search ..... in teh combox ...two words... for example printer soft !!! dont work ???

help me!!!! i need searh 2 o more word in the simple o advanced search..... i need help o and example file tks! <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=30560&image=1&table=forumreplies' class='bbc_emoticon' alt=':huh:' />
Sergey Kornilov admin 6/25/2008

Contact support team directly at support@xlinesoft.com supplying your order number or registration email.