v5:reference:connection:autoexecute
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
reference:autoexecute [2015/10/14 03:19] – mnewnham | v5:reference:connection:autoexecute [2021/01/25 03:07] (current) – mnewnham | ||
---|---|---|---|
Line 1: | Line 1: | ||
====== autoExecute ====== | ====== autoExecute ====== | ||
<WRAP info> | <WRAP info> | ||
- | autoExecute is designed to provide a robust simple interface to record updating and insertion. As such, it contains multiple layers of table, column and data validation to ensure data integrity prior to record insertion or update. Consequently, | + | autoExecute is designed to provide a robust simple interface to record updating and insertion. As such, it contains multiple layers of table, column and data validation to ensure data integrity prior to record insertion or update. Consequently, |
- | </ | + | |
- | <WRAP info> | + | |
- | Some of the default behaviours of autoExecute have changed in ADOdb Version 6. See the section on [[dictionary: | + | |
</ | </ | ||
~~NOTOC~~ | ~~NOTOC~~ | ||
<WRAP right box> | <WRAP right box> | ||
== See Also == | == See Also == | ||
- | [[reference: | + | [[v5:reference: |
== Syntax == | == Syntax == | ||
bool autoExecute( | bool autoExecute( | ||
Line 17: | Line 14: | ||
| | ||
| | ||
- | | ||
) | ) | ||
Line 24: | Line 20: | ||
===== Description ===== | ===== Description ===== | ||
- | The function '' | + | The function '' |
- | AutoExecute() inserts or updates | + | autoExecute() inserts or updates |
==== $table ==== | ==== $table ==== | ||
Line 35: | Line 31: | ||
==== $mode ===== | ==== $mode ===== | ||
- | Legal values for `$mode` are | + | Legal values for ` $mode ` are |
^String^Integer^Constant^ | ^String^Integer^Constant^ | ||
Line 50: | Line 46: | ||
|true|All fields provided are updated|The constructed statement may be considerably larger| | |true|All fields provided are updated|The constructed statement may be considerably larger| | ||
- | ==== $dontFixQuotes==== | ||
- | For a description of this parameter, see [[reference: | ||
- | |||
==== Usage ==== | ==== Usage ==== | ||
- | + | <code php> | |
- | AutoExecute($table, $arrFields, $mode, $where=false, | + | autoExecute($table, $arrFields, $mode, $where=false, |
+ | </ | ||
=== Insert example === | === Insert example === | ||
Line 64: | Line 57: | ||
$record[" | $record[" | ||
- | $conn->AutoExecute($table, | + | $conn->autoExecute($table, |
/* | /* | ||
Line 78: | Line 71: | ||
$where | $where | ||
- | $conn->AutoExecute($table, | + | $conn->autoExecute($table, |
/* | /* | ||
Line 85: | Line 78: | ||
</ | </ | ||
- | In situations where the table names contain certain special characters, such as dashes, the [[reference: | + | In situations where the table names contain certain special characters, such as dashes, the [[v5:reference: |
<code php> | <code php> | ||
Line 94: | Line 87: | ||
$where | $where | ||
- | $conn->AutoExecute($table, | + | $conn->autoExecute($table, |
/* | /* |
v5/reference/connection/autoexecute.txt · Last modified: 2021/01/25 03:07 by mnewnham