Deleting multiple records via checkboxes

This is the first of 2 tutorials on batch record deleting. The first tutorial requires a minimum experience with UD's forms and live data. a short manual coding is required in the delete page.

The second tutorial shows you how to delete, along with the records, the files on the server the records point to. Typically this is the case with image files, that have been uploaded to the server and whose path is stored in a database table.

If you delete just the records, the image files will be left on the server, using up precious space.

Comments

getting error, please help

September 18, 2002 by John Blakeslee
  • Error Type:
    Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
    [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
    /control_panel/delete.asp, line 37

     

  • RE: getting error, please help

    September 18, 2002 by Piero Mattirolo

    This is a common error that means that the SQL interpreter has not found enough parameters to build the recordset query. This is generally caused by naming inconsistency: you should make sure that the string parameter name ("checkbox" by default) is the same as the name you are requesting on the delete page and that the field you specify in the SQL string exists in your database table,

    You must me logged in to write a comment.