Re: 1064 Error
Posted by:
james bush
Date: April 13, 2005 04:41AM
hi chris,
i have a similar error.
do you manage to fix your problem?
i'm really stuck with mine.
i can't see how it is wrong...
this is my error:
Invalid SQL: UPDATE images SET artist='15', title='Ephemera No.612', desc='2002', medium='Mixed media', size='840 x 840mm', file='bzb3b.jpg', itype='artist' WHERE id='167';
1064 (You have an error in your SQL syntax near 'desc='2002', medium='Mixed media', size='840 x 840mm', file='bzb3b.jpg', itype='' at line 1)
this is the actual sql:
UPDATE images SET artist='15', title='Ephemera No.612', desc='2002', medium='Mixed media', size='840 x 840mm', file='bzb3b.jpg', itype='artist' WHERE id='167';
any ideas???
thanks,
james