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
@user1 varchar (2),
user@mac varchar (2)
AS
BEGIN
Delete from tbl_error
Where users IN ('@user1','@user2')
END