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:

PIXO support (1997) adding up in a db (1997) WebCat2b15MacPlugIn - [authenticate] not [protect] (1997) A little help on e-mail (HELP!!! :-) ) (1998) [text] doesn't change [formvariables] (1999) Mozilla/4. and Browser Info.txt (1997) New Installation (1998) Related database (2000) Ends With (2003) Generating unique SKU from [cart] (1997) E-Mailer (WebCatb15acgiMac) (1997) multiple search commands (1997) Out of the woodwork (2007) no template caching (1997) The IBC root beer has arrived! (1997) [WebDNA] Two file tags don't work as expected (2009) Permissions (2000) Email Formatting and Encryption (1998) Email within tmpl ? (1997) Satisfy Me ! was: Why can't support be satisfying to (2000)