I think CF_SQL_REFCURSOR may only work with Oracle. An MS SQL Server SP can return (multiple) result sets like this create procedure myprocedure as select * from firsttable select * from secondtable end then you use matching CFPROCRESULT subtags. -----Original Message----- From: Don Vawter [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 07, 2001 4:15 PM To: CF-Talk Subject: Cursors in stored proc I receive at type mismatch error: Microsoft][ODBC SQL Server Driver][SQL Server]Operand type clash: char is incompatible with cursor when I call a stored proc which returns a result set: The offending code is: <cfstoredproc datasource="#request.ds#" procedure="usp_attribute_values"> <cfprocparam type="In" cfsqltype="CF_SQL_INTEGER" dbvarname="Attribute_ID" null="Yes"> <cfprocparam type="Out" cfsqltype="CF_SQL_REFCURSOR" variable="qout" dbvarname="attcursor" null="Yes"> <cfprocresult name="q2"> </cfstoredproc> and the declaration of the stored proc is: CREATE PROCEDURE usp_attribute_values @attribute_id int, @attcursor cursor varying out AS Environment SQL Server 2000, Win2K, CF 4.52 What am I missing here? TIA Don Vawter ----- Original Message ----- From: "Chad McCue" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, June 07, 2001 12:29 PM Subject: Finding out when a application has been timed out. > My problem is I can't allow more than two people logged in to my admin section at once. The problem I am having is when the session times out, I need to somehow go into the database and change my field that says someone is logged in. Right now it works fine if the user logs himself out of the admin section. > > Any ideas would be great. Thanks > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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
