Classic ASP Discussion - Updating Database error

Print Page | Close Window

Updating Database error

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=1322
Printed Date: 28 March 2026 at 2:24am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Updating Database error

Posted By: Scotty32
Subject: Updating Database error
Date Posted: 25 March 2003 at 6:53am

i thought this would go in ASP since its asp am usin to update it

well i get this error

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'.
/client-update.asp, line 12

but its the same as other pages, and they work

heres the code:

L10 - <%
L11 - Set rsClient = Server.CreateObject("ADODB.Recordset")
L12 rsClient.open "contact WHERE ContactID = '" & id & "'", conn, 3, 3
L13 - rsClient("firstname") = Request.Form("firstname")

wot have i done wrong? please help

(ive tryed wit and wit out the ' in it

Replies:

Posted By: michael
Date Posted: 25 March 2003 at 9:06am

What are you trying to do. That is not a valid sql statement just part of it. where is the Select xxxx,xxxx,xxxx from xxxxx, part of the sql??

Posted By: Scotty32
Date Posted: 25 March 2003 at 9:30am

ok , i deleted wot i jsut said cose i got it working (thanks to michael )

so everyone else can ignore this post now (cept for tha question below of course!)

(PS anyone know where borg got the WYSIWYG buttons from? cose ive just seen em sumwhere else )