CF Talk List
I am writing my first cold fusion stored procedure call. I
am getting an error I do not understand and do not know how
to correct. I am unable to find any information on the
error, and I am hoping somebody out there can give me a
lead. Here is the cold fusion code I am using to call the
stored procedure.
<CFSTOREDPROC
PROCEDURE="sp_ktChgsPmtsByDate"
DATASOURCE="Paragon"
USERNAME="sa"
PASSWORD=""
PROVIDER="OLEDB"
DBSERVER="SQL6932440"
DBNAME="paragon"
RETURNCODE="YES"
DEBUG>
<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>
But when I run this code, and all the alternate
configurations I've tried so far, I get this error.
Error Occurred While Processing Request
Error Diagnostic Information
OLEDB Error Code = 0
NULL Interface Ptr
SQL = "sp_ktChgsPmtsByDate"
Data Source = "Paragon"
The error occurred while processing an element with a
general identifier of
(CFSTOREDPROC), occupying document position (18:1) to
(26:7) in the
template file ...\YestPaymntsToPatAccts.cfm.
I know the stored procedure works, and we were able to
create ASP code to access the stored procedure. But I'm
stubborn and I would like to know why I can't get this to
work in cold fusion.
ASP Code
sSDate = Request.QueryString ("FromMonth") & "/" &
Request.QueryString ("FromDay") & "/" &
Request.QueryString ("FromYear")
sEDate = Request.QueryString ("ToMonth") & "/" &
Request.QueryString ("ToDay") & "/" &
Request.QueryString ("ToYear")
sSPName = Request.QueryString ("SPName")
Set adoConnect =
Server.CreateObject("ADODB.Connection"):
adoConnect.ConnectionTimeout = 30 'increment the time
to establish connection a bit
adoConnect.CommandTimeout = 300 'give it five minutes
to complete the query
adoConnect.Open "Provider=MSDASQL;Driver={SQL
Server};Server=SQL6932440;Database=paragon;UID=sa;PWD=;"
Set adoRecordset = adoConnect.Execute (sSPName & " '"&
sSDate & "','" & sEDate & "'")
Thank You in Advance
Ian Skinner
[EMAIL PROTECTED]
www.ilsweb.com
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
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
