We are trying to call a Sybase system procedure (version 12.5) from Coldfusion
(6,1,0,63958). We have tried this:
<cfstoredproc
procedure = "sp_modifylogin"
dataSource = "#Application.dataloadsDSN#"
returnCode = "Yes">
<cfprocparam
type = "in"
dbVarName = "loginame"
value = "adv_test"
CFSQLType = "CF_SQL_VARCHAR"
maxLength = "30">
<cfprocparam
type = "in"
dbVarName = "option"
value = "login script"
CFSQLType = "CF_SQL_VARCHAR"
maxLength = "30">
<cfprocparam
type = "in"
dbVarName = "value"
value = "um_check_login"
CFSQLType = "CF_SQL_VARCHAR"
maxLength = "255">
</cfstoredproc>
And we have tried this:
<cfquery name="qupdateUser3" datasource="#Application.dataloadsDSN#">
exec sp_modifylogin adv_test, 'login script', um_check_login
</cfquery>
In both cases, it appears as if the procedure runs, however it does not update
the system tables. If we run the same command at the isql prompt it works. We
are using the same user with the same privileges. Is there some setting that
we need to set on the Coldfusion side? Any help greatly appreciated.
Vladimir Jirinec
University System of Maryland
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255703
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
