Simple Query that Should Work - Doesn't 1

[vpekulas]

Why doesn't this query works ?

UPDATE tbl_settings SET fldPATH = 'E:\psa\vhosts\', fldURL='1', fldEMAIL='service@mc.com', fldSMTP='3', fldSHOW_NAMES=1 WHERE ID = 1


The error is:

[MySQL][ODBC 3.51 Driver][mysqld-4.0.16-nt]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 '1', fldEMAIL='service@multicalendars.com', fldSMTP='3', fldSHOW

I don't see anything wrong with this query

"Taxes are the fees we pay for civilized society" G.W.

 

[apatterno]

SET fldPATH = 'E:\psa\vhosts\'

The backslash after vhosts escapes the quote. Thus, the entire line is included in the quotation. It Should be 'E:\\psa\\vhosts\\'


_{I REALLY hope that helps.}
Will

 

[vpekulas]

Thanks, that worked

"Taxes are the fees we pay for civilized society" G.W.