Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 304
  • Last Modified:

Error outputting form data deserialized with wddx2cfml

I have the following code:
<cfsilent>
	<cfquery datasource="#application.configBean.getDatasource()#" name="qFormDataRaw">
		SELECT data FROM tformresponsepackets
		WHERE responseid = <cfqueryparam value="#URL.responseID#" cfsqltype="cf_sql_varchar">
	</cfquery>
	<cfwddx 
		action = "wddx2cfml" 
		input = "#qFormDataRaw.data#" 
		output = "qFormData" 
		validate = "yes" >
</cfsilent>

Open in new window


When I try to output the results with <cfoutput query="qFormData"> I get the error that "The value of the attribute query, which is currently qFormData, is invalid." If I do a cfdump of qFormData it looks like I'd expect, with the "column names" on the left and the corresponding data on the right.

According to the LiveDocs for cfwddx (at least for 8, which is what we're running) it appears that you can use the wddx2cfml results as a query. What am I doing wrong here? Thanks!
0
SiobhanElara
Asked:
SiobhanElara
  • 5
  • 4
1 Solution
 
_agx_Commented:
- What does qFormData.Data contain: a wddx string ?  
- Does qFormData contain multiple rows?
0
 
SiobhanElaraAuthor Commented:
- What does qFormData.Data contain: a wddx string ?
Yes. It looks like this:
<wddxPacket version='1.0'>
   <header/>
      <data>
         <struct>
            <var name='HOMEPHONE'><string>555-555-5555</string></var>
            [more variables]
         </struct>
      </data>
</wddxPacket>

Open in new window

Does qFormData contain multiple rows?
Yes. It looks something like the following:
HOMEPHONE     |     555-555-5555
ADDRESS            |     123 Main Street
CITY                    |     Anytown
etc.
0
 
_agx_Commented:
>  Does qFormData contain multiple rows?c

I meant your query.  ie

Row | Data
1     | <wddxPacket version='1.0'> ....
2     | <wddxPacket version='1.0'> ....
3     | <wddxPacket version='1.0'> ....

If each row contains a *separate* WDDXPacket, I don't think you can do it in a single line. You must loop through the query and call cfwddx on the packet in each row. Something like

ie
<cfloop query="qFormDataRaw">
        <cfwddx
            action = "wddx2cfml"
            input = "#qFormDataRaw.data[currentRow]#"
            output = "qFormData"
            validate = "yes" >
</cfloop>
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
SiobhanElaraAuthor Commented:
Oh, I'm sorry... I misunderstood your question. qFormDataRaw.Data (the input for the cfwddx tag) contains the packet. There is no qFormData.data variable; each row is a var name/string pair from the packet (and "data" is not one of the variables. Or am I misunderstanding the question still?)
0
 
SiobhanElaraAuthor Commented:
As a bit of additional information, I can dump a variable like qFormData.HOMEPHONE and it outputs the proper string.
0
 
_agx_Commented:
(Edit)  Sorry, I see it was a typo of mine that confused things! But I misread the problem anyway.  Let me see if I can track down a CF8 machine to test something.
0
 
_agx_Commented:
Maybe I'm still misunderstanding.  Here's a standalone example. I tried to simulate what you described. But no errors under CF8.

Can you look it over and see if we're on the same page about what your input looks like?

<!--- create a sample query --->
<cfset qSample = queryNew("")>
<cfset queryAddColumn(qSample, "Name", listToArray("Bob,Joe"))>
<cfset queryAddColumn(qSample, "HomePhone", listToArray("555-555-5555,111-111-1111"))>

<!--- convert it into wddx --->
<cfwddx action="cfml2wddx" input="#qSample#" output="qWDDXString">

<cfoutput>
Converted query: <pre>#HTMLEditFormat(qWDDXString)#</pre>
</cfoutput>

<!--- now simulate your "input" query --->
<cfset qFormDataRaw = queryNew("Data")>
<cfset queryAddRow(qFormDataRaw, 1)>
<cfset qFormDataRaw.Data[1] = qWDDXString>

<!--- try and convert it back into a CFML query object --->
<cfwddx action="wddx2cfml" input="#qFormDataRaw.Data#" output="qOutputQuery">

<!--- dump it --->
<cfdump var="#qOutputQuery#">

<!--- verify we can output it --->
<cfoutput query="qOutputQuery">
   #Name# #HomePhone#<br>
</cfoutput>
0
 
SiobhanElaraAuthor Commented:
I'm away from my machine at the moment, but I'll try to do this when I get home. Thank you for your help!
0
 
SiobhanElaraAuthor Commented:
It turned out that the result could be accessed only as a structure, not a query. I have no idea why, but I'm giving you the points for all your help. :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now