[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!
A list of user-submitted tips ...
[biotype]BioType is a behavioral biometrics WebDNA function based on ADGS research and development (from version 8...
WebDNA LibrariesA list of available libraries for WebDNA...
Download WebDNA ApplicationsWebDNA applications...
F.A.QA compilation of some user's questions...
Technical Change HistoryThis Technical Change History provides a reverse chronological list of WebDNA changes...
[session] is a new WebDNA feature that recognises a browser through its "fingerprint"...
Database format...
[flushcache]...
[closedatabase][CLOSEDATABASE db=FileName]...
ODBCUNIX: Setting up WebDNA - ODBC - Database Server...
[exclusivelock]Prevents other threads from simultaneously accessing a group of databases...