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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to