Okay, I've tried everything everyone has suggested and can't seem to get it to work,
so
I've gone back to the original code and stripped things out.
I think part of the issue is the quotation marks, which don't seem to like fiddling
one bit
at all.
The other issue is referring to columns. If I try to alter ("SELECT * " nothing
works, so
I've ended up leaving that.
When I use "Body LIKE %"
I get the results that come up after you type something into
http://www.odihpn.org/navigation/left3.asp
I would be really happy if I could just find out what I should replace that % with
(possibly
%$&*%($*"*"!!! :)
I'm sorry to be such a pest, but if anyone can give it a go one more time (possibly
considering the quotes, I would be very grateful). Code I am using is below
Thanks
Sio
Response.Write(ResultsOfSearch & QuickSearch)
QuickSearch = Replace(QuickSearch,"'","''")
Set objRS = objConn.Execute("SELECT * " & _
"FROM tbReports WHERE Language = '" &_
"Body LIKE %" & _
Request.Cookies("Language")&"' AND STATUS = 'Live'" & _
"ORDER BY ReportDate DESC, Priority DESC")
End If
____ � The WDVL Discussion List from WDVL.COM � ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED]
Send Your Posts To: [EMAIL PROTECTED]
To change subscription settings to the wdvltalk digest version:
http://wdvl.internet.com/WDVL/Forum/#sub
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
