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