Re: CFWDDX

Marlon Moyer Tue, 10 Dec 2002 12:03:38 -0800

You're not storing them in persistent variables (i.e. client or session)



Alford, Gary wrote:

IT ISN'T WORKING CORRECTLY.

MY TEST PAGE, TEST4.CFM, HAS THE FOLLOWING CODE (LINE NUMBERS ADDED FOR
CLARITY):

1) <CFQUERY NAME="manufaddr" datasource="OracleProd" username="spa"
password="spawxqz">
2) SELECT VENDOR.VNDR.VNDR_ID, VENDOR.VNDR.LN1_FULL_NM,
VENDOR.VNDR.LN2_FULL_NM, VENDOR.VNDR.CLSIF_CD, 3) VENDOR.ADDR.LN1_ADDR, VENDOR.ADDR.LN2_ADDR,
VENDOR.ADDR.LN3_ADDR, VENDOR.ADDR.LN4_ADDR, 4) VENDOR.ADDR.CITY_NM, VENDOR.ADDR.STATE_CD,
VENDOR.ADDR.CNTRY_CD, VENDOR.ADDR.ZIP_CD
5) FROM VENDOR.ADDR, VENDOR.VNDR, VENDOR.VNDR_ADDR 6) WHERE VENDOR.VNDR.VNDR_ID = '0000001990'
7) AND VENDOR.VNDR.BSNS_UNIT_ID = VENDOR.VNDR_ADDR.BSNS_UNIT_ID

8) AND VENDOR.VNDR.VNDR_ID = VENDOR.VNDR_ADDR.VNDR_ID 9) AND VENDOR.VNDR.BSNS_UNIT_ID = 'FTW' 10) AND VENDOR.ADDR.ADDR_ID = VENDOR.VNDR_ADDR.ADDR_ID 11) AND VENDOR.VNDR_ADDR.ADDR_TYP_CD = 'M'
12) AND VENDOR.VNDR_ADDR.EFF_DT = (SELECT
MAX(VENDOR.VNDR_ADDR.EFF_DT)
13) FROM
VENDOR.VNDR_ADDR
14) WHERE
VENDOR.VNDR_ADDR.BSNS_UNIT_ID = 'FTW'
15) AND
VENDOR.VNDR_ADDR.ADDR_TYP_CD = 'M'
16) AND
VENDOR.VNDR_ADDR.VNDR_ID = '0000001990')
17) </CFQUERY>
18) 19) <CFQUERY NAME="ordaddr" datasource="OracleProd" username="spa"
password="spawxqz">
20) SELECT VENDOR.VNDR.VNDR_ID, VENDOR.VNDR.LN1_FULL_NM,
VENDOR.VNDR.LN2_FULL_NM, VENDOR.VNDR.CLSIF_CD, 21) VENDOR.ADDR.LN1_ADDR, VENDOR.ADDR.LN2_ADDR,
VENDOR.ADDR.LN3_ADDR, VENDOR.ADDR.LN4_ADDR, 22) VENDOR.ADDR.CITY_NM, VENDOR.ADDR.STATE_CD,
VENDOR.ADDR.CNTRY_CD, VENDOR.ADDR.ZIP_CD
23) FROM VENDOR.ADDR, VENDOR.VNDR, VENDOR.VNDR_ADDR 24) WHERE VENDOR.VNDR.VNDR_ID = '0000001990' 25) AND VENDOR.VNDR.BSNS_UNIT_ID = VENDOR.VNDR_ADDR.BSNS_UNIT_ID

26) AND VENDOR.VNDR.VNDR_ID = VENDOR.VNDR_ADDR.VNDR_ID 27) AND VENDOR.VNDR.BSNS_UNIT_ID = 'FTW' 28) AND VENDOR.ADDR.ADDR_ID = VENDOR.VNDR_ADDR.ADDR_ID
29) AND VENDOR.VNDR_ADDR.ADDR_TYP_CD = 'O'
30) AND VENDOR.VNDR_ADDR.EFF_DT = (SELECT
MAX(VENDOR.VNDR_ADDR.EFF_DT)
31) FROM
VENDOR.VNDR_ADDR
32) WHERE
VENDOR.VNDR_ADDR.BSNS_UNIT_ID = 'FTW'
33) AND
VENDOR.VNDR_ADDR.ADDR_TYP_CD = 'O'
34) AND
VENDOR.VNDR_ADDR.VNDR_ID = '0000001990')
35) </CFQUERY>
36) 37) ...
40) 41) 
42) 43) 
44) <cfwddx action="CFML2WDDX" input="#manufaddr#"
output="Manufacturing_Address">
45) <cfwddx action="CFML2WDDX" input="#ordaddr#" output="Ordering_Address">
46) 47) 
48) 
49) <cfoutput>
50) 
51) The Manufacturing Address is: 
52) #manufaddr.VNDR_ID# 
53) #manufaddr.LN1_FULL_NM# 
54) #manufaddr.CLSIF_CD# 
55) #manufaddr.LN1_ADDR# 
56) #manufaddr.CITY_NM# 
57) #manufaddr.STATE_CD# 
58) #manufaddr.CNTRY_CD# 
59) #manufaddr.ZIP_CD# 
60) 
61) The manufacturing address was serialized into the
following WDDX Packet:
62)
63) #HTMLEditFormat(Manufacturing_Address)#
64) 
65) <hr>
66) 
67) The Ordering Address is: 
68) #ordaddr.VNDR_ID# 
69) #ordaddr.LN1_FULL_NM# 
70) #ordaddr.CLSIF_CD# 
71) #ordaddr.LN1_ADDR# 
72) #ordaddr.CITY_NM# 
73) #ordaddr.STATE_CD# 
74) #ordaddr.CNTRY_CD# 
75) #ordaddr.ZIP_CD# 
76) 
77) The ordering address was serialized into the following
WDDX Packet:
78)
79) #HTMLEditFormat(Ordering_Address)#
80) </cfoutput>

THEN, WHEN I PULL UP MY SECOND TEST PAGE, TEST6.CFM (WITH THE FOLLOWING
CODE, LINE NUMBERS ADDED FOR CLARITY), INSTEAD OF SEEING THE ACTUAL OUTPUT,
I RECEIVE AN APPLICATION ERROR STATING THAT COLDFUSION WAS UNABLE TO
DETERMING THE VALUE OF THE PARAMETER.

1) 
2) <cfwddx action="WDDX2CFML" input="#Manufacturing_Address#"
output="manufaddr">
3) <cfwddx action="WDDX2CFML" input="#Ordering_Address#" output="ordaddr">
4) 5) 
6) <cfoutput>
7) 
8) The Manufacturing Address is: 
9) #manufaddr.VNDR_ID# 
10) #manufaddr.LN1_FULL_NM# 
11) #manufaddr.CLSIF_CD# 
12) #manufaddr.LN1_ADDR# 
13) #manufaddr.CITY_NM# 
14) #manufaddr.STATE_CD# 
15) #manufaddr.CNTRY_CD# 
16) #manufaddr.ZIP_CD# 
17) 
18) 
19) <hr>
20) 
21) The Manufacturing Address is: 
22) #ordaddr.VNDR_ID# 
23) #ordaddr.LN1_FULL_NM# 
24) #ordaddr.CLSIF_CD# 
25) #ordaddr.LN1_ADDR# 
26) #ordaddr.CITY_NM# 
27) #ordaddr.STATE_CD# 
28) #ordaddr.CNTRY_CD# 
29) #ordaddr.ZIP_CD# 
30) 
31) </cfoutput>

HAS ANYONE GOT ANY SUGGESTIONS OR INPUT AS TO WHERE I AM GOING WRONG?

============================================

Gary L. Alford Senior Material and Procurement Systems Specialist Bell Helicopter Textron Phone: (817) 280-6233 Fax: (817) 278-6233 mailto:[EMAIL PROTECTED] ============================================

-----Original Message-----
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 10, 2002 12:42 PM
To: [EMAIL PROTECTED]
Subject: RE: CFWDDX

don't mention it. :)

oops.... you're right. I wrote fast and didnt test.
Thanks.

-----Original Message-----
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 10, 2002 10:40 AM
To: [EMAIL PROTECTED]
Subject: RE: CFWDDX

here you go...

In
<cfwddx action="CFML2WDDX" input="queryname"
output="wddxpacketname">

Out
<cfwddx action="WDDX2CFML" input="wddxpacketname"
output="queryname">

You need # around the input attributes (typo I'm
guessing), otherwise, it's
just going to serialize a packet containing
<var><string>queryname</string></var> going in and produce
an error coming
out saying that "wddxpacketname" is not a valid wddx
packet.

Other than that this should be all you need.

Jeremy

-----Original Message-----
From: Alford, Gary
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 10, 2002 10:14 AM
To: DFW ColdFusion Users Group (E-mail)
Subject: CFWDDX

Hey, gang,

What is the best way to send a query result set to a wddx
package? Then
what would be the best way to extract the data from the
wddx package later?
============================================
Gary L. Alford
Senior Material and Procurement Systems Specialist
Bell Helicopter Textron
Phone: (817) 280-6233
Fax: (817) 278-6233
mailto:[EMAIL PROTECTED]
============================================
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To unsubscribe:
Send UNSUBSCRIBE to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org

s. isaac dealey 954-776-0046

new epoch http://www.turnkey.to

lead architect, tapestry cms http://products.turnkey.to

certified advanced coldfusion 5 developer
http://www.macromedia.com/v1/handlers/index.cfm?ID=21816

-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To unsubscribe:
Send UNSUBSCRIBE to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To unsubscribe:
Send UNSUBSCRIBE to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org

s. isaac dealey 954-776-0046

new epoch http://www.turnkey.to

lead architect, tapestry cms http://products.turnkey.to

certified advanced coldfusion 5 developer
http://www.macromedia.com/v1/handlers/index.cfm?ID=21816

-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To unsubscribe: Send UNSUBSCRIBE to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To unsubscribe: Send UNSUBSCRIBE to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org

-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To unsubscribe: Send UNSUBSCRIBE to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org

Re: CFWDDX

Reply via email to