WTH is the SQL Error in this query!?!?

[Superwormy]

INSERT INTO messages SET ( toaddress = 'test@durdenwebapplications.com' , fromaddress = 'Keith Palmer &lt[semicolon]keithp@logosoftwear.com&gt[semicolon]' , ccaddress = '' , bccaddress = '' , replyaddress = 'Keith Palmer &lt[semicolon]keithp@logosoftwear.com&gt[semicolon]' , senderaddress = 'Keith Palmer &lt[semicolon]keithp@logosoftwear.com&gt[semicolon]' , subject = 'subject' , message = 'message\r\n\r\nasdgljkasdg\r\n\r\n\r\nasdg' , md5 = '6e727e1461d8ea112ebf1b570618b655' , attatchment = 0 , datetime = NOW() , ID = 0 , folder_ID = 1 , status = 9 , user_ID = 2 )


You have an error in your SQL syntax near '( toaddress = 'test@durdenwebapplications.com' , fromaddress = 'Keith Palmer &lt


Whats the fricking error and how can I fix it!?!

 

[Czar]

dont think you can use [ and ]

you will have to replace it with something else.. at least try that

 

[rayster]

What SQL are you using? The error seems like an Oracle error, but you don't say...

Is the statement as shown or a single line, or are you doing some from of concatenation?

Is "[semicolon]" the actual part of the string or are you actually using semicolons in the query?

If it's an Oracle error, the end of the near string is usually where the problem is. Its failing at either the open bracket of "[semicolon]" or the actual semicolon. Replace it with another character and see if the error moves to the next one, then you'll know that that's you problem.

 

[Superwormy]

srry MySQL, and I fixed it. You can't put the field = value bit in parenthesis ( ) , needs to be just SET field = value instead of SET ( field = value )