I have tried to isolate the query. It worked fine. I am just unable to duplicate the issue.
Maybe I should put a <cftransaction></cftransaction> around the query. I will try that. But, does anyone know of any case where CF acts wacky when it comes to interacting with the database? Also, since i think i cannot use @@ROWCOUNT in CF, i will try ThisQry.Recordcount function. Any other suggestions are welcome. Thanks All AB --- Andy Ewings <[EMAIL PROTECTED]> wrote: > yup > > Assuming your not getting an error there are one of > 2 reasons why this is > happening. > > 1. No rows are being updated - which means none are > found in your where > clause. As Alex says output the string (or at least > the variable used in > the where clause to determine the record(s)) and > then change to a select > statement with same where clause and run in query > analyser to see if any > records are returned. If none are returned then > your where clause is not > doing what you expect. > > 2. If records are returned then if you are using > transactions at all > (either in SQL or using CFTransaction) make sure > that they are being > commited > > -----Original Message----- > From: Alex Ninan [mailto:[EMAIL PROTECTED] > Sent: 19 June 2003 17:36 > To: SQL > Subject: RE: Help! > > > Comment the query in a cfquery block. Then output > the query as a string and > check for syntax and also by running the sql in the > DB. Then fix and > reapply. Just an idea... > > -----Original Message----- > From: bajaria aslam [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 19, 2003 9:28 AM > To: SQL > Subject: Help! > > > Hi All, > This was kind of urgent and critical. So, if you all > can help me, i will appreciate it. > > The issue is that there is a query in CF that is > supposed to update a column in the database. The > logic > in CF seems to be good. It has all the checks to see > if everything needed is there to update the column > in > the database. But, for some reason, sometimes, the > column for a particular record does not get updated. > > If I try to duplicate the issue with exactly the > same > information, i am not able to. The query is executed > whenever i try. The query not updating is happening > very randomly. > > Can you all advise me on how i should proceed to > check > this? (remember, i am unable to duplicate the > issue). > > > Do you know what could be the reason for this to > happen? > > Thanks All > > AB > > __________________________________ > Do you Yahoo!? > SBC Yahoo! DSL - Now only $29.95 per month! > http://sbc.yahoo.com > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6 Get the mailserver that powers this list at http://www.coolfusion.com
