I think cfupdate attempts to determine the primary key on the table dynamically from whatever driver is being used to access that datasource. In the sql it's returning, notice that it says "where c_id = ? and c_phone = ?". This seems to indicate that it's trying to identify the record with both c_id and c_phone, so you want to check the Access db on your server and make sure it hasn't accidentally been given a multi-column primary key on that table.
hth Isaac Original Message ----------------------- OK I have a very simple cfupdate that works PERFECTLY on the test/development server here local and bombs with a SGL error on the actual server... Here is the cfupdate statement: ============================= <cfupdate datasource="contacts.mdb" tablename="contacts" formfields="c_id, c_first, c_last, c_company, c_phone, c_fax, c_address1, c_address2, c_city, c_state, c_zip, c_pext, c_email, c_website, initial_contact, initial_contactdate, followup_contact, followup_contactdate, notes, record_modifieddate"> ============================= c_id is the primary key defined in Access When I upload to the server, I get this when trying to update... (This seems to happen when I am updating the c_phone variable) Error Diagnostic Information SQL operation updated no rows. The SQL operation affected no rows.Either the Key value has changed or the row has been deleted. Data Source = "CONTACTS.MDB" SQL = "UPDATE contacts SET `c_address1` = ?, `c_address2` = NULL, `c_city` = ?, `c_company` = ?, `c_email` = ?, `c_fax` = NULL, `c_first` = ?, `c_last` = ?, `c_pext` = NULL, `c_state` = ?, `c_website` = NULL, `c_zip` = ?, `followup_contact` = ?, `followup_contactdate` = ?, `initial_contact` = ?, `initial_contactdate` = ?, `record_modifieddate` = ?, `notes` = ? WHERE `c_id` = ? AND `c_phone` = ?" Data Source = "CONTACTS.MDB" The error occurred while processing an element with a general identifier of (CFUPDATE), occupying document position (15:1) to (15:301). Date/Time: 07/31/03 14:36:10 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1) Remote Address: 24.54.70.54 HTTP Referrer: http://www.pbcllc.com/pbcintranet/telemarket/edit_contacts.cfm?c_id=1 ---------------------------------------------------------------------------- ---------- ANY Ideas WHY this works testing LOCALLY and not on the actual server. Its driving me NUTS. Thanks Jeff ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
