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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
