I hit the 15 minute mark and just couldn't see it...LOL...that's why I love this list ;-)
Cheers
Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]
---------------------------------------------------------
Macromedia Associate Partner
www.macromedia.com
---------------------------------------------------------
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com
----- Original Message -----
From: Josh Remus
To: CF-Talk
Sent: Wednesday, February 04, 2004 12:27 PM
Subject: RE: cast issue
shouldn't it be without the pound signs for the query name?
-----Original Message-----
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 04, 2004 3:16 PM
To: CF-Talk
Subject: cast issue
Hey All,
1) I've got a structure that has a key (among other keys) which has a
value
that is a query
2) I pass that structure as an argumentcollection to a function in a CFC
3) In the function I am trying to loop over the query that is the value of
that key
I'm getting this "Complex object types cannot be converted to simple
values.
"
So CF is recognizing the value of the key as a query, but I don't
understand
why it's trying to convert it to a simple value (especially when in the
query attribute for cfloop which expects a complex object type).
Here's the call that craps out (part of a function):
<!--- insert Tx Detail record(s) --->
<cfquery name="qInsertTxDetail" datasource="#REQUEST.SystemDSN#"
username="#REQUEST.DSNuser#" password="#REQUEST.DSNpass#">
<cfloop query="#ARGUMENTS.LineItems#">
INSERT INTO tran_transaction
(
tran_id,
trde_description,
trde_amount
)
VALUES
(
<cfqueryparam
value="#Replace(ARGUMENTS.OrderID,'pm','','ALL')#"
cfsqltype="cf_sql_integer">,
<cfqueryparam value="#Description#"
cfsqltype="cf_sql_varchar" maxlength="60">,
<cfqueryparam value="#Amount#"
cfsqltype="cf_sql_money">
);
</cfloop>
</cfquery>
The line that craps out is : <cfloop query="#ARGUMENTS.LineItems#">
I have verified via CFDUMP that ARGUMENTS.LineItems is a query
Any ideas??
Cheers
Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]
---------------------------------------------------------
Macromedia Associate Partner
www.macromedia.com
---------------------------------------------------------
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
