<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
