ahh... yea, primary key is just one kind of index -- apparently cfupdate can be easily confused by indexing in Access... As a rule of thumb, however, I would avoid cfupdate and cfinsert all-together. Write yourself a custom tag that does roughly the same thing and it'll give you better results.
> 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/uns > ubscribe.cfm?user=633.558.4 s. isaac dealey 972-490-6624 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi team macromedia volunteer http://www.macromedia.com/go/team certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
