[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...
AWS Raw WebDNA LAMP-Plus WebServerAmazon Web Services (AWS) README for Machine Image ID...
WebDNA reference...
F.A.QA compilation of some user's questions...
WebDNA ModulesA list of the currently available modules...
Download WebDNA ApplicationsWebDNA applications...
[CLOSEDATABASE db=FileName]...
[listchars]Breaks a string of text into separate characters...
[httpmethod]Displays the method...
[wait][wait] just does what it says...
[spawn]Creates a new thread to execute WebDNA simultaneously with the current template...
[!]Hides text...