How about this... (it's a bit messy)
<cfquery...>
<cfsavecontent variable="myquery">
SELECT *
FROM myTable
WHERE something = <cfqueryparam value="#myvalue#"...>
</cfsavecontent>
<cfoutput>#myquery#</cfoutput>
</cfquery>
<cfoutput>#myquery#</cfoutput>
Matthew Walker
Electric Sheep Web
http://www.electricsheep.co.nz/
----- Original Message -----
From: "Troy Simpson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, March 01, 2003 8:45 AM
Subject: Display the used query.
> I currently have a need to display the query that was used in a page to
> the user (sysadmin).
>
> Here is what the query looks like:
>
> <cfquery name="qryFirstCO"
> datasource="#Application.DSN#"
> dbtype="#Application.DSNDBType#" debug="1">
> SELECT
> count(*) as TheCount
> FROM
> chargeout
> WHERE
> chargeoutdate
> BETWEEN TO_DATE(<cfqueryparam value='20-DEC-2002'
> cfsqltype='CF_SQL_CHAR'>,'DD-MON-YYYY')
> AND TO_DATE(<cfqueryparam value='20-FEB-2003'
> cfsqltype='CF_SQL_CHAR'>,'DD-MON-YYYY')
>
> </cfquery>
>
> When the query completes, I want to display the results and query syntax
> on an HTML page.
> How can I display the query syntax to the user (sysadmin)?
>
> I have tried putting the query into a string variable and passing it to
> <cfquery> but I lose the benefit of the bind variables (<cfqueryparam>).
>
> The DEBUG option in the CF Administrator is not an option.
>
> I'm using ColdFusion 4.5.1 or 4.5.2. Please no CFMX solutions unless
> they also work in ColdFusion 4.5.x.
>
>
> Thanks,
> Troy
>
> -------------------------
> Troy Simpson
> Applications Analyst/Programmer, OCPDBA, MCSE, SCSA
> North Carolina State University Libraries
> Campus Box 7111 | Raleigh | North Carolina
> ph.919.515.3855 | fax.919.513.3330
> E-mail: [EMAIL PROTECTED]
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
