(0x80040E14) Syntax error in UPDATE statement. 
Author Message
 (0x80040E14) Syntax error in UPDATE statement.

Here's my code:

' If the Needs field is set to true the user has modified their
information and
        ' is requesting to update it.  Take the form variables and create a
SQL UPDATE statement
        ' from that info.
        If Request.Form("Needs") = "true" Then
                strSQL =        " UPDATE Needs SET " & _
                                " FA_Assess = " & request.form("TxtAssess") & " , " & _
                                " WHERE TblTeachers.TchSSN =" & Session(USER_ID)

                ' Create a command object to execute the query          
                set cmd = Server.CreateObject("ADODB.Command")
                with cmd
                        ' set the connection
                        .ActiveConnection = conn
                        ' give the object the update statement
                        .CommandText = strSQL
                        ' execute the statement against the database
                end with
                ' destroy the command object
                set cmd = nothing
        End IF

**Here's the form:

<input type="text" name="TxtAssess"
value="<%=rs.Fields("FA_Assess").Value%>" size="1">

Please, I'm really new at this and I'm learning by trial and error but
lately it's been mostly error.  What am i doing wrong?  The field i'm
trying to update is a numeric field.



Sun, 19 Sep 2004 06:01:03 GMT
 [ 1 post ] 

 Relevant Pages 

1. (0x80040E14) Syntax error in UPDATE statement.

2. Error 0x80040e14??? syntax problem

3. HE: Syntax Error in UPDATE statement

4. Syntax Error in Update Statement

5. Syntax error in UPDATE statement while using a Memo field

6. Syntax error in UPDATE statement

7. Syntax error in UPDATE statement

8. -2147217900 Error: Syntax error in INSERT INTO statement

9. Update statement syntax?

10. Update statement syntax -- Please Help!!

11. SQL Update Statement Syntax Help

12. UPDATE statement syntax

Powered by phpBB® Forum Software