Asp and SQL problem

[Glutus]

I am trying to use a WHERE statement to remove all items with a number lower than something, for example:

<%
NoItems=3

set dba = server.createobject(&quot;ADODB.Connection&quot
dba.open &quot;DRIVER={Microsoft Access Driver *.mdb)};DBQ=C:\Database.mdb&quot;

set db=dba.Execute(&quot;SELECT * FROM Database WHERE ItemCount<&quot; & NoItems&quot
%>

When I run it, I get the message:
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'Analysis Class<3'

What the heck is the problem? I'm sure it's a silly little mistake, but it's driving me nuts. Please, help me!

 

[SeAL]

Hi Glutus,

It seems that you get 3 double quotes in your sample.

set db=dba.Execute(&quot;SELECT * FROM Database WHERE ItemCount<&quot; & NoItems&quot;)

Hope this helps...

 

[Glutus]

Sorry it should read:

set db=dba.Execute(&quot;SELECT * FROM Database WHERE ItemCount<&quot; & NoItems)

 

[gsc1ugs]

Has the column set as number or string?

 

[Glutus]

The NoItems items is numerical and the Items column as well.

 

[gsc1ugs]

I used this and didn't have a problem.

objConn.Execute(&quot;SELECT * FROM webdata WHERE id <&quot; &NoItems)

 

[Glutus]

I found the error and it was silly. I was pointing to an old database, so the SQL couldn't find the column. Thank you for your input and time. I'll try to help you sometime.

 

[gsc1ugs]

No problem, it happens to us all

&quot;Can't see the wood for tree's&quot;