> I've looked through the knowledge base for this one and
> couldn't find any answers. I'm also new to the list so
> you'll have to forgive me if this question has already
> been answered.
>
> Does the InOut Type for CFPROCPARAM work with MS Sql Server
> on Cold Fusion? I've read that some people have had problems
> with this on Oracle as well, but it seems to have been a
> problem with an ODBC driver.
>
> We're using Sql Server 7 with the latest ODBC drivers as well
> as Cold Fusion 4.0.
It works fine with SQL Server 7. I didn't know myself until I tried it.
Here's the stored proc I used to test:
CREATE PROCEDURE sp_Increment
@inoutvar int OUTPUT
AS
SELECT @inoutvar = @inoutvar + 1
and here's the CF script:
<CFSTOREDPROC PROCEDURE="sp_Increment" DATASOURCE="myds">
<CFPROCPARAM TYPE="InOut"
CFSQLTYPE="CF_SQL_INTEGER"
VARIABLE="mynewvar"
DBVARNAME="inoutvar"
VALUE="1"
NULL="No">
</CFSTOREDPROC>
<CFOUTPUT>#mynewvar#</CFOUTPUT>
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
