No way around writting it to a file first. CF is a file driven language, so if you want to execute code, it has to be contained within a file. It's certainly not an ideal solution, but one that makes sense for certain situations.
If you're not needing tremendous scalability and you're on CFMX 6.1, writing to a file probably isn't a huge deal because the compiler is very fast. Reporting frequently leads itself to this kind of tradeoff. barneyb > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Behalf Of Justin Balog > Sent: Tuesday, October 07, 2003 11:53 AM > To: '[EMAIL PROTECTED]' > Subject: RE: [CFCDev] Dynamic SQL, Stored Procs, and Reports? [self > respon se] > > > > I have found you can write the code to a file then include it, and that > seems to be a horribly bad idea. Is there any other way to execute > dynamically built cf code? I want to build this string and execute it? > > <cfstoredproc datasource="myDSN" procedure="spTest"> > <cfprocparam type="Out" variable="returnVar" null="No" > cfsqltype="CF_SQL_VARCHAR"/></cfstoredproc> > > Sorry for the OT. > > Justin > > -----Original Message----- > From: Justin Balog [mailto:[EMAIL PROTECTED] > Sent: Tuesday, October 07, 2003 12:06 PM > To: '[EMAIL PROTECTED]' > Subject: [CFCDev] Dynamic SQL, Stored Procs, and Reports? > > > > Howdy, > > Kind of on the topic or reports, I was looking to build by storedproc call > dynamically, then execute it in my report cfc. Has anyone ever done this, > if so, do you evaluate the built string? > > Thanks, > > > Justin > ---------------------------------------------------------- > You are subscribed to cfcdev. To unsubscribe, send an email > to [EMAIL PROTECTED] with the word 'unsubscribe cfcdev' > in the message of the email. > > CFCDev is run by CFCZone (www.cfczone.org) and supported > by Mindtool, Corporation (www.mindtool.com). > > An archive of the CFCDev list is available at > www.mail-archive.com/[EMAIL PROTECTED] > ---------------------------------------------------------- > You are subscribed to cfcdev. To unsubscribe, send an email > to [EMAIL PROTECTED] with the word 'unsubscribe cfcdev' > in the message of the email. > > CFCDev is run by CFCZone (www.cfczone.org) and supported > by Mindtool, Corporation (www.mindtool.com). > > An archive of the CFCDev list is available at > www.mail-archive.com/[EMAIL PROTECTED] > ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the word 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED]
