v5:reference:connection:getupdatesql
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
v5:reference:getupdatesql [2016/01/13 02:31] – ↷ Page moved from reference:getupdatesql to v5:reference:getupdatesql mnewnham | v5:reference:connection:getupdatesql [2019/12/26 05:50] – fix typo in example peterdd | ||
---|---|---|---|
Line 3: | Line 3: | ||
<WRAP right box> | <WRAP right box> | ||
== See Also == | == See Also == | ||
- | [[reference: | + | [[v5:reference: |
== Syntax == | == Syntax == | ||
Line 19: | Line 19: | ||
===== Parameters ===== | ===== Parameters ===== | ||
==== $result==== | ==== $result==== | ||
- | The parameter '' | + | The parameter '' |
<code php> | <code php> | ||
Line 35: | Line 35: | ||
'' | '' | ||
- | In addition, use of this parameter eliminates the need to add additional testing to determine if any fields have changed. In cases such as these, if the parameter is not set and there have been no modified fields, the getUpdateSql() method will return an empty string, causing [[reference: | + | In addition, use of this parameter eliminates the need to add additional testing to determine if any fields have changed. In cases such as these, if the parameter is not set and there have been no modified fields, the getUpdateSql() method will return an empty string, causing [[v5:reference: |
------------------------------------------------------------------------------- | ------------------------------------------------------------------------------- | ||
<WRAP right tip 300px> | <WRAP right tip 300px> | ||
Line 41: | Line 41: | ||
</ | </ | ||
==== $dontFixQuotes ==== | ==== $dontFixQuotes ==== | ||
- | For a description of this behavior see [[reference: | + | For a description of this behavior see [[v5:reference: |
-------------------------------------------------------------------------------- | -------------------------------------------------------------------------------- | ||
<WRAP right tip 300px> | <WRAP right tip 300px> | ||
Line 48: | Line 48: | ||
==== $forceType ==== | ==== $forceType ==== | ||
- | see [[reference: | + | see [[v5:reference: |
------------------------------------------- | ------------------------------------------- | ||
===== Usage ===== | ===== Usage ===== | ||
Line 72: | Line 72: | ||
$SQL = ' | $SQL = ' | ||
- | $result = $db->Execute($SQL); | + | $result = $db->execute($SQL); |
$updateArray = array(' | $updateArray = array(' | ||
Line 78: | Line 78: | ||
' | ' | ||
- | $SQL = $db-> | + | $SQL = $db-> |
- | + | ||
- | print $SQL | + | |
/* | /* | ||
- | * returns: UPDATE employees | + | * returns |
+ | | ||
SET FIRST_NAME=' | SET FIRST_NAME=' | ||
LAST_NAME=' | LAST_NAME=' | ||
Line 94: | Line 93: | ||
<code php> | <code php> | ||
- | $SQL = $db-> | + | $SQL = $db-> |
/* | /* | ||
* returns | * returns |
v5/reference/connection/getupdatesql.txt · Last modified: 2023/09/26 17:43 by dregad