Re: inserting works fine but I cant update.

[Blake Schroeder]

The type is a varchar.

-Blake

Ronan Lucio wrote:

>Blake,
>
>  
>
>>Query
>>UPDATE table SET 1 = '1' WHERE id = '1'
>>
>>|#1064 - 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  =  '1' WHERE id =  '1'' at line 1
>>    
>>
>
>Is the column 1 string type?
>If it´s numec type. You should use SET 1=1 instead of SET 1='1'
>
>Ronan
>
>
>
>  
>