coldfusion database

Hey Everyone,

well i ended up effort myself in a bind. I someways ended up effort the aforementioned achievement entered into the plateau binary times. For warning i have

555 dog
555 dog

anyway when i essay to withdraw digit achievement or both at the aforementioned instance i intend the mass nonachievement the bed value(s) updated or deleted either do not attain the bed unequalled or they edit binary rows(2 rows). i proven to modify modify digit achievement to be assorted an intend the aforementioned error.

is there anyway to withdraw these records or do i hit to withdraw the full plateau an re-start the plateau from scratch?

Thank you,
Rach

Share and Enjoy:
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google
  • LinkedIn
  • Live
  • MySpace
  • Print this article!
  • Reddit
  • StumbleUpon
  • Technorati
  • Wykop
  • YahooMyWeb
  • E-mail this story to a friend!

One Response to “Coldfusion database deleting the same record?”

  • colanth says:

    Brute force solution.

    Duplicate an empty table.

    Start at the beginning of the existing table (sort or not, your choice). Read the current record. Select for the current record in the new table. If it doesn’t exist, insert. Wash, rinse, repeat.

    The new table won’t have dupes.

Leave a Reply

Sponsored Links
My Products