I have, what I thought was, a simple SELECT statement that works just fine inside of MS Access; however, it is not working when I paste it into my ASP script.
Here is the statement inside Access:
select * from cp_parts where cp_image is not null and cp_image <>""""
Here it is inside my ASP script/connection area:
strsql="select * from cp_parts where cp_image is not null and cp_image <>"""" "
objRs.Open strsql, objConn, 0, 1, 1
I simply pasted it inside the quotes and it give me a message that it is "... expecting 1 or more parameters...".
What am I doing wrong?