Forum Moderators: open

Message Too Old, No Replies

MS Access and ASP problems

Simple problem, I am almost certain its syntax

         

SethCall

5:33 pm on Feb 19, 2003 (gmt 0)

10+ Year Member



Ok plz forgive this rather stupid post:

I am using asp to access MS Access.
I am doing a simple enough SELECT on it, but i get that hated "too few parameters. expected 1".
here ill post what I know is the problem:


WHERE ((([System List].[System Type]) = "Cardiovascular"))

now that is exactly what is getting passed to the database by ASP. (other than the select before it)

Strangely, if I change the quotes ("), to single quotes ('), then I get "too few parametesr. expected 2"

what is a guy to do? :(

An

SethCall

5:42 pm on Feb 19, 2003 (gmt 0)

10+ Year Member



ARG!

SINGLE QUOTES WORK Now! :)

I had a mistake in my select statement, but I did also have the double quotes still going. Without the double quotes, and instead singles, I am good now.

sory to clog this forum :)