Um no sorry didn't read your message properly. I'm gonna blame the fact that it's Saturday morning here and I haven't poured that coffee yet. However you can get custom tags that emulate cfsavecontent (I believe the custom tags were actually the inpiration for Macromedia to add it as a tag). I think Dave has demonstrated it. It's handy in many circumstances.
----- Original Message ----- From: "Troy Simpson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, March 01, 2003 9:08 AM Subject: Re: Display the used query. > 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 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
