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]