Adding and Updating Records¶

Add a Record Using an Inline¶

The following example shows how to perform an -add action by specifying the required parameters within an inline method. The -database is set to “contacts”, -table is set to “people”, and -keyField is set to “id”. Feedback that the -add action was successful is provided to the visitor inside the inline using the error_currentError method. The added record will only include default values as defined within the database itself.

inline(
   -add,
   -database='contacts',
   -table='people',
   -keyField='id'
) => {^
   '<p>' + error_code + ': ' + error_msg + '</p>'
^}

If the -add action is successful then the following will be returned:

// => <p>0: No Error</p>

Add a Record with Data Using an Inline¶

The following example shows how to perform an -add action by specifying the required parameters within an inline method. Additionally, the inline includes a series of name/value pair parameters that define the values for various fields within the record that is to be added. The “first_name” field is set to “John” and the “last_name” field is set to “Doe”. The added record will include these values as well as any default values defined in the database itself.

inline(
   -add,
   -database='contacts',
   -table='people',
   -keyField='id',
   'first_name'='John',
   'last_name'='Doe'
) => {^
   '<p>' + error_code + ': ' + error_msg + '</p>\n'
   'Record ' + field('id') + ' was added for ' + field('first_name') + ' ' + field('last_name') + '.'
^}

The results of the -add action contain the values for the record that was just added to the database:

// =>
// <p>0: No Error</p>
// Record 2 was added for John Doe.

Add a Record Using an HTML Form¶

The following example shows how to perform an -add action using an HTML form to send values into an inline method through web_request->param. The text inputs provide a way for the site visitor to define the initial values for various fields in the record that will be added to the database. The site visitor can set values for the fields “first_name” and “last_name”.

<form action="response.lasso" method="POST">
   <br />First Name: <input type="text" name="first_name" value="" />
   <br />Last Name:  <input type="text" name="last_name" value="" />
   <br /><input type="submit" name="submit" value="Add" />
</form>

The response page for the form, “response.lasso”, contains the following code that performs the action using an inline method and provides feedback that the record was successfully added to the database. The field values for the record that was just added to the database are automatically available within the inline.

inline(
   -add,
   -database='contacts',
   -table='people',
   -keyField='id',
   'first_name'=web_request->param('first_name'),
   'last_name'=web_request->param('last_name')
) => {^
   '<p>' + error_code + ': ' + error_msg + '</p>\n'
   'Record ' + field('id') + ' was added for ' + field('first_name') + ' ' + field('last_name') + '.'
^}

If the form is submitted with “Mary” in the “first_name” input and “Person” in the “last_name” input then the following will be returned:

// =>
// <p>0: No Error</p>
// Record 3 was added for Mary Person

Add a Record Using a URL¶

The following example shows how to perform an -add action using a URL to send values into an inline method through web_request->param. The name/value pair parameters in the URL define the initial values for various fields in the database: “first_name” is set to “John” and “last_name” is set to “Person”.

<a href="response.lasso?first_name=John&last_name=Person">
   Add John Person
</a>

Using the same response page from the previous example, if the link for “Add John Person” is activated then the following will be returned:

// =>
// <p>0: No Error</p>
// Record 4 was added for John Person.

Update a Record with Data Using an Inline¶

The following example shows how to perform an -update action by specifying the required parameters within an inline method. The record with the value “2” in field “id” is updated. The inline includes a series of pair parameters that defines the new values for various fields within the record that is to be updated. The “first_name” field is set to “Bob” and the “last_name” field is set to “Surname”. The updated record will include these new values, but any fields that were not included in the action will be left with the values they had before the update.

inline(
   -update,
   -database='contacts',
   -table='people',
   -keyField='id',
   -keyValue=2,
   'first_name'='Bob',
   'last_name'='Surname'
) => {^
   '<p>' + error_code + ': ' + error_msg + '</p>\n'
   'Record ' + field('id') + ' was updated to ' +
         field('first_name') + ' ' + field('last_name') + '.'
^}

The updated field values from the -update action are automatically available within the inline:

// =>
// <p>0: No Error</p>
// Record 2 was updated to Bob Surname.

Update a Record Using an HTML Form¶

The following example shows how to perform an -update action using an HTML form to send values into an inline method. The text inputs provide a way for the site visitor to define the new values for various fields in the record that will be updated in the database. The site visitor can see and update the current values for the fields “first_name” and “last_name”.

[inline(
   -search,
   -database='contacts',
   -table='people',
   -keyField='id',
   -keyValue=3
)]
<form action="response.lasso" method="POST">
   <input type="hidden" name="keyValue" value="[keyField_value]" />
   <br />First Name: <input type="text" name="first_name" value="[field('first_name')]" />
   <br />Last Name: <input type="text" name="last_name" value="[field('last_name')]" />
   <br /><input type="submit" name="submit" value="Update" />
</form>
[/inline]

The response page for the form, “response.lasso”, contains the following code that performs the action using an inline method and provides feedback that the record was successfully updated in the database. The field values from the updated record are automatically available within the inline.

inline(
   -update,
   -database='contacts',
   -table='people',
   -keyField='id',
   -keyValue=web_request->param('keyValue'),
   'first_name'=web_request->param('first_name'),
   'last_name'=web_request->param('last_name')
) => {^
   '<p>' + error_code + ': ' + error_msg + '</p>\n'
   'Record ' + field('id') + ' was updated to ' +
         field('first_name') + ' ' + field('last_name') + '.'
^}

The form initially shows “Mary” for the “first_name” input and “Person” for the “last_name” input. If the form is submitted with the “last_name” changed to “Peoples” then the following will be returned. (The “first_name” field is unchanged since it was left set to “Mary”.)

// =>
// <p>0: No Error</p>
// Record 3 was updated to Mary Peoples.

Update a Record Using a URL¶

The following example shows how to perform an -update action using a URL to send values into an inline method through web_request->param. The name/value pair parameters in the URL define the new values for various fields in the database: “first_name” is set to “John” and “last_name” is set to “Person”.

<a href="response.lasso?keyValue=4&first_name=John&last_name=Person">
   Update John Person
</a>

Using the same response page from the previous example, if the link for “Update John Person” is activated then the following will be returned:

// =>
// <p>0: No Error</p>
// Record 4 was updated to John Person.

Update Several Records at Once¶

The following example shows how to perform an -update action on several records at once within a single database table. The goal is to update every record in the database with the last name of “Person” to the new last name of “Peoples”.

There are two methods to accomplish this. The first method is to use the -key parameter to find the records that need to be updated within a single -update inline. The second method is to use an outer inline to find the records to be updated and then an inner inline that is repeated once for each record.

The -key method has the advantage of speed and is the best choice for simple updates. The nested inline method can be useful if additional processing is required on each record before it is updated within the data source.

inline(
   -update,
   -database='contacts',
   -table='people',
   -key=(: -eq, 'last_name'='Person'),
   -maxRecords='all',
   'last_name'='Peoples'
) => {}

inline(
   -search,
   -database='contacts',
   -table='people',
   -keyField='id',
   -maxRecords='all',
   'last_name'='Person'
) => {^
   records => {^
      inline(
         -update,
         -database=database_name,
         -table=table_name,
         -keyField=keyField_name,
         -keyValue=keyField_value,
         'last_name'='Peoples'
      ) => {^
         '<p>' + error_code + ': ' + error_msg + '</p>\n'
         'Record ' + field('id') + ' was updated to ' +
               field('first_name') + ' ' + field('last_name') + '.'
      ^}
   ^}
^}

// =>
// <p>0: No Error</p>
// Record 4 was updated to John Peoples.

Delete a Record with Data Using an Inline¶

The following example shows how to perform a delete action by specifying the required parameters within an inline method. The record with the value “2” in field “id” is deleted:

inline(
   -delete,
   -database='contacts',
   -table='people',
   -keyField='id',
   -keyValue=2
) => {^
   '<p>' + error_code + ': ' + error_msg + '</p>'
^}

If the delete action is successful then the following will be returned:

// => <p>0: No Error</p>

Delete Several Records at Once¶

The following example shows how to perform a -delete action on several records at once within a single database table. The goal is to delete every record in the database with the last name of “Peoples”.

There are two methods to accomplish this. The first method is to use the -key parameter to find the records that need to be deleted within a single -delete inline. The second method is to use an outer inline to find the records to be deleted and then an inner inline that is repeated once for each record.

The -key method has the advantage of speed and is the best choice for simple deletes. The nested inline method can be useful if additional processing is required to decide if each record should be deleted.

inline(
   -delete,
   -database='contacts',
   -table='people',
   -key=(: -eq, 'last_name'='Peoples')
) => {}

inline(
   -search,
   -database='contacts',
   -table='people',
   -keyField='id',
   -maxRecords='all',
   'last_name'='Peoples'
) => {^
   records => {^
      inline(
         -delete,
         -database=database_name,
         -table=table_name,
         -keyField=keyField_name,
         -keyValue=keyField_value
      ) => {^
         '<p>' + error_code + ': ' + error_msg + '</p>'
      ^}
   ^}
^}

// => <p>0: No Error</p>