The only thing that jumped out at me was the line: <CFSET ImportCount = CFSTOREDPROC.STATUSCODE>
Shouldn't it read? <CFSET ImportCount = YestPayments.STATUSCODE> Just my $.02 ______________________________________________________ Bill Grover Supervisor MIS Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com ______________________________________________________ > -----Original Message----- > From: Ian Skinner [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, March 12, 2002 11:15 AM > To: CF-Talk > Subject: Stored Procedure Help > > > I'm trying to write my first Cold Fusion Stored Procedure. > And I have run into a problem. Can someone help explain > what this error means: "NULL Interface Ptr"? I've looked in > the online help documentation, and on Macromedia/Allair's > web site and there is absolutely no reference to this error, > incredibly. > > This is the cold fusion code I am using: > > <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
