Community Member Profile
- Profile: /members/3148-Webexpertise.htm
- Comments: 5
- Points: 54
Recent Blog Comments By Webexpertise
-
LOCAL Variables Scope Conflicts With ColdFusion Query of Queries
Posted on Apr 2, 2009 at 2:10 PM
True, but you got to limit it somewhere, what if its 700 billion rows in that report. You could cover the world on paper a few times, we will freeze to death from lack of heat from the sun catastrophic loss of species while making the world a lonelier and less interesting place. I would think twi... read more »
-
LOCAL Variables Scope Conflicts With ColdFusion Query of Queries
Posted on Apr 1, 2009 at 1:03 PM
top 50 was just an example, usually I limit the amount of rows returned by my sql, with a variable that works similar to "maxorws" Its a scary thing not to do so, I hate to see cfml templates spinning the cursor, going back to the QoQ vs. SQL I ran into this post in the IRC channel. read more »
-
LOCAL Variables Scope Conflicts With ColdFusion Query of Queries
Posted on Mar 27, 2009 at 9:05 PM
Ben, Art vs. science, interesting comparison it reminds me of MAC vs PC. I know you are a master at coldfusion, I do really appreciate all the articles you have ever provided, in many cases it has saved my week from falling short and I love your site for that. But let me quote you wi... read more »
-
LOCAL Variables Scope Conflicts With ColdFusion Query of Queries
Posted on Mar 24, 2009 at 5:55 PM
Point taken, but in that case I would do one single SQL statment: select top 50 student, score from studentscores order by id desc that will give me a list of 50 students ordered from newest to lowest. so then I can show them like this: <cfoutput> &l... read more »
-
LOCAL Variables Scope Conflicts With ColdFusion Query of Queries
Posted on Mar 24, 2009 at 4:48 PM
Since query of queries is so limited with functionallity and it takes a performance hit on your page, I opted to exclude it from my coding. Instead sharpenning up my SQL has really taken away the need for QoQ. For example, get the rows and columns you'd like them on the first call to the SQL... read more »
