Hi Keith
The wddx packet will be defined on a single query (not row in a query). If
you have a query with three rows and really want to break it into three wddx
packets then you'll need to get three different queries.
Queries don't break apart into individual rows very easily... if you cfdump
the entire query you'll see that a query is a struct containing arrays,
where each array is a single column from the query. To get a single row you
need one entry from each of the column arrays.
The easiest thing to do would be to put the entire (three row) query into a
single wddx packet and change you program to deal with that. Next easiest
would be to find a way to make query objects that have only the one row you
want in them... You could requery the db, or maybe use query-of-query, or
construct a query "by hand" in code using the functions built for that
(QueryAdd something or other, I don't recall off hand).
Mark
-----Original Message-----
From: E. Keith Dodd [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 03, 2003 10:34 AM
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
Get the mailserver that powers this list at http://www.coolfusion.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
