College Kid wrote:
Please give us as much information as you can about the error.
The error came when after the deletion of a record, I tried to capture the date of the record that was just deleted and pass that date on to the original page. The day was not captured and the error was thrown saying that the day did not exist. I ended up doing a cfcookie and capturing the date in a different way and holding that cookie date as a value that is being passed to the original page. The code that I used that help to solve the issue is below. This may be Crude work-around however it works for now. Could there be a easier quicker way to work this. Although this works just fine it takes about 10 to 11 seconds for the page to pass through back to the original page. Here is my code below.
<cfif IsDefined("URL.meeid") AND #URL.meeid# NEQ "">
DELETE FROM meeting
WHERE meeid=<cfqueryparam value="#URL.meeid#" cfsqltype="cf_sql_numeric">
<!--- <cflocation url="insert_attendance1_clone.cfm">--->
<cfform action="insert_attendance1_clone.cfm" method="post" name="form">
<cfinput name="squweekbegin" type="hidden" value="#cookie.constantdate#" />