View Single Post
  #1 (permalink)  
Old February 24th, 2016, 12:42 PM
melkin melkin is offline
Authorized User
Points: 483, Level: 7
Points: 483, Level: 7 Points: 483, Level: 7 Points: 483, Level: 7
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Apr 2007
Location: Edgewood, NY, USA.
Posts: 92
Thanks: 0
Thanked 0 Times in 0 Posts
Default syntax for Like statement

Hi All.
I am having trouble getting syntax right for my MySQL like statement.
I need the like statement to check against the request.querystring.

If I manually paste in the actual querystring name it works... but if I want to have dynamic data here it doesnt...

my current syntax:
WHERE (prodis LIKE '%'#Request("prodis")'%')

doesnt work. I tried so many othes ways!

I am using asp:SqlDataSource
Reply With Quote