Posted by Bob Stearns on 10/08/66 11:29

charliefortune wrote:
> That's it, thank you. My price field is a float, and tracking_url is
> varchar. Is this why one works without quotes and the other needs them
> ?
>
> Also, is it more efficient to do several updates in a single query, I
> would assume so ?
>
Any of varchar, char, date, time, timestamp et al. need apostrophes for
their 'external' representation. The numeric types decimal, integer,
float et al. not only don't need them but can't have them. Other radix
values like hexadecimal, octal, and binary vary by database, you'll have
to search your documentation.

[Back to original message]