> Works for me! Oh, Ted! You say that to *all* the girls. <g>
All I can tell you is that: 1. I was using a simple GUI SQL tool. Just like the old command window, it keeps a history of all of the SQL statements I ran. It also puts a timestamp on the query history. 2. The timestamp on query I ran (actual follows) and the timestamp field in the database are identical. 3. No other SQL statement used the "field_F" that was the victim of the "14" disease. The field that got the 14 was "fs_id" The table structure: =================================================== CREATE TABLE `orders` ( `order_id` int(11) NOT NULL auto_increment, `order_when` datetime default NULL COMMENT 'Order placed', `org_id` int(11) default NULL, `order_type` int(11) default '1' COMMENT 'Order, Pending Order, Wish List, Training Plan', `place_bill_id` int(11) default NULL, `person_bill_id` int(11) default NULL, `org_bill_id` int(11) NOT NULL default '0', `person_coord_id` int(11) default NULL COMMENT 'Coordinator Person ID', `person_placedorder_id` int(11) default NULL, `place_id` int(11) default NULL, `order_means` tinyint(4) default NULL, `order_status` tinyint(4) default NULL COMMENT 'Order Status: 0-Unconfirmed 1-Pending CC, 2-Pending Super', `po_number` varchar(20) default NULL COMMENT 'PO Number', `invoiced` tinyint(1) default '0' COMMENT 'Invoice Sent?', `invoice_after` date default NULL COMMENT 'invoice after this date', `total_amount` decimal(11,2) default NULL COMMENT 'Order total amount', `current_balance` decimal(11,2) default '0.00', `commission_total_amount` decimal(9,2) default NULL COMMENT 'Amount of Commission on this order', `order_notes` text COMMENT 'Order Notes', `comm_id` int(11) default NULL, `fs_id` int(11) default NULL COMMENT 'fee structure ID', `link_order_id` int(11) default NULL COMMENT 'link to another order', `z_up_date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `z_up_by` varchar(80) default NULL, PRIMARY KEY (`order_id`), KEY `order_type` (`order_type`), KEY `order_status` (`order_status`), KEY `order_when` (`order_when`), KEY `org_id` (`org_id`) ) ENGINE=MyISAM AUTO_INCREMENT=26880 DEFAULT CHARSET=latin1 ================================================================== The query: ===================================== update orders set person_bill_id = person_placedorder_id, place_bill_id = place_id where person_bill_id = 0 ===================================== About as simple as it could be. Told you it was weird. Ken _______________________________________________ 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 Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** 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.
