Re: Feature Request: DB Field manipulation

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 17609
interpreted = N
texte = >I've seen enough people ask how to add a field to a database that I thought >I'd propose this: > >[ADDFIELD db=SOME.DB&field=FIELDNAME] >This would add a new field (FIELDNAME) to a databse (SOME.DB). >...[COPYFIELD]Added to the list...thanks!In the meantime, I think a WebDNA template could be made that does something similar. Something like the following (untested)[include file=FieldAdder.inc&db=SOME.DB&fld=SKU&field=ZipPlusFour]-- FieldAdder.inc -- [WriteFile file=newdatabase.db][ListFields db=[db]][fieldname] [/listfields][field] [search db=[db]&ne[fld]data=[blank]][FoundItems][ListFields db=[db]][interpret][[fieldname]][/interpret] [/listfields] [/FoundItems][/Search][/WriteFile]Grant Hulbert, V.P. Engineering | ==== eCommerce for the Rest of Us ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Feature Request: DB Field manipulation (Grant Hulbert 1998)
  2. Feature Request: DB Field manipulation (Michael Winston 1998)
>I've seen enough people ask how to add a field to a database that I thought >I'd propose this: > >[ADDFIELD db=SOME.DB&field=FIELDNAME] >This would add a new field (FIELDNAME) to a databse (SOME.DB). >...[COPYFIELD]Added to the list...thanks!In the meantime, I think a WebDNA template could be made that does something similar. Something like the following (untested)[include file=FieldAdder.inc&db=SOME.DB&fld=SKU&field=ZipPlusFour]-- FieldAdder.inc -- [WriteFile file=newdatabase.db][ListFields db=[db]][fieldname] [/listfields][field] [search db=[db]&ne[fld]data=[blank]][founditems][ListFields db=[db]][interpret][[fieldname]][/interpret] [/listfields] [/FoundItems][/Search][/WriteFile]Grant Hulbert, V.P. Engineering | ==== eCommerce for the Rest of Us ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ Grant Hulbert

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:

Supressing Error Messages (1998) WebCatalog/Mac 2.1b2 - PIXO (1997) REPOST: How do _you_ back up your db? (2000) Custom buttons using site builder (2005) Help!!!! Purchases not going through! (1997) WC 4.0 on OSX 10.0.4 problems (2001) Nested tags count question (1997) SHOWIF/HIDEIF empty fields (2005) Various Problems (1997) syntax question, not in online refernce (1997) Need relative path explanation (1997) Re(6): Small Bug: ErrorLog.txt/[FORMVARIABLES]/[ORDERFILE] (1998) Webcat/Webmerchant (1998) Requiring that certain fields be completed (1997) Showif with multiple options (2002) ErrorLog.txt (1999) WebCat editing, SiteGuard & SiteEdit (1997) Shipping Help! (1998) RE: Auto conversion of URLs? (1998) syntax question, not in online refernce (1997)