Need a little assistance with a struct/array problem please!
---
Data in question is coming from ONE row in the database.
There are six fpcomm cells: fpcomm1,fpcomm2, ... and so on
There are also six fpord cells: fpord1, fpord2, ... and so on
So, I need to display the contents of the fpcomm cells, ordered by the
integer in the fpord cells.
My query is getNEWS.
The below works great, and sorts the results as I need.
cfset allNEWS = StructNew()
cfloop from=1 to=6 index=i
cfset oneSTORY = StructNew()
cfset oneSTORY.cellID = #i#
cfset oneSTORY.ord = #getNEWS[fpord#i#][1]#
cfset oneSTORY.cell = #getNEWS[fpcomm#i#][1]#
cfset allNEWS[oneSTORY.cell] = oneSTORY
/cfloop
cfset sortedKeys = StructSort(allNEWS, numeric, asc, ord)
Here's the problem, maybe fpcomm5 and fpcomm6 are EMPTY (or NULL) on a
particular day. REGARDLESS, I still need all six positions in
sortedKeys returned.
Let's say for the moment that fpcomm5 and fpcomm6 cells are empty. If I
do a dump of sortedKeys, I'll get:
array
1 Item One
2 Item Two
3 Something Else
4 Even Something Else
5 [empty string]
It INCLUDES the first emtpy row (fpcomm5), but NOT fpcomm6, which looks
exactly like fpcomm5 in the database.
If fpcomm4, 5, and 6 are empty, it will include fpcomm4, but not 5 and 6.
Weird - it only include the FIRST empty element
I need the array to always include all six elements. [empty string] is
exactly what I need - but I need ALL of them.
Suggestions?
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351660
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm