Usually I write SQL for this kind of stuff but figured that the cfupdate would have been quicker. Little did I know....
----- Original Message ----- From: "S. Isaac Dealey" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, August 01, 2003 3:08 AM Subject: Re: CFUPDATE problem.. HELP!!! > 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 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
