On 12/5/05, Matthew Peter <[EMAIL PROTECTED]> wrote: > it's in a loop so there's an extra comma at the end so i was thinking i > could put in a throw away value to keep the update from breaking if there's > an additional comma > > Jaime Casanova <[EMAIL PROTECTED]> wrote: > On 12/5/05, Matthew Peter wrote: > > I need a throw away value for an insert statement... example... > > > > update table > > set value = 1, value = 2, throw_away_value -- so i don't break the query > > where id = 1; > > > > Thanks > > >
i guess you are constructing the query in a string and EXECUTEd it... if that is the case review your logic... -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;) ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster