Results 1 to 4 of 4

Thread: help

  1. #1
    yls Guest

    Default help

    hi, i need to delete records from my database which dates have past the current date by a week. its not the sql that is bothering me but how to execute the function by itself?

  2. #2
    Join Date
    Dec 1969

    Default RE: help

    HI,<BR>You can create a page with the ODBC connection and the SQL statement and store it on your web server and the schedule the execution of that file by using AT .... at command prompt.<BR>For further clarrification contact<BR>vens<BR>

  3. #3
    Kevitt Guest

    Default RE: help

    Or, if you&#039re using SQL Server, create a job and schedule it to run a stored procedure.

  4. #4
    Join Date
    Dec 1969

    Default RE: help

    You can also write trigger which will run(delete) e.g. on insert, or on submit in some of your page and so on.

Posting Permissions

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