What version of CF are you using? In 7, there is the new RESULT attribute
allowing you to name a variable which is a structure, and one of its keys is
SQL and another is sqlparameters:
CFQUERY NAME=demoq DATASOURCE=cfdocexamples result=test
select * from employees
where lastname =
The [Unknown Type] can normally be fixed with this hotfix
http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=1a9c83c
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On
Behalf Of Scott Thornton
Sent: Wednesday, 21 February 2007 12:08 PM
To:
OK, I've done a little digging and this works in CFMX 6 and 7:
CFQUERY NAME=demoq DATASOURCE=cfdocexamples
select * from employees
where lastname = cfqueryparam value=smith
cfsqltype=CF_SQL_VARCHAR
/CFQUERY
cfdump var=#demoq#
cfset factory = createobject(java,