Re: WebDNA deletes major DB data big time
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 55800
interpreted = N
texte = John Hill wrote:> [snip] The other necessarychange to database functions to handle this was to use a global value to assign the next record ID, not just 1 plus the highest number in the database. If you constantly delete the last record then you end up reusing the same database ID over and over in the latter scenario. Thus restoring old data becomes impossible.:-) funny that you say this. I have used snippets of your DBEdit codein the past and just ran into a situation where I was relating data to the ID field.Well, when that record ID changes (gets deleted and then gets re-assigned)you now have a situation where Joe Schmoe is now John Doe!oops ;-)Some additional code helped fixed that scenerio. So I think in general, if there is anyplan of relation, it is a good practice to use a global ID!Still learning,Donovan =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE Eucalyptus Design <-Web Development (specializing in eCommerce), -> <-Graphic Design, and Pre-Press Consultation -> ADDRESS:> Donovan Brooke DBA Eucalyptus Design N2862 Summerville Park Rd. Lodi, WI 53555 PH:> 1.608.592.3567 Web:> http://www.euca.us =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list
.To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
John Hill wrote:> [snip] The other necessarychange to database functions to handle this was to use a global value to assign the next record ID, not just 1 plus the highest number in the database. If you constantly delete the last record then you end up reusing the same database ID over and over in the latter scenario. Thus restoring old data becomes impossible.:-) funny that you say this. I have used snippets of your DBEdit codein the past and just ran into a situation where I was relating data to the ID field.Well, when that record ID changes (gets deleted and then gets re-assigned)you now have a situation where Joe Schmoe is now John Doe!oops ;-)Some additional code helped fixed that scenerio. So I think in general, if there is anyplan of relation, it is a good practice to use a global ID!Still learning,Donovan =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE Eucalyptus Design <-Web Development (specializing in eCommerce), -> <-Graphic Design, and Pre-Press Consultation -> ADDRESS:> Donovan Brooke DBA Eucalyptus Design N2862 Summerville Park Rd. Lodi, WI 53555 PH:> 1.608.592.3567 Web:> http://www.euca.us =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Donovan Brooke
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
SmithMicro FTP problems (2002)
Help! WebCat2 bug (1997)
about this server and links to who (1997)
Shipping costs again (1998)
WebCat2b12plugin - [search] is broken ... not! (1997)
vs (1997)
test (2001)
SEARCHES (2000)
How to verify email address (1997)
webdna email center (2003)
Help name our technology! (1997)
Free pack for the New UPS ratings and services tool (2000)
dos bug? (1999)
Pricing (1998)
[OT] Server check please (2006)
Robert Minor duplicate mail (1997)
Getting total number of items ordered (1997)
[price] via a search (1998)
Bug? (1997)
Webstar 1.3.1 PPC (1997)