Does this code below produce "ONE, TWO" for you?
(it does does some table and procedure creation and cleanup, but you can
get rid of that)
-Steven Erat
<cfset dsn ="YOUR DATASOURCE">
<cftry>
<CFQUERY name="dropTable" datasource="#dsn#">
drop table CFQADBVARTESTTABLE2
</CFQUERY>
<cfcatch></cfcatch></cftry>
<CFQUERY name="createTable" datasource="#dsn#">
Create Table CFQADBVARTESTTABLE2(
RowID int identity,
VarName1 varchar(30),
VarName2 varchar(30)
)
</CFQUERY>
<cftry>
<CFQUERY name="dropProc" datasource="#dsn#">
drop procedure sp_CFQADBVARTESTTABLE2
</CFQUERY>
<cfcatch></cfcatch></cftry>
<CFQUERY name="createProc" datasource="#dsn#">
create procedure sp_CFQADBVARTESTTABLE2
(
@p_VarName1 varchar(30),
@p_VarName2 varchar(30)
)
as
insert into CFQADBVARTESTTABLE2 (VarName1, VarName2) values
(@p_VarName1, @p_VarName2)
return 0
</CFQUERY>
<cftry>
<CFSTOREDPROC PROCEDURE="sp_CFQADBVARTESTTABLE2"
datasource="#dsn#"
returncode="no">
<CFPROCPARAM type="In" cfsqltype="CF_SQL_VARCHAR" value="TWO"
dbvarname="@p_VarName2">
<CFPROCPARAM type="In" cfsqltype="CF_SQL_VARCHAR" value="ONE"
dbvarname="@p_VarName1">
</CFSTOREDPROC>
<cfcatch>
<cfoutput><br/><br/>
#cfcatch.message#<br/>
#cfcatch.Detail#<br/>
#cfcatch.sql#</br><br/>
</cfoutput>
</cfcatch>
</cftry>
<cfquery name="qSelect" datasource="#dsn#">
SELECT VarName1, VarName2 FROM CFQADBVARTESTTABLE2
</cfquery>
<cfoutput>#qSelect.VarName1[1]#, #qSelect.VarName2[1]#</cfoutput>
<!---
expected result
ONE, TWO
--->
<cftry>
<CFQUERY name="dropTable" datasource="#dsn#">
delete from CFQADBVARTESTTABLE2
</CFQUERY>
<cfcatch></cfcatch></cftry>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263345
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
