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 doessomething 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][ListFieldsdb=[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 | Typhoon619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
Associated Messages, from the most recent to the oldest:
>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 doessomething 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][ListFieldsdb=[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 | Typhoon619/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:
RSS Feeds; basic info (2005)
showif with math? (2000)
PIXO (1997)
WebCat2: Formulas.db question (1997)
WebDNA on Intel Mac? (2006)
Best way to download a db (2003)
[WebDNA] WebDNA glitch, no response required ... (2009)
Interfacing WebMerchant to www.fedex.com (1997)
carriage returns in data (1997)
Webcat no longer supported? (2006)
Off Topic: Frames Killer? (1998)
Email within tmpl ? (1997)
More Applescript (1997)
WebCat2b12plugin - [search] is broken ... not! (1997)
Tea Room trouble (1997)
Getting the domain of every request ... (2003)
Re:Need help... (1997)
Help!!!! Purchases not going through! (1997)
Weird problems with [SHOWIF]s (1997)
Great product and great job ! (1997)