-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 I don't see any obvious problems w/ this. What line is referenced? Is this all your code?
If you don't see line numbers, turn off friendly HTTP errors: Tools -> Internet Options -> Advanced (tab) -> scroll to "Show Friendly HTTP errors" and uncheck -> OK -> hit refresh. Ben Timby Webexcellence PH: 317.423.3548 x23 TF: 800.808.6332 x23 FX: 317.423.8735 [EMAIL PROTECTED] www.webexc.com - -----Original Message----- From: Hohimer, Christopher J [mailto:[EMAIL PROTECTED]] Sent: Monday, August 12, 2002 8:25 AM To: ActiveServerPages Subject: RE: Sending email from asp Can someone help me with an SQL error? I get the following error: Microsoft VBScript compilation error '800a0400' Expected statement When using this code: set UpdateConn = Server.CreateObject("ADODB.Connection") MdbFilePath = Server.MapPath("NWIS.mdb") UpdateConn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & MdbFilePath & ";" sqlstr = "update NWISUpdate set RequestStatus = 'Complete', Comments = '" & request.form("Comments") & "' where ID='" & request.form("id") & "'" UpdateConn.Execute(sqlstr) UpdateConn.Close set UpdateConn = nothing any help is appreciated. Thanks! - --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% -----BEGIN PGP SIGNATURE----- Version: PGP 7.0.4 iQA/AwUBPVivNPnby1cCm2Q8EQLo7QCgpOfGW6lvcMfku+in9UQxQl6N18sAn01Q q3g+sTn9NU8n58KuKnBNRkAT =XyIS -----END PGP SIGNATURE----- --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
