as Marlon stated.... the reason you don't see the packet on test6 is because the variable doesn't exist.
store the packet in a session variable on test4 - then reference it in test6 (<cfwddx...input="#session.Manufact....) get it? -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Alford, Gary Sent: Wednesday, December 11, 2002 8:09 AM To: '[EMAIL PROTECTED]' Subject: RE: CFWDDX Thanks for your help guys. I've got to research this a little further. ============================================ 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: Marlon Moyer [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 10, 2002 2:05 PM To: [EMAIL PROTECTED] Subject: Re: CFWDDX 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) <!--- Set the queries to simple string values ---> >42) >43) <!--- Serialize the query variables into WDDX Packets ---> >44) <cfwddx action="CFML2WDDX" input="#manufaddr#" >output="Manufacturing_Address"> >45) <cfwddx action="CFML2WDDX" input="#ordaddr#" output="Ordering_Address"> >46) >47) <!--- Output WDDX Packet so we can see what it looks like ---> >48) <!--- (HTMLEditFormat function lets us see tags properly) ---> >49) <cfoutput> >50) <p> >51) <strong>The Manufacturing Address is:</strong><br> >52) #manufaddr.VNDR_ID#<br> >53) #manufaddr.LN1_FULL_NM#<br> >54) #manufaddr.CLSIF_CD#<br> >55) #manufaddr.LN1_ADDR#<br> >56) #manufaddr.CITY_NM#<br> >57) #manufaddr.STATE_CD#<br> >58) #manufaddr.CNTRY_CD#<br> >59) #manufaddr.ZIP_CD#<br> >60) </p> >61) <p><strong>The manufacturing address was serialized into the >following WDDX Packet:</strong></p> >62) >63) #HTMLEditFormat(Manufacturing_Address)# >64) <br> >65) <hr> >66) <p> >67) <strong>The Ordering Address is:</strong><br> >68) #ordaddr.VNDR_ID#<br> >69) #ordaddr.LN1_FULL_NM#<br> >70) #ordaddr.CLSIF_CD#<br> >71) #ordaddr.LN1_ADDR#<br> >72) #ordaddr.CITY_NM#<br> >73) #ordaddr.STATE_CD#<br> >74) #ordaddr.CNTRY_CD#<br> >75) #ordaddr.ZIP_CD#<br> >76) </p> >77) <p><strong>The ordering address was serialized into the following >WDDX Packet:</strong></p> >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) <!--- De-Serialize the WDDX Packets set in test4.cfm ---> >2) <cfwddx action="WDDX2CFML" input="#Manufacturing_Address#" >output="manufaddr"> >3) <cfwddx action="WDDX2CFML" input="#Ordering_Address#" output="ordaddr"> >4) >5) <!--- Output WDDX Packets so we can see what it looks like ---> >6) <cfoutput> >7) <p> >8) <strong>The Manufacturing Address is:</strong><br> >9) #manufaddr.VNDR_ID#<br> >10) #manufaddr.LN1_FULL_NM#<br> >11) #manufaddr.CLSIF_CD#<br> >12) #manufaddr.LN1_ADDR#<br> >13) #manufaddr.CITY_NM#<br> >14) #manufaddr.STATE_CD#<br> >15) #manufaddr.CNTRY_CD#<br> >16) #manufaddr.ZIP_CD#<br> >17) </p> >18) <br> >19) <hr> >20) <p> >21) <strong>The Manufacturing Address is:</strong><br> >22) #ordaddr.VNDR_ID#<br> >23) #ordaddr.LN1_FULL_NM#<br> >24) #ordaddr.CLSIF_CD#<br> >25) #ordaddr.LN1_ADDR#<br> >26) #ordaddr.CITY_NM#<br> >27) #ordaddr.STATE_CD#<br> >28) #ordaddr.CNTRY_CD#<br> >29) #ordaddr.ZIP_CD#<br> >30) </p> >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 ----------------------------------------------- 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
