Re: SQL Azure and Coldfusion 9

2010-11-30 Thread Sean Henderson
This is actually incredibly easy to deal with this scenario, you just have to check for the existence of the query variable first. You would normally check the recordcount 0 anyway so you don't output nothing, so it really isn't any more work. That would be true except when recordcount isn't

RE: SQL Azure and Coldfusion 9

2010-11-30 Thread DURETTE, STEVEN J (ATTASIAIT)
So use isDefined(Variables.queryname) first. -Original Message- From: Sean Henderson [mailto:shender...@followup.net] Sent: Tuesday, November 30, 2010 4:14 PM To: cf-talk Subject: Re: SQL Azure and Coldfusion 9 This is actually incredibly easy to deal with this scenario, you just have

Re: SQL Azure and Coldfusion 9

2010-11-30 Thread Sean Henderson
Rather that CF9 and CFQUERY handle it better To my mind, if CFQUERY does not error out, then the queryname, recordcount and column list in all cases should be set, regardless of driver or target database. For those of us with sprawling apps to maintain (1,000s of .cfm files) and where a

RE: SQL Azure and Coldfusion 9

2010-11-26 Thread Russ Michaels
Sean, This is actually incredibly easy to deal with this scenario, you just have to check for the existence of the query variable first. You would normally check the recordcount 0 anyway so you don't output nothing, so it really isn't any more work. Russ -Original Message- From: Sean