provider="SQLOLEDB"

> -----Original Message-----
> From: Ian Skinner [mailto:[EMAIL PROTECTED]]
> Sent: 12 March 2002 16:15
> 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>
> 
> 
> 
> 
> 
______________________________________________________________________
Why Share?
  Dedicated Win 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=coldfusionc
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


Reply via email to