I'm getting an error from the following SQL Syntax. Can anyone guide me on
what I am missing. It's probably obvious but I can't see it I have even
resorted to rereading the section on the update command.
The CustID Field is the unique Identifier and primary key of the table. The
Updated field is a time stamp field.
I've even removed the UPDATED='2005-09-18 10:30:56' with no success.
Sql Syntax:
UPDATE Clients_Master SET Label='', Title='Mrs', FName='Jane', MName='',
SName='Doe', Building='', Unit='', STNumber='', STName='', STType='',
STSuburb='', STState='', STPostcode='', Postal1='', Postal2='', Postal3='',
PSuburb='', PState='', PPostalcode='', PBarcode='', HPhone='', MPhone='',
HEmail='', MF='', Maiden='', ClientNo='999', Pcontact='',
UPDATED='2005-09-20 04:46:37') WHERE CustID='MNO1234567890' AND
UPDATED='2005-09-18 10:30:56'
Error Message:
You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near ') WHERE
CustID='MNO1234567890' AND UPDATED='2005-09-18 10:30:56'' at line 1
Tec Info:
Server -> MySQL 4.1.11-nt-max via TCP/IP
Client -> MySQL Client Version 5.0.4
Regards,
Justin Elward
Blue Wave Software Pty Limited
[EMAIL PROTECTED]
Ph. +61 2 4320 6090
Fx. +61 2 4320 6092
----------------------------------------------------------------------------
-------------------
DISCLAIMER:
This message is proprietary to Blue Wave Software Pty Limited (BWS) and is
intended solely for the use of the individual or individuals to whom it is
addressed. It may contain privileged or confidential information and should
not be circulated with out informing BWS prior or used for any purpose other
than for what it is intended. If you have received this message in error,
please notify the originator immediately. If you are not the intended
recipient, you are notified that you are strictly prohibited from using,
copying, altering, or disclosing the contents of this message. BWS accepts
no responsibility (except where required under Australian law) for loss or
damage arising from the use or misuse of the information transmitted by this
email including damage from virus."
----------------------------------------------------------------------------
-------------------
