[thelist] payment...
Rory.Plaire at wahchang.com
Rory.Plaire at wahchang.com
Mon Dec 10 20:27:29 CST 2001
OK listers,
I did something a little off topic on a post earlier today, and since I've
been looking for an excuse to use this tippage, here it is:
<tip type="Coldfusion bugs" author="rory">
Ok, let's admit it, even ColdFusion has some bugs.
Some even are pretty irritating. Like the Duplicate() bug that stayed around
for a while (until 4.5.2) -- even though I am working on CF5 now, I still
shiver when I think of it.
Well, with CF5, Macromedia seems to have sealed up further progress, since
there will be no more versioning of CF... 5 is it, friends. (Well, until the
next major version. Today I learned about Neo.
http://www.macromedia.com/software/coldfusion/resources/neo/)
What do we do if we wonder if something is a bug in CF when that blasted
code just won't work (ala the dbvarname attribute in the cfprocparam tag
with MS SQL server 7)?
Try http://www.cfbughunt.org/ ... an independent site sponsored by TeraTech
to see, add and keep updated on bugs in CF.
</tip>
<tip type="Coldfusion bug" author="rory">
Have a query loop in a query loop?
If you try to access a field in the query resultset that is being iterated
by the outer loop, the value of that member won't appear to change to the
inner loop code.
http://www.cfbughunt.org/index.cfm?fuseaction=view_bug&BugID=979&Row=73
The workaround is to assign a local variable with the field value before the
inner loop, ala these peanut butter sandwiches:
<cfloop query="myQuery1">
<cfset lName = myQuery1.Name>
<cfset lAddr = myQuery1.Addr>
<cfloop query="myQuery2">
<cfoutput>
Name: #lName#
Addr: #lAddr#
Stuff: #myQuery2.Stuff#
Aught: #myQuery2.Aught#
....
instead of:
<cfloop query="myQuery1">
<cfloop query="myQuery2">
<cfoutput>
Name: #myQuery1.Name#
Addr: #myQuery1.Addr#
Stuff: #myQuery2.Stuff#
Aught: #myQuery2.Aught#
....
</tip>
<rory disposition="feelin better" alt="8)"/>
More information about the thelist
mailing list