Don't want to over-simplify, but can you confirm there's no conditional statement around the WHERE clause, particularly if this is batched, a variable may be not passed in which would resolve the query to be simply "UPDATE tblMeetings SET Active = no".... possible?
----- Original Message ----- From: "Susan Murray-Smith" <[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
