Thank you Chris. Yes, a cfdump just before the query return the proper values. I have tried single/double quotes. Now I have taken the query update out of the CFC and it works ok, even if it is not elegant.
But listen to this: in spite of the error that stopped the program "the database tables were actually updated". The error mentioned the exact line, and the wordings were unmistakenly of the query in question. Even the rest of the commands in the same function were carried out appropriately. Unuasual indeed! So, from the point of view of the results I have solved the problem, but I won't give up until I know why that was happening. Thanks again everybody. >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: > >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:3559 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
