Yes, using MSSQL2000.
<CFstoredproc
Procedure="GetMailingLabList_MyEnrolmentList" datasource=#dsn#
ReturnCode="YES">
<cfprocparam type="In"
cfsqltype="CF_SQL_INTEGER" variable="@MYUSERID" value="#CLIENT.User_Id#"
null="No">
<CFPROCRESULT NAME = MyEnrolmentList>
</CfStoredProc>
> -----Original Message-----
> From: Mark M [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, 20 January 2004 9:56 AM
> To: CFAussie Mailing List
> Subject: [cfaussie] Re: CF 5 to MX upgrade problems
>
> Leon -
>
> Can we see some code on calling the stored proc from CF?
>
> There have been some small changes between versions.
>
> I assue MSSQL as well?
>
> Mark
> ------------------------------------------------------------------
> [EMAIL PROTECTED]
> ICQ: 3094740
> Safe From Bees
> [ www.safefrombees.com ]
>
>
> Quoting Leon Seremelis <[EMAIL PROTECTED]>:
>
> > Cheers all,
> >
> > After the upgrade to MX, I'm encountering problems with
> executing some
> > stored procedures. The stored procs grabs data and places it into a
> > temporary table which is then read by a DTS package to
> produce a csv
> > file. Now the problem I am having is that SQL is placing
> locks on the
> > temporary table which is causing the system to just hang. Of course
> > everything works fine on an exact duplicate of the system
> on my machine.
> > Any ideas would be _greatly_ appriciated.
> >
> > Leon
> >
> >
> > ---
> > You are currently subscribed to cfaussie as:
> [EMAIL PROTECTED] To
> > unsubscribe send a blank email to
> > [EMAIL PROTECTED]
> >
> > MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
> > http://www.mxdu.com/ + 24-25 February, 2004
> >
> >
> >
>
> ---
> You are currently subscribed to cfaussie as:
> [EMAIL PROTECTED] To unsubscribe send a blank
> email to [EMAIL PROTECTED]
>
> MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
> http://www.mxdu.com/ + 24-25 February, 2004
>
>
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004
