might be a stupid question, but could it be a search engine that's trawling the site and just going to the page
www.mysite.com/deletestaff.cfm?id=20 ??? Maybe add this file to the robot.txt file so it is not trawled, and make it a form rather than a url variable. http://www.robotstxt.org/wc/norobots.html ----- Original Message ----- From: <[EMAIL PROTECTED]> To: "CFAussie Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, February 26, 2004 12:38 PM Subject: [cfaussie] RE: tracking down unusual record deletions > The query statements are: > > <CFQUERY DATASOURCE="Libmag"> > UPDATE tblMeetings > SET Active = no > WHERE tblMeetings.Meet_ID=#URL.id# > </CFQUERY> > > The URL.id comes from the previous page = its a basic display > a list and select a single item to edit or delete. Thats why its hard > to think why 20+ records would be deleted this way. > > I am trying to track down the server logs to see if there is > any file activity that will point me in the right direction. Thanks > for tips! > > regards > susan > > > At 12:23 PM 26/02/2004, you wrote: > >How exactly is the delete occurring? Did you change a cfquery DELETE to a > >cfquery UPDATE? If so then clearly this query is being run, right? What does > >the WHERE clause look like? > > > > > Its possible from within the web pages for staff to delete records from > > > these > > > 2 tables, so I changed this function from being a real delete to marking > > > the records inactive. When I did this, the problem changed from the > > > records being deleted to being marked inactive. > > > > > > > >--- > >You are currently subscribed to cfaussie as: > >[EMAIL PROTECTED] > >To unsubscribe send a blank email to [EMAIL PROTECTED] > > > >MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia > >http://www.mxdu.com/ + 24-25 February, 2004 > > Susan Murray-Smith, Web Services Coordinator > University of Sydney Library F03 > University of Sydney NSW 2006 AUSTRALIA > Ph: (612) 9351 3804 > Fax: (612) 9351 2890 > Email: [EMAIL PROTECTED] > > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to [EMAIL PROTECTED] > > MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia > http://www.mxdu.com/ + 24-25 February, 2004 > --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
