DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 1 of 1

Thread: Syntax error in UPDATE statement.

  1. #1
    Join Date
    Feb 2012

    Syntax error in UPDATE statement.

    First of all hello to you all, I am very new to this, I have only been learning and SQL for 9 days now so go easy on me :P

    The situation is this: I have a very basic website that is linked to a database on my web space, I can pull information from the database and display it no problem, I can also add and delete records from this database using SQL commands and statments, but what I can't seem to do is update records using SQL I have been mostly following the tutorials on w3schools but this time I've hit a brick wall.

    I will attach a txt document to show the offending code, the error I'm getting is: Syntax error in UPDATE statement.

    While I'm normally quite a logical person I do tend to overlook simple things and due to my lack of experience and knowledge using this language I am obviously making a mistake. Any tips or advice is greatly appreciated.

    If there is any additional code or information you need please let me know and I shall provide it.

    Additional information: I have a database called "database.mdb" inside it is a table called "Cusinfo" within this table I have 5 fields, Firstname, Surname, Address, Paid, and DOB.

    Thank you in advance.
    Attached Files Attached Files

Similar Threads

  1. errorSyntax error in UPDATE statement
    By shinnyuuya in forum .NET
    Replies: 5
    Last Post: 06-04-2009, 07:47 AM
  2. Replies: 0
    Last Post: 08-18-2002, 10:09 PM
  3. SQL CASE statement for UPDATE
    By David Satz in forum Database
    Replies: 1
    Last Post: 06-28-2002, 12:35 PM
  4. update a table with a join statement
    By Devo in forum Database
    Replies: 1
    Last Post: 04-10-2001, 06:02 PM
  5. complicated UPDATE statement help
    By Garrett in forum Database
    Replies: 1
    Last Post: 02-19-2001, 03:04 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center