MySQL Forums
Forum List  »  MySQL for Visual Studio

ASP: Select statement problem
Posted by: c murray
Date: December 03, 2014 12:38AM

when I use the following code:
rsOpenStr = "select * from inventory where instr(description," & kwStr &")>0"
rs.Open (rsOpenStr)

if I enter a number in the text box -- 1972 for example, the select statement executes.
If I enter a string -- birds for example, I get the following error:
Unknown column 'birds' in 'where clause'.
If I replace kwStr in the instr function with 'birds' the select statement executes as desired.

Can anyone help please?

Options: ReplyQuote

Written By
ASP: Select statement problem
December 03, 2014 12:38AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.