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:
Help!!!! (1997)
Group search doesn't work. (1997)
Size limit for tmpl editor ? (1997)
[WebDNA] Error: Sorry WebDNA server not running. (2018)
Help name our technology! (1997)
[WebDNA] Gratz with 6.1b1 (2008)
$purchase WITHOUT creditcar (1997)
WCS Newbie question (1997)
passing search criteria (1997)
WebCatalog2 Feature Feedback (1996)
WebCatalog stalls (1998)
WebCatalog Affiliates Program Announced -- Share the (2000)
Frames and WebCat (1997)
re: [addlineitem] working almost (1997)
WebCatalog can't find database (1997)
WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997)
[WebDNA] To Commitdatabase or Not to Commitdatabase (2012)
formula.db problem (1999)
[OT] SQL and Crackers (2000)
PIXO support (1997)