| | | | | |
| | |
- DSQL v2.0.2.2
- Added ability via DSQL->$StrictMode variable to update MySQL strict mode
- Added DSQL->RawQuery() function which takes just a query, and does no modification on it. I found this required due to extremely slow times on building very large queries.
- Added DSQL->EscapeString() function which escapes a string for use in a mysql query. It has an optional parameter that adds single quotes around the result.
- Added DSQL::PrepareInsertList() function which takes an array of names, and turns it into the following string: ['a', 'b', 'c'] => “(`a`, `b`, `c`) VALUES (?, ?, ?)”
- DWCF v1.1.1
- Added previous variable lookup to GetVars.VarArray.SQLLookup via %THEVAR-$VARNAME%
| |
|
| | | DSQL v2.0.2
- Added static member $InitialPrintAndDieOnError which DSQL.PrintAndDieOnError inherits on creation
- Bug Fixes:
- mysqli_set_charset is set to utf-8
- In FormatSQLError() the date() function used for “Start Time” now uses “24-hour format of an hour with leading zeros” [date(“H”)] instead of “12-hour format of an hour without leading zeros” [date(“g”)]
|  | |
|
| | | DWCF v1.1 updates
- Added functionality:
- GetVars.VarArray.SQLLookup:
- Additional string parameters that have %THEVAR% are replaced with the value being checked
- If the first item is NULL, it will be removed, and the return will include full rows ("*") of the query result set
- Updated functionality:
- json_encode() In RetMsg() and CallByAction() now use JSON_UNESCAPED_UNICODE
- GetVars.VarArray.IsOptional now only triggers if it is (boolean)true
- Added additional description specification to GetVars.VarArray.SQLLookup which says it uses the additional parameters as values to fill in the SQL Query
- LICENSE: Now applies to 1.x instead of 1.0.x
| | |
|
