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.> > TerryTerry, I was trying to politely hint that if one was to replace field values withnothing.. 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 inthe fieldname line... (Not sure if the WebDNA engine would auto truncate thethe 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:
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.> > TerryTerry, I was trying to politely hint that if one was to replace field values withnothing.. 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 inthe fieldname line... (Not sure if the WebDNA engine would auto truncate thethe 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)