Can anybody see what I am doing wrong here? I am not getting any errors,
but it's not updating either. On the SQL server I have the permissions
execute box checked for the dbo user (the only user in there). This same
exact task works just fine if I use a standard CFQUERY instead of the method
below.
<!--- CF Code in Question --->
<cfstoredproc procedure="update_member_id_and_pass"
datasource="#request.maindsn#">
<cfprocparam type="IN" dbvarname="@cfid" value="#Client.cfid#"
cfsqltype="CF_SQL_VARCHAR">
<cfprocparam type="IN" dbvarname="@member_id" value="#attributes.email#"
cfsqltype="CF_SQL_VARCHAR">
<cfprocparam type="IN" dbvarname="@member_password"
value="#attributes.password#" cfsqltype="CF_SQL_VARCHAR">
<cfprocparam type="IN" dbvarname="@password_hint"
value="#attributes.pass_hint#" cfsqltype="CF_SQL_VARCHAR">
</cfstoredproc>
<!--- SQL Stored Procedure Code --->
CREATE PROCEDURE update_member_id_and_pass
(
@cfid nvarchar,
@member_id nvarchar (50),
@member_password nvarchar (10),
@password_hint nvarchar (50)
)
AS UPDATE member
SET member_id = @member_id,
member_password = @member_password,
password_hint = @password_hint
WHERE
(
cfid = @cfid
)
The syntax checker in the SQL SP builder says it's correct.
Bill
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
