> I know that some people are going to disagree with me.. but I > hate using the > storedproc tag.
well, both ways of calling SPs have their pros and cons.... with <cfstoredproc> you can retrieve multiple recordsets - a really useful way of encapsulating your SQL queries and maintaining efficiency with <cfquery> you can cache the SP call in the same way as a normal <cfquery> obviously, use one or the other depending on the situation I'd love to have both abilities in one tag. > -----Original Message----- > From: Clint Tredway [mailto:[EMAIL PROTECTED]] > Sent: 12 March 2002 16:24 > To: CF-Talk > Subject: RE: Stored Procedure Help > > > I know that some people are going to disagree with me.. but I > hate using the > storedproc tag. > > Try running this through cfquery and see what happens... > <cfquery name="YestPayments" datasource="Paragon"> > execute sp_ktChgsPmtsByDate @sdate='#sdate#',@Edate='#edate#' > </cfquery> > > My 2cents > Clint > > > <CFSET SDate=Now()> > <CFSET EDate=DateAdd("d",1,Now())> > > <CFSTOREDPROC > procedure="sp_ktChgsPmtsByDate" > datasource="Paragon" > provider="OLEDB" > providerdsn="Paragon" > DEBUG="YES"> > > <CFPROCPARAM TYPE="In" DBVARNAME="@SDate" > VALUE="#SDate#" CFSQLTYPE="CF_SQL_DATE"> > > <CFPROCPARAM TYPE="In" DBVARNAME="@EDate" > VALUE="#EDate#" CFSQLTYPE="CF_SQL_DATE"> > > <CFPROCRESULT NAME="YestPayments"> > > </CFSTOREDPROC> > > <CFSET ImportCount = CFSTOREDPROC.STATUSCODE> > > > > > > ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
