[addfields db=...]...WebDNA...[/addfields]
numero = 195[closedatabase db=addfields_test.db][writefile file=addfields_test.db]IDNAME1 Scott2 Rusty3 David4 Daniel5 Dustin[/writefile][search db=addfields_test.db&neIDdata=[blank]&rank=off][founditems][ID] - [NAME][/founditems][/search]Results:1 - Scott2 - Rusty3 - David4 - Daniel5 - DustinNow, lets use the [addfields] context to add EMAIL and PHONE fields to the 'addfields_test.db' database, initializing the new field value with some arbitrary data. We will again perform a simple search on the same database to confirm that the new fields, and field data, have been added. We use the following WebDNA code:
[addfields db=addfields_test.db]EMAIL=us@com&PHONE=12-1235[/addfields][search db=addfields_test.db&neIDdata=[blank]&rank=off][founditems][ID] - [NAME] - [EMAIL] - [PHONE][/founditems][/search]Results:1 - Scott - us@com - 12-12352 - Rusty - us@com - 12-12353 - David - us@com - 12-12354 - Daniel - us@com - 12-12355 - Dustin - us@com - 12-1235
the [addfields] context will not add fieldnames that already exist in the target database.
[addfields] will not add more than 4 fields at one time; in the following example, the "fifth" field will not be added
[addfields db=test.db]address=[blank]&website=[blank]&brochure=[blank]&Home=[blank]&fifth=[blank][/addfields]
[deletefields] feature has been added in version 8.6 [deletefields db=test.db&fieldnames=column1,column4]
The [addfields] context adds new fields to an existing WebDNA database.[closedatabase db=addfields_test.db]
[writefile file=addfields_test.db]IDNAME
1 Scott
2 Rusty
3 David
4 Daniel
5 Dustin
[/writefile]
[search db=addfields_test.db&neIDdata=[blank]&rank=off]
[founditems]
[ID] - [NAME]
[/founditems]
[/search]
[addfields db=addfields_test.db]EMAIL=us@com&PHONE=12-1235[/addfields]
[search db=addfields_test.db&neIDdata=[blank]&rank=off]
[founditems]
[ID] - [NAME] - [EMAIL] - [PHONE]
[/founditems]
[/search]
the [addfields] context will not add fieldnames that already exist in the target database.
[addfields] will not add more than 4 fields at one time; in the following example, the "fifth" field will not be added
[addfields db=test.db]address=[blank]&website=[blank]&brochure=[blank]&Home=[blank]&fifth=[blank][/addfields]
[deletefields] feature has been added in version 8.6
[deletefields db=test.db&fieldnames=column1,column4]
DOWNLOAD WEBDNA NOW!
This Technical Change History provides a reverse chronological list of WebDNA changes...
[biotype]BioType is a behavioral biometrics WebDNA function based on ADGS research and development (from version 8...
Download WebDNA ApplicationsWebDNA applications...
WebDNA LibrariesA list of available libraries for WebDNA...
F.A.QA compilation of some user's questions...
WebDNA ModulesA list of the currently available modules...
WebDNA provides a few options for password protecting your pages...
[clearlineitems]Remove all line items from the specified shopping cart...
[flushcache]...
[lastautonumber]displays the last auto-generated number...
[grep]Replaces text based on a regular expression...
[copyfile]Copy a file with the content you want on your webspace...