Re: Remove a Field from a DB

This WebDNA talk-list message is from

2007


It keeps the original formatting.
numero = 69112
interpreted = N
texte = Terry Wilson wrote: >> Terry Wilson wrote: >>> I would just search the DB for the deprecated field, find all, >>> andreplace with no value. Then open the DB in a text editor like >>> BBEdit anddelete the field name, save, and reload the DB. >>> If opening the DB in a text editor is an issue, just fix your code >>> sothe deprecated field is no longer used. It won't hurt anything. I >>> oftenhave unused fields in my DBs anyway (for future expansion or >>> becuase itis no longer used). >>> Terry >> >> >> Make a back up if you use Terry's method. ;-) >> >> Donovan > > Good idea -- if your field names are abstract, make sure to specify the > correct field! Otherwise, [replace > db=stuff&etc]deprecatedfield=[/replace] is pretty straightforward. > > I would do a search first and look at the founditems before doing > something big. If all is okay, then edit the search into a replace. > > Terry Terry, I was trying to politely hint that if one was to replace field values with nothing.. then delete the field name, the database would then be munged. "Munged" <-- Donovan's favorite descriptive for messed up databases. Your idear may/may not work if the fieldname column was the last in the fieldname line... (Not sure if the WebDNA engine would auto truncate the the last column) btw, how did that Apple thing work out for you? 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 EUCA Design Center <- Web Development (specializing in eCommerce),-> <- Desktop Publishing, Print Consulting, Labels -> <-Glass Products, off-hand Classes/studio rental-> PH:>(608) 835-2476 TALK:>http://artglass-forum.com WEB:> http://www.euca.us & http://www.egg.bz =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:

    
  1. Re: Remove a Field from a DB ( Terry Wilson 2007)
  2. Re: Remove a Field from a DB ( Donovan Brooke 2007)
  3. Re: Remove a Field from a DB ( Terry Wilson 2007)
  4. Re: Remove a Field from a DB ( Donovan Brooke 2007)
  5. Re: Remove a Field from a DB ( Terry Wilson 2007)
  6. Re: Remove a Field from a DB ( Steve Craig 2007)
  7. Re: Remove a Field from a DB ( Matthew Bohne 2007)
  8. Re: Remove a Field from a DB ( Larry Hewitt 2007)
  9. Re: Remove a Field from a DB ( Donovan Brooke 2007)
  10. Re: Remove a Field from a DB ( Gary Krockover 2007)
  11. Re: Remove a Field from a DB ( Palle Bo Nielsen 2007)
  12. Re: Remove a Field from a DB ( Palle Bo Nielsen 2007)
  13. Re: Remove a Field from a DB ( Palle Bo Nielsen 2007)
  14. Re: Remove a Field from a DB ( Gary Krockover 2007)
  15. Re: Remove a Field from a DB ( Matthew Bohne 2007)
  16. Re: Remove a Field from a DB ( Donovan Brooke 2007)
  17. Remove a Field from a DB ( Palle Bo Nielsen 2007)
Terry Wilson wrote: >> Terry Wilson wrote: >>> I would just search the DB for the deprecated field, find all, >>> andreplace with no value. Then open the DB in a text editor like >>> BBEdit anddelete the field name, save, and reload the DB. >>> If opening the DB in a text editor is an issue, just fix your code >>> sothe deprecated field is no longer used. It won't hurt anything. I >>> oftenhave unused fields in my DBs anyway (for future expansion or >>> becuase itis no longer used). >>> Terry >> >> >> Make a back up if you use Terry's method. ;-) >> >> Donovan > > Good idea -- if your field names are abstract, make sure to specify the > correct field! Otherwise, [replace > db=stuff&etc]deprecatedfield=[/replace] is pretty straightforward. > > I would do a search first and look at the founditems before doing > something big. If all is okay, then edit the search into a replace. > > Terry Terry, I was trying to politely hint that if one was to replace field values with nothing.. then delete the field name, the database would then be munged. "Munged" <-- Donovan's favorite descriptive for messed up databases. Your idear may/may not work if the fieldname column was the last in the fieldname line... (Not sure if the WebDNA engine would auto truncate the the last column) btw, how did that Apple thing work out for you? 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 EUCA Design Center <- Web Development (specializing in eCommerce),-> <- Desktop Publishing, Print Consulting, Labels -> <-Glass Products, off-hand Classes/studio rental-> PH:>(608) 835-2476 TALK:>http://artglass-forum.com WEB:> http://www.euca.us & http://www.egg.bz =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:

Practice runs ? (1997) WebCat2 as a chat server? (1997) 404s - Apache vs. WebDNA (2008) math and european notation (1998) [returnraw] and form variables (1998) [slightly OT] WebCat vs. WebObjects ;) (2000) [WebDNA] Poll: Cloud hosting (2016) RE: Automatic Forwarding using WebCat (1997) SiteGaurd file Cache vs webcatalog cache (1997) RE: Upload (1998) Sort Order on a page search (1997) WebCat for Unix?? (1997) WebCat2 - [include] tags (1997) WebCat2 several catalogs? (1997) 5.0 Preview Promotion Extension (2003) Web Catalog 2 demo (1997) Format question WC Mac f3 (1997) Help formatting search results w/ table (1997) Grouping Fields in Context (1999) PCS Frames (1997)