Walter Conti said the following on 4/8/2008 6:32 PM: > update forums > set thrcount = thrcount-1, > where id = '#getThreadData.forumidfk#'
Try removing the comma after the 1 in the second line, i.e. set thrcount = thrcount-1 > If I add this other "set" : > , viewcount = viewcount - #getThreadData.views# > > I get that there is an error close to "where id = "...... Is forumidfk a numeric value? This looks like a foreign key for the forumid field in another table. If it's not a character field (i.e., it's numeric), then you'll need to drop the single quote marks around #getThreadData.forumidfk# on the third line of your query. -- Best regards, Chris Montgomery ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:3556 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
