Technical References - [append]

[append db=base.db]values[/append] appends a new record with the specified field values to the end of a database.

numero = 196
interpreted = N
texte = Optional Context Parameters - autonumber instructs WebDNA to automatically generate the 'next highest number' value for the given fieldname. To add new records to a database, put an append context into a template. Whenever WebDNA encounters an append context, it immediately adds a new record to the end of the specified database given the named field values inside the append context. Example:
[append db=base.db][!][/!]name=Grant&[!][/!]address=1492 Street&[!][/!]zip=9000&[!][/!]date=[date][!][/!][/append]
The database "base.db" is opened, and a new record is added to the end. The field name "name" is set to "Grant," the field name "address" is set to "1492 Street," the field name "zip" is set to "9000," and the field name "date" is set to the current date. Notice that any WebDNA [xxx] tags inside the context are first substituted for their real values before being written to the database. The name of the database itself may also be an [xxx] tag, as in "[append [formvariable]]." Any field names not existing in the database are ignored, and any fields you do not specify are left blank in the new record. Certain letters are illegal, such as or , so they are converted to and before being added to the database. Some computers use the two-character sequence to indicate a single end of line, which is automatically converted to a single character before being added to the database. You may specify an absolute or partial path to the database file, as in "/WebCatalog/Folder/base.db" or "../base.db" (relative paths start in the same folder as the template, just like URLs, so "../" will look "up" one folder level from the template, and "/" will start at the web server's root).

You can specifiy a WebDNA [table], in place of a db file, in the Append context. For example: [append table=TableName]values[/append]

Some database filenames are reserved. You may not create your own database named "WebCatalog Prefs," "Users.db," "ErrorMessages.db," "StandardConversions.db," or "Triggers.db"

Normally all database file paths are relative to the local template, or if they begin with "/" they are relative to the web server's virtual host root. You may optionally put "^" in front of the file path to indicate the file can be found in a global root folder called "Globals" inside the WebCatalogEngine folder. This global root folder is the same regardless of the virtual host.

You can use the 'AUTONUMBER=' parameter with the [append] or [replace] context to instruct WebDNA to automatically generate the 'next highest number' value for the given fieldname. This is useful for 'ID' type fields, where unique values are required. Here is a demonstration of the AUTONUMBER feature using a WebDNA TABLE (of course this will work on database files as well). Example WebDNA code:
[table name=table_1&fields=ID,NAME,EMAIL][/table][append table=table_1&autonumber=ID]NAME=Scott&EMAIL=scott@here.com[/append][append table=table_1&autonumber=ID]NAME=Lee&EMAIL=lee@there.com[/append][append table=table_1&autonumber=ID]NAME=OMNI&EMAIL=omni@everywhere.com[/append][delete table=table_1&eqIDdata=2][append table=table_1&autonumber=ID]NAME=Lee&EMAIL=lee@there.com[/append][search table=table_1&neIDdata=[blank]][founditems][ID] - [NAME] - [EMAIL][/founditems][/search]
Results: 1 - Scott - scott@here.com 3 - OMNI - omni@everywhere.com 4 - Lee - lee@there.com You can see that WebDNA automatically generated the ID value by calculating the 'next largest value', given the existing ID values in the table.

You can use [thisautonumber] tag from within an [append] or [replace] context, to retrieve the current auto-generated number (if the AUTONUMBER parameter was used).

Optional Context Parameters

- autonumber instructs WebDNA to automatically generate the 'next highest number' value for the given fieldname.
To add new records to a database, put an append context into a template. Whenever WebDNA encounters an append context, it immediately adds a new record to the end of the specified database given the named field values inside the append context.

Example:
[append db=base.db][!]
[/!]name=Grant&[!]
[/!]address=1492 Street&[!]
[/!]zip=9000&[!]
[/!]date=[date][!]
[/!][/append]

The database "base.db" is opened, and a new record is added to the end. The field name "name" is set to "Grant," the field name "address" is set to "1492 Street," the field name "zip" is set to "9000," and the field name "date" is set to the current date. Notice that any WebDNA [xxx] tags inside the context are first substituted for their real values before being written to the database. The name of the database itself may also be an [xxx] tag, as in "[append [formvariable]]."

Any field names not existing in the database are ignored, and any fields you do not specify are left blank in the new record. Certain letters are illegal, such as or , so they are converted to and before being added to the database. Some computers use the two-character sequence to indicate a single end of line, which is automatically converted to a single character before being added to the database.

You may specify an absolute or partial path to the database file, as in "/WebCatalog/Folder/base.db" or "../base.db" (relative paths start in the same folder as the template, just like URLs, so "../" will look "up" one folder level from the template, and "/" will start at the web server's root).

You can specifiy a WebDNA [table], in place of a db file, in the Append context. For example: [append table=TableName]values[/append]


Some database filenames are reserved. You may not create your own database named "WebCatalog Prefs," "Users.db," "ErrorMessages.db," "StandardConversions.db," or "triggers.db"


Normally all database file paths are relative to the local template, or if they begin with "/" they are relative to the web server's virtual host root. You may optionally put "^" in front of the file path to indicate the file can be found in a global root folder called "Globals" inside the WebCatalogEngine folder. This global root folder is the same regardless of the virtual host.


You can use the 'AUTONUMBER=' parameter with the [append] or [replace] context to instruct WebDNA to automatically generate the 'next highest number' value for the given fieldname. This is useful for 'ID' type fields, where unique values are required.

Here is a demonstration of the AUTONUMBER feature using a WebDNA TABLE (of course this will work on database files as well).

Example WebDNA code:
[table name=table_1&fields=ID,NAME,EMAIL][/table]

[append table=table_1&autonumber=ID]NAME=Scott&EMAIL=scott@here.com[/append]
[append table=table_1&autonumber=ID]NAME=Lee&EMAIL=lee@there.com[/append]
[append table=table_1&autonumber=ID]NAME=OMNI&EMAIL=omni@everywhere.com[/append]
[delete table=table_1&eqIDdata=2]
[append table=table_1&autonumber=ID]NAME=Lee&EMAIL=lee@there.com[/append]

[search table=table_1&neIDdata=[blank]]
[founditems]
[ID] - [NAME] - [EMAIL]

[/founditems]
[/search]


Results:

1 - Scott - scott@here.com
3 - OMNI - omni@everywhere.com
4 - Lee - lee@there.com

You can see that WebDNA automatically generated the ID value by calculating the 'next largest value', given the existing ID values in the table.

You can use [thisautonumber] tag from within an [append] or [replace] context, to retrieve the current auto-generated number (if the AUTONUMBER parameter was used).



DOWNLOAD WEBDNA NOW!

Top Articles:

F.A.Q

A compilation of some user's questions...

WebDNA Libraries

A list of available libraries for WebDNA...

Tips and Tricks

A list of user-submitted tips ...

WebDNA reference

...

Technical Change History

This Technical Change History provides a reverse chronological list of WebDNA changes...

AWS Raw WebDNA LAMP-Plus WebServer

Amazon Web Services (AWS) README for Machine Image ID...

Related Readings:

Alphabetical WebDNA Reference

A list of all WebDNA instructions...

[formvariables]

Lists all the form variables and parameters passed to the current page...

[!]

Hides text...

[interpret]

Interprets the enclosed [xxx] values using the WebDNA interpreter...

[return]

Explicitly identify what text is returned from a function call...

[SQLconnect]

Opens and persists a 'named' connection to a SQL server...