RE: loop with wddx2cfml in it.
Got any code to show? Ade -Original Message- From: Michael Beins [mailto:[EMAIL PROTECTED] Sent: 14 December 2007 19:42 To: CF-Talk Subject: loop with wddx2cfml in it. I am looping through a result set that has form data that is wddx encrypted and url encoded. I am getting the following error when looping through the result set. ErrorType: java.lang.ClassCastException with a Diagnostics of 'null null'. For debugging purpuoses I am only returning one record. If I use the cfoutput or cfloop with the query attribute I get the error. If I don't use either of those and just use queryname.field it works. Any ideas? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294880 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
loop with wddx2cfml in it.
I am looping through a result set that has form data that is wddx encrypted and url encoded. I am getting the following error when looping through the result set. ErrorType: java.lang.ClassCastException with a Diagnostics of 'null null'. For debugging purpuoses I am only returning one record. If I use the cfoutput or cfloop with the query attribute I get the error. If I don't use either of those and just use queryname.field it works. Any ideas? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294839 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
WDDX wddx2cfml error with cfqueryparam CF5 to CF7
Good Morning All! Having issues parsing a WDDX recordset pulled from an Oracle database. The recordset was created within JavaScript using the WDDX.js, and then passed to a CF page that inserts it into an Oracle Database. We ran into a size issue inserting the record, even though it appears there should have been no problem with the string length, and needed to insert the record with CFQUERYPARAM VALUE=#requestData# CFSQLType=cf_sql_longvarchar. We had tried CLOB in the CFSQLTYPE but that didn't work. The issue being, we are in the process of migrating from CF5 to 7. When pulling the recordset back in 5, there is no problems. When trying to pull back the recordset created in 5 to 7, there is an error that occurs when the cfwddx wddx2cfml is called saying it is an invalid WDDX packet. Outputting the datafield and viewing the source with Notepad++, I see that there is a Null in a black circle right after the closing wddxpacket. When I run the test on the CF7 server, creating the recordset with the same code, it appears to works both on the cf7 and 5 servers. Any thoughts on how to have the recordsets in 5 work after migration? Thanx! ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267707 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: WDDX wddx2cfml error with cfqueryparam CF5 to CF7
Good Morning All! Having issues parsing a WDDX recordset pulled from an Oracle database. The recordset was created within JavaScript using the WDDX.js, and then passed to a CF page that inserts it into an Oracle Database. We ran into a size issue inserting the record, even though it appears there should have been no problem with the string length, and needed to insert the record with CFQUERYPARAM VALUE=#requestData# CFSQLType=cf_sql_longvarchar. We had tried CLOB in the CFSQLTYPE but that didn't work. The issue being, we are in the process of migrating from CF5 to 7. When pulling the recordset back in 5, there is no problems. When trying to pull back the recordset created in 5 to 7, there is an error that occurs when the cfwddx wddx2cfml is called saying it is an invalid WDDX packet. Outputting the datafield and viewing the source with Notepad++, I see that there is a Null in a black circle right after the closing wddxpacket. When I run the test on the CF7 server, creating the recordset with the same code, it appears to works both on the cf7 and 5 servers. Any thoughts on how to have the recordsets in 5 work after migration? I suspect it's an encoding issue. CF 7 uses UTF-8 by default, CF 5 doesn't (and I don't know any easy way to make it do so). Presumably, if you're using CF 5 to create the data, you would need to retrieve the data using the same encoding used by CF 5, which presumably would be ISO-8859-1. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267735 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cfwddx action=wddx2cfml question
Col2 might not contain a query. download one of the following tools from the taggallery: cf_dump cf_objectdump Then, select the wddx packets from the db as you have and use these tools to examine the columns. These tools will let you visually see what information is in the columns and will tell you the datatype of the information. Col2 might hold a serialized array, or structure rather than a query. Besides, I think every developer should be using these tools it makes life SO MUCH EASIER! |-Original Message- |From: Evan Lavidor [mailto:[EMAIL PROTECTED]] |Sent: Sunday, April 01, 2001 12:36 AM |To: CF-Talk |Subject: cfwddx action="wddx2cfml" question | | |I have a table of data that was populated by an app not built |by me (so I'm |starting off at a disadvantage in terms of not knowing |everything about it - |I'm getting more info to help clear that up). | |In two of the columns in the table (SQL Server 7), the data |has been stored |as WDDX packets. | |So, I'm doing the following to get at them and have a look at |the data in a |more usable and understandable form: | || cfquery datasource="#Request.DSN_OldData#" dbtype="ODBC" |name="getpacket" |maxrows="1" || SELECT T.Col1, T.Col2 || FROM OldDataTable T || /cfquery || || cfwddx action="WDDX2CFML" input="#getpacket.col1" |output="col1query" || cfwddx action="WDDX2CFML" input="#getpacket.col2#" |output="col2query" || || cfoutput || #col1query.recordcount#br || #col1query.columnlist#br || br || #col2query.recordcount#br || #col2query.columnlist#br || /cfoutput | |All pretty straightforward, right? | |Both of the cfwddx tags execute fine and I see the recordcount and |columnlist from col1query. However, when it gets to the |col2query outputs, |I get the following: | || Error Diagnostic Information || An error occurred while evaluating the expression: || #col2query.recordcount# || || Error near line 26, column 2. || |--- |--- |-- || Error resolving parameter COL2QUERY.RECORDCOUNT || || The object RECORDCOUNT is not present in the scope named |COL2QUERY. It is |likely that you || have misspelled the name of the object you are trying to access. | | |Now, if it was an invalid packet (which it doesn't look like |when I just |output it to the screen), it would fail the cfwddx call, |right? Since it |passes it, why can't I access it like a query? | |Col1query works just fine. Gives me a recordcount, a |columnlist, I can loop |over records, etc. etc. etc. | | |Thanks in advance for any insight anyone can offer. | |Let's not even discuss the fact that I'm working on this at |12:35 on April |Fools Day ;-) | | |Evan | | | ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfwddx action=wddx2cfml question
Just to chime in:
I recommend the use of assertions. Don't assume that any input is present and
correct.
For example, my custom tag CF_ColumnList requires a CFML query as input, so I
test that this input item is:
(a) provided, via cfif not IsDefined("Attributes.Query")
(b) a CFML query object, via cfif not IsQuery(Attributes.Query)
-David
On Sunday, April 01, 2001 9:47 AM, Patricia Lee [SMTP:[EMAIL PROTECTED]] wrote:
Col2 might not contain a query.
download one of the following tools from the taggallery:
cf_dump
cf_objectdump
Then, select the wddx packets from the db as you have and use these tools to
examine the columns. These tools will let you visually see what information
is in the columns and will tell you the datatype of the information.
Col2 might hold a serialized array, or structure rather than a query.
Besides, I think every developer should be using these tools it makes
life SO MUCH EASIER!
|-Original Message-
|From: Evan Lavidor [mailto:[EMAIL PROTECTED]]
|Sent: Sunday, April 01, 2001 12:36 AM
|To: CF-Talk
|Subject: cfwddx action="wddx2cfml" question
|
|
|I have a table of data that was populated by an app not built
|by me (so I'm
|starting off at a disadvantage in terms of not knowing
|everything about it -
|I'm getting more info to help clear that up).
|
|In two of the columns in the table (SQL Server 7), the data
|has been stored
|as WDDX packets.
|
|So, I'm doing the following to get at them and have a look at
|the data in a
|more usable and understandable form:
|
|| cfquery datasource="#Request.DSN_OldData#" dbtype="ODBC"
|name="getpacket"
|maxrows="1"
||SELECT T.Col1, T.Col2
||FROM OldDataTable T
|| /cfquery
||
|| cfwddx action="WDDX2CFML" input="#getpacket.col1"
|output="col1query"
|| cfwddx action="WDDX2CFML" input="#getpacket.col2#"
|output="col2query"
||
|| cfoutput
||#col1query.recordcount#br
||#col1query.columnlist#br
||br
||#col2query.recordcount#br
||#col2query.columnlist#br
|| /cfoutput
|
|All pretty straightforward, right?
|
|Both of the cfwddx tags execute fine and I see the recordcount and
|columnlist from col1query. However, when it gets to the
|col2query outputs,
|I get the following:
|
|| Error Diagnostic Information
|| An error occurred while evaluating the expression:
|| #col2query.recordcount#
||
|| Error near line 26, column 2.
||
|---
|---
|--
|| Error resolving parameter COL2QUERY.RECORDCOUNT
||
|| The object RECORDCOUNT is not present in the scope named
|COL2QUERY. It is
|likely that you
|| have misspelled the name of the object you are trying to access.
|
|
|Now, if it was an invalid packet (which it doesn't look like
|when I just
|output it to the screen), it would fail the cfwddx call,
|right? Since it
|passes it, why can't I access it like a query?
|
|Col1query works just fine. Gives me a recordcount, a
|columnlist, I can loop
|over records, etc. etc. etc.
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfwddx action=wddx2cfml question
Yep. I also ran an IsQuery and IsStruct functions on it. Turns out one of them is a query and one of them is a structure. Thanks! Evan -Original Message- From: Patricia Lee [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 01, 2001 12:47 PM To: CF-Talk Subject: RE: cfwddx action="wddx2cfml" question Col2 might not contain a query. download one of the following tools from the taggallery: cf_dump cf_objectdump Then, select the wddx packets from the db as you have and use these tools to examine the columns. These tools will let you visually see what information is in the columns and will tell you the datatype of the information. Col2 might hold a serialized array, or structure rather than a query. Besides, I think every developer should be using these tools it makes life SO MUCH EASIER! |-Original Message- |From: Evan Lavidor [mailto:[EMAIL PROTECTED]] |Sent: Sunday, April 01, 2001 12:36 AM |To: CF-Talk |Subject: cfwddx action="wddx2cfml" question | | |I have a table of data that was populated by an app not built |by me (so I'm |starting off at a disadvantage in terms of not knowing |everything about it - |I'm getting more info to help clear that up). | |In two of the columns in the table (SQL Server 7), the data |has been stored |as WDDX packets. | |So, I'm doing the following to get at them and have a look at |the data in a |more usable and understandable form: | || cfquery datasource="#Request.DSN_OldData#" dbtype="ODBC" |name="getpacket" |maxrows="1" ||SELECT T.Col1, T.Col2 ||FROM OldDataTable T || /cfquery || || cfwddx action="WDDX2CFML" input="#getpacket.col1" |output="col1query" || cfwddx action="WDDX2CFML" input="#getpacket.col2#" |output="col2query" || || cfoutput ||#col1query.recordcount#br ||#col1query.columnlist#br ||br ||#col2query.recordcount#br ||#col2query.columnlist#br || /cfoutput | |All pretty straightforward, right? | |Both of the cfwddx tags execute fine and I see the recordcount and |columnlist from col1query. However, when it gets to the |col2query outputs, |I get the following: | || Error Diagnostic Information || An error occurred while evaluating the expression: || #col2query.recordcount# || || Error near line 26, column 2. || |--- |--- |-- || Error resolving parameter COL2QUERY.RECORDCOUNT || || The object RECORDCOUNT is not present in the scope named |COL2QUERY. It is |likely that you || have misspelled the name of the object you are trying to access. | | |Now, if it was an invalid packet (which it doesn't look like |when I just |output it to the screen), it would fail the cfwddx call, |right? Since it |passes it, why can't I access it like a query? | |Col1query works just fine. Gives me a recordcount, a |columnlist, I can loop |over records, etc. etc. etc. | | |Thanks in advance for any insight anyone can offer. | |Let's not even discuss the fact that I'm working on this at |12:35 on April |Fools Day ;-) | | |Evan | | | ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfwddx action=wddx2cfml question
I have a table of data that was populated by an app not built by me (so I'm starting off at a disadvantage in terms of not knowing everything about it - I'm getting more info to help clear that up). In two of the columns in the table (SQL Server 7), the data has been stored as WDDX packets. So, I'm doing the following to get at them and have a look at the data in a more usable and understandable form: | cfquery datasource="#Request.DSN_OldData#" dbtype="ODBC" name="getpacket" maxrows="1" | SELECT T.Col1, T.Col2 | FROM OldDataTable T | /cfquery | | cfwddx action="WDDX2CFML" input="#getpacket.col1" output="col1query" | cfwddx action="WDDX2CFML" input="#getpacket.col2#" output="col2query" | | cfoutput | #col1query.recordcount#br | #col1query.columnlist#br | br | #col2query.recordcount#br | #col2query.columnlist#br | /cfoutput All pretty straightforward, right? Both of the cfwddx tags execute fine and I see the recordcount and columnlist from col1query. However, when it gets to the col2query outputs, I get the following: | Error Diagnostic Information | An error occurred while evaluating the expression: | #col2query.recordcount# | | Error near line 26, column 2. | -- -- | Error resolving parameter COL2QUERY.RECORDCOUNT | | The object RECORDCOUNT is not present in the scope named COL2QUERY. It is likely that you | have misspelled the name of the object you are trying to access. Now, if it was an invalid packet (which it doesn't look like when I just output it to the screen), it would fail the cfwddx call, right? Since it passes it, why can't I access it like a query? Col1query works just fine. Gives me a recordcount, a columnlist, I can loop over records, etc. etc. etc. Thanks in advance for any insight anyone can offer. Let's not even discuss the fact that I'm working on this at 12:35 on April Fools Day ;-) Evan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfwddx action=wddx2cfml question
Well -- your not the only fool up hacking away... ^ / \__ (@\___ / O /(_/ /_/ Whoof... 410-757-3487 -Original Message- From: Evan Lavidor [SMTP:[EMAIL PROTECTED]] Sent: Sunday, April 01, 2001 12:36 AM To: CF-Talk Subject:cfwddx action="wddx2cfml" question I have a table of data that was populated by an app not built by me (so I'm starting off at a disadvantage in terms of not knowing everything about it - I'm getting more info to help clear that up). In two of the columns in the table (SQL Server 7), the data has been stored as WDDX packets. So, I'm doing the following to get at them and have a look at the data in a more usable and understandable form: | cfquery datasource="#Request.DSN_OldData#" dbtype="ODBC" name="getpacket" maxrows="1" | SELECT T.Col1, T.Col2 | FROM OldDataTable T | /cfquery | | cfwddx action="WDDX2CFML" input="#getpacket.col1" output="col1query" | cfwddx action="WDDX2CFML" input="#getpacket.col2#" output="col2query" | | cfoutput | #col1query.recordcount#br | #col1query.columnlist#br | br | #col2query.recordcount#br | #col2query.columnlist#br | /cfoutput All pretty straightforward, right? Both of the cfwddx tags execute fine and I see the recordcount and columnlist from col1query. However, when it gets to the col2query outputs, I get the following: | Error Diagnostic Information | An error occurred while evaluating the expression: | #col2query.recordcount# | | Error near line 26, column 2. | -- -- | Error resolving parameter COL2QUERY.RECORDCOUNT | | The object RECORDCOUNT is not present in the scope named COL2QUERY. It is likely that you | have misspelled the name of the object you are trying to access. Now, if it was an invalid packet (which it doesn't look like when I just output it to the screen), it would fail the cfwddx call, right? Since it passes it, why can't I access it like a query? Col1query works just fine. Gives me a recordcount, a columnlist, I can loop over records, etc. etc. etc. Thanks in advance for any insight anyone can offer. Let's not even discuss the fact that I'm working on this at 12:35 on April Fools Day ;-) Evan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
WDDX2CFML
I have a text file that is a WDDX packet. I want to read this packet into CF variables. How is this done? This is what I have tried so far. cfdirectory action="LIST" directory="D:\InetPub\wwwroot\800\ORM\attachments\direct" name="msg_attch" filter="*.txt" cfloop query="msg_attch" cfoutput !--- read the file to get the order packet --- cffile action="read" file="D:\InetPub\wwwroot\800\ORM\attachments\direct\#name#" variable="order" /cfoutput cfwddx action="WDDX2CFML" input="#order#" output="transformed" cfoutput query="transformed" #fieldNames# /cfoutput /cfloop I haven't done this before so any help would be appreciated. I can only find examples of this wherein you are implicitly posting a packet. I want to read a file and those examples are not to helpful in this case. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
