You need to join your wheres with an AND so:
update forums set thrcount = thrcount-1 where id = '#getThreadData.forumidfk#' and viewcount = viewcount - #getThreadData.views# that shoudl work. Rob On Tue, Apr 8, 2008 at 7:32 PM, Walter Conti <[EMAIL PROTECTED]> wrote: > CF* and mySQL > This query works ok: > > update forums > set thrcount = thrcount-1, > where id = '#getThreadData.forumidfk#' > > If I add this other "set" : > , viewcount = viewcount - #getThreadData.views# > > I get that there is an error close to "where id = "...... > > - column viewcount exists > - #getThreadData.views# also exists and is numeric > > No more self-esteem. please help. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3554 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
