Matthew, Is the tag <cfsavecontent> available in ColdFusion 4.5.x? I did not see it in the 4.5.x documentation?
Thanks, Troy Matthew Walker wrote: > 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
