Sorry about the OT, but both replies have me thinking. Thanks much as always.
Take care, Justin -----Original Message----- From: Nathan Dintenfass [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 1:06 PM To: [EMAIL PROTECTED] Subject: RE: [CFCDev] Dynamic SQL, Stored Procs, and Reports? [self respon se] [insert obligatory urging to keep posts on topic -- about CFCs] You can do that, but generally speaking it's a bad idea. Performance will be considerably less than optimal using that method, which likely defeats much of the benefit of using a stored proc in the first place. Why not just dynamically build a SQL string and/or just dynamically populate the attributes of a CFSTOREDPROC call? Or, call a custom tag that takes the necessary parameters and internally does some conditional logic to call the proper stored proc? > -----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] ---------------------------------------------------------- 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]
