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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
