Question
My cfstoredproc is there but nothing happen on the db
I created a temp. error log, what I did, I wrote a detele
statement to clear up all the old error records in the begining and
after that, I'm inserting new error(s) if they become available.
I use stored procedure and the reason for doing this is just to practise with <cfstoredproc tag.
The funny thing is, I can see the stored proc was run from the debug view but the record did not get deleted? Have I done something wrong with the code? no error on the screen.
I use CF8, DB Sybase & windows
<!--- start with a clean up older error records --->
<cfstoredproc procedure="sp_deletedOldError" datasource="#mydb#">
<cfprocparam cfsqltype="CF_SQL_VARCHAR" dbvarname="@user1" value="#Trim(session.user)#">
<cfprocparam cfsqltype="CF_SQL_VARCHAR" dbvarname="@user2" value="">
</cfstoredproc>
Here is my simple procedures:
CREATE PROCEDURE dbo.sp_deletedOldError
@7329667 varchar (2),
@user@mac varchar (2)
AS
BEGIN
Delete from tbl_error
Where users IN ('@user1','@user2')
END
I use stored procedure and the reason for doing this is just to practise with <cfstoredproc tag.
The funny thing is, I can see the stored proc was run from the debug view but the record did not get deleted? Have I done something wrong with the code? no error on the screen.
I use CF8, DB Sybase & windows
<!--- start with a clean up older error records --->
<cfstoredproc procedure="sp_deletedOldError" datasource="#mydb#">
<cfprocparam cfsqltype="CF_SQL_VARCHAR" dbvarname="@user1" value="#Trim(session.user)#">
<cfprocparam cfsqltype="CF_SQL_VARCHAR" dbvarname="@user2" value="">
</cfstoredproc>
Here is my simple procedures:
CREATE PROCEDURE dbo.sp_deletedOldError
@7329667 varchar (2),
@user@mac varchar (2)
AS
BEGIN
Delete from tbl_error
Where users IN ('@user1','@user2')
END
AdChoices