Hi all,
I'm very new to Cold Fusion, so this is probably awfully basic, but here goes
anyway. Help would be greatly appreciated. Working on oracle I have this
valid
query.
select count("Incident #") c1, "Login ID Opened By" liob from
"_SMDBA_"."Incident"
where "Incident #" > 190000 group by "Login ID Opened By"
Now I want to implement this in CF with this ...
<cfquery name="Test1" datasource="MagicTestData">
select count("Incident #") c1, "Login ID Opened By" liob from
"_SMDBA_"."Incident"
where "Incident #" > 190000 group by "Login ID Opened By"
</cfquery>
<cfoutput query="Test1">#c1# #liob#</p></cfoutput>
But I get an error:
Invalid CFML construct found on line 13 at column 34.
The CFML compiler was processing: An expression that began on line 13, column
25.
Your expression might be missing an ending "#" (it might look like #expr ).
The
body of a cfquery tag beginning on line 12, column 4.Anybody know how to
escape
the query to avoid that?
Thanks,
Ben.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=37
Message: http://www.houseoffusion.com/lists.cfm/link=i:15:438
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/15
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:15
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
