asp problrm with select
Posted by: c murray
Date: December 02, 2014 05:33AM

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.

Can anyone help please?

Options: ReplyQuote

Written By
asp problrm with select
December 02, 2014 05:33AM
December 04, 2014 01:22AM

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.