Been working on some PHP code and had this UPDATE command: update parts set specialorderitem = false, currentcount = 1, date = now(), units = 1, tikit_built = true where details.partid = " . $partID;
See the error? I didn't until it was too late... (should be parts.partid = " . $partID) Yep - I set every single row in my Parts table to the values listed above... You'd almost think that a SQL engine would discard all records, rather than include all records in an instance like this.. but nope... I *do* have a Testing environment to play in, just forgot to toggle the mode my app is running in... Thank the Maker for my hourly backups.... -- Matthew S. Jarvis IT Manager Bike Friday - "Performance that Packs." www.bikefriday.com 541/687-0487 x140 [EMAIL PROTECTED] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
