Re: Remove a Field from a DB
This WebDNA talk-list message is from 2007
It keeps the original formatting.
numero = 69111
interpreted = N
texte = >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 Wilson | terry@terryfic.com | http://terryfic.com http://WhosComing.com - a simplified, affordable online reservation system http://TightJacket.com -- stylish protection for your laptop -------------------------------------------------------------------------- Attitude is the only difference between ordeal and adventure. ------------------------------------------------------------- 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:
>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 Wilson | terry@terryfic.com | http://terryfic.com http://WhosComing.com - a simplified, affordable online reservation system http://TightJacket.com -- stylish protection for your laptop -------------------------------------------------------------------------- Attitude is the only difference between ordeal and adventure. ------------------------------------------------------------- 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/
Terry Wilson
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:
quantity minimum problem (1997)
[WebDNA] Another strange WebDNA problem (2013)
Smith Micro - no competition (2000)
Country & Ship-to address & other fields ? (1997)
Shopping carts and reloading pages (1997)
info (1997)
Username for Admin Group (1997)
[CART] inside a [LOOP] (1997)
SKU (1997)
General WebCatalog Questions (1997)
Email address checker (2002)
Include (1998)
List Archives? (2005)
IP Shows Server (2003)
IE Cache Problems... (1999)
Add command creates new cart but I'm passing existing cart...? (2000)
Searchable list archive (1997)
Can WebCatalog.debug solve my problem? (2000)
OT: Just for a waste of time (2003)
[CART] (1997)