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:

RE: Can a database get stomped by simultaneous access? (1997) Quantity (1998) WebCat on Linux (2000) [append] vs. [appendfile] delta + question? (1997) PCS Frames-Default page is solution! (1997) Formating found categories (1997) Webcat causing crashes left and right! (1997) Trouble with formula.db (1997) WebCatalog 2.0 b 15 mac (1997) MacOS alias identification? (1998) Root Folder problems cont. (1998) RE: TeaRoom (1997) GD Scumbucket Spammer (2004) Calculating multiple shipping... (1997) 'does not contain' operator needed ... (1997) Meet your competition (2000) won't serve .tpl -index.tpl gone, made test.tpl (2000) [WriteFile] problems (1997) RE: Upload (1998) Sorting Dates (2000)