Delete Recordsets Automatically

Results 1 to 2 of 2

Thread: Delete Recordsets Automatically

  1. #1
    Join Date
    Dec 1969

    Default Delete Recordsets Automatically

    I have a .mdb file that I want to DELETE the fields on a specific date (which is one of the recordset) automatically. The script below is executed by hitting the browser. Is there a way in ASP to delete recordset on a specific date automatically without having to hit the page?<BR><BR>set conn = server.createobject("adodb.connection")<BR>conn.op en = "DBname"<BR>deleteDate = Date()<BR>strSQL = "DELETE * FROM Table WHERE expireDate &#062;= #" & deleteDate & "#"<BR>conn.execute(strSQL)<BR><BR><BR>By the way, I don&#039;t want to rely on cookie.expires. I want the recordsets to permanently disappear on a specified date. Thanks.<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Delete Recordsets Automatically

    if it is SQL Server then <BR>yes <BR>use SQL Server Agent

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts