After looking at my code, I can actually SKIP creating the array and go
ahead and directly create the query object:
AT the top of the page:
<cfset hasMEDIA = QueryNew("thisHEAD, sec_id, thisSTORY, idLIST",
"VarChar, Integer, VarChar, VarChar")>
<cfoutput query=:someQ">
<cfset temp = QuerySetCell(hasMEDIA, "tHEAD", "#tHEAD#", #COUNT#)>
<cfset temp = QuerySetCell(hasMEDIA, "secid", "#secid#", #COUNT#)>
<cfset temp = QuerySetCell(hasMEDIA, "tSTORY", "#tSTORY#", #COUNT#)>
<cfset temp = QuerySetCell(hasMEDIA, "idLIST", "#theseID#", #COUNT#)>
</cfoutput>
If I do a simple CFOUPUT of the vars I'm trying to put into cells, I'm
getting exactly what I want to see, correct row number and everything.
Running the above though, I get an error message:
The row number 1 is out of bounds.
Suggestions?
>> <cfset thisARRAY[#thisCOUNT#][1] = "SECTION">
>> <cfset thisARRAY[#thisCOUNT#][2] = "id">
>> <cfset thisARRAY[#thisCOUNT#][3] = "title">
>> <cfset thisARRAY[#thisCOUNT#][4] = "stuff">
>> <cfset thisARRAY[#thisCOUNT#][5] = "other stuff">
>> <cfset thisARRAY[#thisCOUNT#][5] = "more stuff">
>> <cfset thisARRAY[#thisCOUNT#][5] = "even more stuff">
__________ Information from ESET NOD32 Antivirus, version of virus signature
database 5115 (20100514) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333698
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
