Re: WebDNA deletes major DB data big time

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 55776
interpreted = N
texte = Oh yes, believe me I'm quite versed in the usage of [url] and when they are needed and when they are not. My specific issue was that I had about 20 lines of code with a delete routine. It was working fine and the customer asked me to change something, and they gave me a deadline of December 23rd. Some of the code looked like this: eqMFRSKUdatarq=[sku]&eqSHOWSKUdatarq=[show_sku] and some of the code looked like this: eqJLRSKUdatarq=[sku]&eqSHOWSKUdatarq=[show_sku] Through a series of showif/hideif routines either the JLR or MFR code was being selected. Like I said, it worked until they wanted me to change it. Of course it was a stupid mistake that I made, but it was very difficult to find where the problem was, or more accurately when and why it was happening since it was a run time error and not bad code. The real issue here is that, right after the deadline was assigned I had a death in my family (the 4th death in 5 months I might add) and I was unable to take even 1 day off from work because the deadline was right before Christmas and the customer was closing for 2 weeks after that. So I accepted the blame for the problem and reminded the customer that they did not permit any leeway for my bereavement, especially having a loss so close to a big holiday. They've not complained since then, they've not brought up the topic, and were even a little embarrassed when I said my company would recover the data for them. But to continue with this thread, I was thinking that issues like this data loss could also be caused by code like this: delete db=database.db&eq[var]datarq=[value] and then the wrong var/value pair is passed. In my specific case, since I had the MFR/JLR routines backwards that part of the criteria was ignored and it simply deleted everything that matched the SHOWSKU=[show_sku]. So that's it. Do I blame my uncle for passing away 3 days before Christmas? Or do I blame my customer for saying "We're sorry but we still need this done before our winter break." If I recall I didn't get any sleep that week because of family issues, holiday issues and work issues. Matthew Perosi nj-singles.com ijo.com Gary Krockover wrote: > I would think that you would want that to be a "required" field as well; > eqskudataRQ=[url][sku][/url] > > Also, if a SKU is a number or otherwise does not possibly have any > characters other than A-Z/0-9, is the url'ing really required or is it > more of good coding habit? > > Oh, and in Matt's defense, I think that was just a quick example from > him.... > > :) > > GK > > > > >> Hi Matthew, >> I can relate with you in "learning the hard way". >> >> The above needs to have URLS in it: eqRSKUdata=[url][sku][/url] >> if there is any spaces or non-html characters. >> >> 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/ > > > > ------------------------------------------------------------- > 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/ > ------------------------------------------------------------- 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:

    
  1. Re: WebDNA deletes major DB data big time ( Donovan Brooke 2004)
  2. Re: WebDNA deletes major DB data big time ( John Hill 2004)
  3. Re: WebDNA deletes major DB data big time ( Matthew A Perosi 2004)
  4. Re: WebDNA deletes major DB data big time ( Donovan Brooke 2004)
  5. Re: WebDNA deletes major DB data big time ( Donovan Brooke 2004)
  6. Re: WebDNA deletes major DB data big time ( Donovan Brooke 2004)
  7. Re: WebDNA deletes major DB data big time ( Gary Krockover 2004)
  8. Re: WebDNA deletes major DB data big time ( Donovan Brooke 2004)
  9. Re: WebDNA deletes major DB data big time ( Donovan Brooke 2004)
  10. Re: WebDNA deletes major DB data big time ( Chris List Recipient 2004)
  11. Re: WebDNA deletes major DB data big time ( "Vincent Medina" 2004)
  12. Re: WebDNA deletes major DB data big time ( Dylan Wood 2004)
  13. Re: WebDNA deletes major DB data big time ( Palle Bo Nielsen 2004)
  14. Re: WebDNA deletes major DB data big time ( Palle Bo Nielsen 2004)
  15. Re: WebDNA deletes major DB data big time ( John Hill 2004)
  16. Re: WebDNA deletes major DB data big time ( Alex McCombie 2004)
  17. Re: WebDNA deletes major DB data big time ( Dylan Wood 2004)
  18. Re: WebDNA deletes major DB data big time ( Marc Kaiwi 2004)
  19. Re: WebDNA deletes major DB data big time ( Karl Schroll 2004)
  20. Re: WebDNA deletes major DB data big time ( Clint Davis 2004)
  21. Re: WebDNA deletes major DB data big time ( Marc Kaiwi 2004)
  22. Re: WebDNA deletes major DB data big time ( "Brian Boegershausen" 2004)
  23. Re: WebDNA deletes major DB data big time ( Matthew A Perosi 2004)
  24. Re: WebDNA deletes major DB data big time ( Dylan Wood 2004)
  25. Re: WebDNA deletes major DB data big time ( Palle Bo Nielsen 2004)
  26. Re: WebDNA deletes major DB data big time ( Clint Davis 2004)
  27. Re: WebDNA deletes major DB data big time ( "Morten Madsen" 2004)
  28. WebDNA deletes major DB data big time ( Palle Bo Nielsen 2004)
Oh yes, believe me I'm quite versed in the usage of [url] and when they are needed and when they are not. My specific issue was that I had about 20 lines of code with a delete routine. It was working fine and the customer asked me to change something, and they gave me a deadline of December 23rd. Some of the code looked like this: eqMFRSKUdatarq=[sku]&eqSHOWSKUdatarq=[show_sku] and some of the code looked like this: eqJLRSKUdatarq=[sku]&eqSHOWSKUdatarq=[show_sku] Through a series of showif/hideif routines either the JLR or MFR code was being selected. Like I said, it worked until they wanted me to change it. Of course it was a stupid mistake that I made, but it was very difficult to find where the problem was, or more accurately when and why it was happening since it was a run time error and not bad code. The real issue here is that, right after the deadline was assigned I had a death in my family (the 4th death in 5 months I might add) and I was unable to take even 1 day off from work because the deadline was right before Christmas and the customer was closing for 2 weeks after that. So I accepted the blame for the problem and reminded the customer that they did not permit any leeway for my bereavement, especially having a loss so close to a big holiday. They've not complained since then, they've not brought up the topic, and were even a little embarrassed when I said my company would recover the data for them. But to continue with this thread, I was thinking that issues like this data loss could also be caused by code like this: delete db=database.db&eq[var]datarq=[value] and then the wrong var/value pair is passed. In my specific case, since I had the MFR/JLR routines backwards that part of the criteria was ignored and it simply deleted everything that matched the SHOWSKU=[show_sku]. So that's it. Do I blame my uncle for passing away 3 days before Christmas? Or do I blame my customer for saying "We're sorry but we still need this done before our winter break." If I recall I didn't get any sleep that week because of family issues, holiday issues and work issues. Matthew Perosi nj-singles.com ijo.com Gary Krockover wrote: > I would think that you would want that to be a "required" field as well; > eqskudataRQ=[url][sku][/url] > > Also, if a SKU is a number or otherwise does not possibly have any > characters other than A-Z/0-9, is the url'ing really required or is it > more of good coding habit? > > Oh, and in Matt's defense, I think that was just a quick example from > him.... > > :) > > GK > > > > >> Hi Matthew, >> I can relate with you in "learning the hard way". >> >> The above needs to have URLS in it: eqRSKUdata=[url][sku][/url] >> if there is any spaces or non-html characters. >> >> 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/ > > > > ------------------------------------------------------------- > 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/ > ------------------------------------------------------------- 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/ Matthew A Perosi

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:

Initiating NewCart (1997) WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997) emailer (1997) Customer - again (1998) get vs post - Back to Basics. (2001) Bug Report, maybe (1997) Latest Version of WebDNA store (2002) psst (1997) Show shoppingcart after remove last item (1997) Adding Shipping Costs based on percent of subtotal (1997) Performance Issue (2000) Path of Events (1999) [isfile] ? (1997) Full text search (1999) WC2b15 File Corruption (1997) Frames and WebCat (1997) email error (2003) combining strings (1997) WCf2 and nested tags (1997) syntax question, not in online refernce (1997)