Can you post the debug output, that usually has all the info we need. Make sure #getThreadData.views# is making it to the query. Try putting single quotes around it, mysql will deal with them okay, it's a handy trick.
On Apr 8, 2008, at 7:32 PM, Walter Conti 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:3555 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
