in reply to DBI SQL Syntax Problem

First, jerrygarciuh, shame on you for not originally posting the same code that you're having problems with. Posting different code (minus the commas) wastes peoples' time chasing down the wrong alleys.

I was in the process of writing an RTFM reply citing the MySQL doc for UPDATE, but found that it begins with

UPDATE [LOW_PRIORITY] [IGNORE] tbl_name SET col_name1=expr1, [col_name2=expr2, ...] [WHERE where_definition] [LIMIT #]
which is wrong about comma placement (in a subtle way). It should read
UPDATE [LOW_PRIORITY] [IGNORE] tbl_name SET col_name1=expr1 [, col_name2=expr2 ...] [WHERE where_definition] [LIMIT #]
I've sent a note about this to the MySQL folks.

Update: They've made the correction. Quick turnaround on their part.

Replies are listed 'Best First'.
Re: Re: DBI SQL Syntax Problem
by jerrygarciuh (Curate) on Apr 15, 2002 at 18:05 UTC
    Absolutely true dws Problem is that I did post code I was using and then had various sugestions made (some made in the CB) and abandoned/modified/screamed. I really apologize for wasting folk's time. If I'd only been able to locate an example in Cheetah or Kingfisher or Google with multiple values in UPDATE...SET staement, I'd of worked out what was wrong. Again, mea culpa maxima and...
    Thanks
    jg
    _____________________________________________________
    Think a race on a horse on a ball with a fish! TG