Noni,



Just before you do this



objCmd.Execute



do this instead:



Response.Write(strSQL)

Response.End



and you should see your SQL string printed to the screen. Please post that

output to the list.



Cheers

Ken



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

From: "Noni Jenkins" <noni_j@h...>

To: "Access ASP" <access_asp@p...>

Sent: Wednesday, October 31, 2001 7:07 PM

Subject: [access_asp] Re: Newbie to ASP





:

:

:

:

: I tried your suggestion and I got the following error message:

: Error Type:

: Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)

: [Microsoft][ODBC Microsoft Access Driver] Invalid SQL statement; expected

'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'.

: /noniweb/example1.asp, line 109

:  Below is the revised code.  I hope I put everything is the right places.



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~