edb_jsonupdate

Updates a row in a cursor using Elevate Web Builder dataset JSON before and after row values.

Syntax

edb_jsonupdate(<CursorHandle>, <BeforeRowValues>, <AfterRowValues>,
                       [<LocalizedDateTimeColumns>])

<CursorHandle> =

Handle of cursor returned by edb_execute function

<BeforeRowValues>
<AfterRowValues> =

Associative array of column names and values

<LocalizedDateTimeColumns> =

Boolean indicating whether to convert date/time columns to local time

Returns

TRUE if successful, and FALSE if there are any errors

Usage

The edb_jsonupdate function updates an existing row in the specified cursor using the provided associative arrays of column names and values. The column values are expected to be in Elevate Web Builder format, meaning that data types like dates, times, or date/times (timestamps) will be expressed as integer Javascript timestamp values.

This function moves the current row pointer in the cursor.

Please see the Elevate Web Builder manual for more information on datasets and the JSON data formats used with them.

This function is used exclusively by the Elevate Web Builder PHP DataSet Manager included with Elevate Web Builder for updating rows using incoming JSON transaction data. Although it can be used outside of this context, it is made available primarily for use in this manner. The benefit of using this function is that it transparently handles date/time conversions (and all other types of data type conversions) properly between JSON and ElevateDB columns.

More Support Options

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Incident Reports

Roadmap