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>
______________________________________________________________________
Get Your Own 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=coldfusionb
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
