2. ASPRunnerPro General questions
  3. FullText ( contains) dont! work!
This topic is locked

FullText ( contains) dont! work!

 		6/27/2008 11:29:02
ASPRunnerPro General questions
V
 virtualkaiser author

in the page ............. mypage_variables.asp i need you searh FullText ( contains) with SQL

<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=8866&image=1&table=forumtopics' class='bbc_emoticon' alt=':blink:' />
gstrSQL = "SELECT FROM AllData WHERE CONTAINS(, '"$strSearchFor"')"
this is ok ?

<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=8866&image=2&table=forumtopics' class='bbc_emoticon' alt=':unsure:' /> please help i need you multiple search in the advange page!
Sergey Kornilov admin 6/27/2008

You need to use BeforeSQLQuery on the list page for this purpose.
Check generated ..._list.asp page to find correct name of the variable that contains search string.
V
 		virtualkaiser author 6/29/2008

You need to use BeforeSQLQuery on the list page for this purpose.

Check generated ..._list.asp page to find correct name of the variable that contains search string.


Sorry! but i dont understand! please... send me one sample! please...

Tks!
J
 		Jane 6/30/2008

Hi,
you've mixed PHP and ASP code.

Also you've missed field names in your SQL query.
I recommend you to use variables from BeforeSQLQuery event in your code. For example to add where clause to teh SQL query use this code:

strWhereClause = whereAdd(strWhereClause,"FieldName='test'")