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:

sorting dates (1999) unable to launch acgi in WebCat (1997) Using "/" for path to virtual host root ? (2003) [OT] KeepItUp for Windows (2003) Too Much Rootbeer Free Offer (1997) WebCat for mass emailings (1997) [WebDNA] [OT] File structure for purchased downloads (2010) [OT] - Block Traffic to DevBox (2003) Running 2 two WebCatalog.acgi's (1996) Suffix Mapping (1997) Email encryption (1998) Updating fields from different platforms (1998) File upload woes (1998) Signal Raised (1997) Fun with Dates - finally resolved but.... (1997) [input] [/input] (1997) Rhapsody? (1997) Username for Admin Group (1997) WebCat2: Items xx to xx shown, etc. (1997) Searching multiple Databases (1997)