Error message with sql statement

[Jack]

Hi,
I got a asp page where I am getting the following error. (Line 126 is
actually the
RS.open statement.)

ERROR MESSAGE

Technical Information (for support personnel)

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in
query expression 'GrantID ='.
/gwis/Recalc.asp, line 126

THE FOLLOWING IS THE PART OF CODE THAT IS PRODUCING ERROR:
'New Connection
myDSN="DRIVER={ Microsoft Access Driver (*.mdb)}; "
myDSN=myDSN & "DBQ=C:\gwi s Data\fpdb\GWIS. mdb"
set CN=server.creat eobject("ADODB. Connection")
set RS=server.creat eobject("ADODB. Recordset")
CN.Open "myDSN"

RS.ActiveConnec tion=CN

SQL = "SELECT COUNT(*) AS reccount FROM CurrentQuarterT bl WHERE GrantID =
" & GrantID & ";"
RS.Open SQL

Any help is appreciated in advance. Thanks.

[Bob Barrows [MVP]]

Re: Error message with sql statement

Jack wrote:[color=blue]
> Hi,
> I got a asp page where I am getting the following error. (Line 126 is
> actually the
> RS.open statement.)
>
> ERROR MESSAGE
>
> Technical Information (for support personnel)
>
> Error Type:
> Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
> [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing
> operator) in query expression 'GrantID ='.
> /gwis/Recalc.asp, line 126
>
> THE FOLLOWING IS THE PART OF CODE THAT IS PRODUCING ERROR:
> 'New Connection
> myDSN="DRIVER={ Microsoft Access Driver (*.mdb)}; "[/color]

http://www.aspfaq.com/show.asp?id=2126

[color=blue]
> myDSN=myDSN & "DBQ=C:\gwi s Data\fpdb\GWIS. mdb"
> set CN=server.creat eobject("ADODB. Connection")
> set RS=server.creat eobject("ADODB. Recordset")
> CN.Open "myDSN"
>
> RS.ActiveConnec tion=CN
>
> SQL = "SELECT COUNT(*) AS reccount FROM CurrentQuarterT bl WHERE
> GrantID = " & GrantID & ";"[/color]

You cannot debug a sql statement without knowing what it is. Knowing what
the vbscript code that is supposed to result in a valid sql statement looks
like is less than half the battle. Add this line:

Response.Write SQL

Look at the statement that appears in the browser window. Does the error
stand out? If not, open your database in Access, and use the query builder
to test the statement from the browser window. Still can't see the error?
Post the sql statement here.

Take a look at these posts:

http://www.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&selm=e6lLVvOcDHA.1204%40TK2MSFTNGP12.phx.gbl

http://www.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=O31NZa%230DHA.3436%40tk2msftngp13.phx.gbl&rnum=11&prev=/groups%3Fq%3Ddelimiter%2Bauthor:Bob%2Bauthor:Barrows%26hl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26start%3D10%26sa%3DN

Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.