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:
GuestBook example (1997)
FORMS: Returning a specific page (1997)
How do I enter a carriage return for my StartAfter valuein (2002)
log files (1998)
Type 11 errors setting up WebCAt 2 (1997)
[SHOWIF AND/OR] (1997)
EMailer - WebSTAR V - OSX - WebDNA (2003)
Quick poll (2003)
Thanks Grant (1997)
[authenticate] (2002)
Email Set-Up? (1997)
Form/HTML Help (2000)
Multiple Pulldowns/Gary (1997)
[search] within [listfiles]? (2003)
[isfile] ? (1997)
WebCat2b12--[searchstring] bug (1997)
Forwarding Orders Via Email (1998)
Anyone get webdna to run on apache 2.x on osx? (2006)
Who's going to MacWorld? (1999)
customizing the color of user's pages (1997)