Contains sql and ASP

[mickywall]

test=request.querystring("search&quot
'start the sql string
sqlstr = "SELECT Distinct Email,Name,Keywords,About,Url FROM [livingscience] WHERE CONTAINS(KEYWORDS, '" & test & "');"


i am getting a syntax error..

 

[malexanian]

That is not what an ASP querystring is.

The Response.QueryString object is a string representing arguments submitted from a form on a web page. This has nothing to do with SQL Server.

 

[mickywall]

what i am doing is using what has been entered into a textbox and submitting that value into the sql string and executing it against a sql server database using the contains function and full text indexing...
surely this has something to do with sql server...

 

[sunila7]

Hi,

What is the error u r getting ..

Sunil

 

[mickywall]

i got it sorted...
sorry if i got the wrong forum though i thought my SQL STRING was wrong.