It helped alot.. Thanks. Actually if your interested, it wasn't the primary key, it was indexing on both C_ID and c_phone. I deleted the indexing on c_phone and voi la, problem gone....
----- Original Message ----- From: "s. isaac dealey" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, July 31, 2003 3:18 PM Subject: RE: CFUPDATE problem.. HELP!!! > 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
