Have you tried running the stored procedure outside of CF? I don't
know if this will help, but I use WinSQL (free for personal use, I
believe) and I run the procedure through there to ensure I am getting
the proper results back.
I just started working with stored procedures, but I seem to recall at
one time that you have to put your cfprocparam tags in the same order
as the variables declared in your stored procedure.
HTH,
Tim P.
-----Original Message-----
From: sebastian palmigiani <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Date: Wed, 24 Jan 2001 13:37:36 -0600
Subject: Can anyone shed some light on this?
>
> I am running CFStudio 4.0 on Windows 98 and SQL Server 7.0.
>
> Is there an issue with the <cfprocparam> tag not passing the value of
> the
> database variable to SQL Server? I get 0 records returned.
>
> However, when I use <cfquery> with the same SQL query I get the right
> result. I've made sure that I have got the right sql type, which is
> varchar,
> and doubled check the settings in the stored procedure.
>
> I even reinstalled CF Server thinking it was some kind of corruption.
> Did
> not help. It must be some bug.
>
> Can anyone shed some light on this?
>
> Sebastian
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists