Thanks Mark, Ray, Pascal I hadn't realize the nature of the Query results compared to a usual structure.
Tried the Q of Q, both before serializing/sending and after. That will work. Need to investigate, however, whether the additional queries and serialization is worth it versus just doing all hidden fields. Will look at some UDF's to see if anything there can help. At least now I know what I am dealing with so can continue. Thanks! Keith ----- Original Message ----- From: "Pascal Peters" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, February 03, 2003 10:49 AM Subject: RE: WDDX for row of a query > Unfortunatly a Query is stored as a structure of arrays instead of an > array of structures. So you can't get a single record with that > notation. You can do a Query of Query or build a Record using Query > functions. You could also pass the data as a serialized structure. > > -----Original Message----- > From: E. Keith Dodd [mailto:[EMAIL PROTECTED]] > Sent: maandag 3 februari 2003 16:34 > To: CF-Talk > Subject: WDDX for row of a query > > > Want to send distinct rows of a query via hidden form containing a WDDX > packet, rather than all the data in bunch of hidden forms. > > Have query qFolders that works fine, giving say 3 rows of data. If > cfdump query, all is fine. Am then looping through query, hoping to send > row 1's packet via form 1, row 2's via form 2, etc. Tried to do a cfdump > of each row, to see if I'm getting the right stuff before do WDDX. > > <cfloop query="qFolders"> > <!--- one method ---> > <cfdump var="#qFolders.CurrentRow#"> <!--- this just gives 1,2, etc. > ---> > <!--- another method ---> > <cfdump var="#qFolders[CurrentRow]#> <!--- produces an error ---> > </cfloop> Tried it with a counter (x=0, x = x+1, etc.), same results > > Is there a syntax to get what I want or is this something that can't be > done? Just want to be able to pack each row as individual packets. > > Thanks > Keith > E. Keith Dodd > Wings of Eagles Services > www.wingserv.com > > > - > [This E-mail scanned for viruses by declude AntiVirus Software] > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
