Coldfusion blog - by phil porter
   

fearlessFusion.com is my Blog and Online portfolio; I am currently the Director of Visualweb Ltd. Read More


Query of queries - fix it!

I know of a few people that like to scope all their variables and I know a few that don't. Personally I scope all of my variables depending on the type they are. For instance:

<cfset qry = structnew()/> <!--- holds all of my queries --->
<cfset local = structnew()/> <!--- holds any local variables --->

The reason I do this is so that I can dump out my qry struct (that holds all my queries) to see all the reults, and I only need to code 1 line to do this:

<cfdump var="#qry#">

Its purely a personal choice, so please don't start an thread for and against.

The problem with doing this is that coldfusion's query of queries just won't allow me to query the queries( are you following me here) stored in my qry structure.

Its obviously a bug, which I hope Adobe will sort out very soon! Hopefully a hotfix!



Related Blog Entries

Comments (Comment Moderation is enabled. Your comment will not appear until approved.)

Sponsored Links

 

 




Calendar

« November 2008 »
M T W T F S S
          1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30


Recent Comments

Wordle online graphic toy

Coldfusion Developer said: That is wicked... Good idea about the business card.. ;-) [More]

BlogCFC ping list and timeouts

Jonny Shaw said: Cheers Phil. this s a good post that list of pings is very helpful! [More]

Multiple SQL inserts: Oracle, Mysql, Mssql

JAYESH TALSANIYA said: in mssql u cannot use parentheses in select statement. use as below: INSERT INTO [TABLE] (column1,... [More]

Multiple SQL inserts: Oracle, Mysql, Mssql

JD said: I found with MSSQL, I couldn't use parentheses in my select statements for insert. So, from your ex... [More]

BlogCFC ping list and timeouts

Will Wilson said: Nice :) that will come in handy, thanks! [More]