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
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
