Hi all,
I actually found a solution to ONE of the multiple NULL NULL errors that
I have encountered over the past year.
Here is the setup. qryGetDate.theDate is populated with a date from the
database.
The object is to produce table headers for all the months up to that
date. (extra code not shown)
<cfloop from="1" to="#month(qryGetDate.theDate)#"
index="Variables.theLoop">
<th>#left(monthAsString(Variables.theLoop), 3)#</th>
</cfloop>
The NULL NULL error came up when qryGetDate.theDate ended up being NULL.
This of course wasn't supposed to happen, but the code to prevent the
variable from being NULL had a flaw.
Weird thing is I would have expected CFLOOP to throw an error that the
TO was not a number.
Fixed the code and one type of NULL NULL error went away.
Steve
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232986
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
