ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools

Trace:
v5:reference:connection:getupdatesql

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revisionBoth sides next revision
v5:reference:getupdatesql [2016/01/13 02:31] – ↷ Page moved from reference:getupdatesql to v5:reference:getupdatesql mnewnhamv5:reference:getupdatesql [2016/01/13 02:31] – ↷ Links adapted because of a move operation mnewnham
Line 3: Line 3:
 <WRAP right box> <WRAP right box>
 == See Also == == See Also ==
-[[reference:adodb_quote_fieldnames|$ADODB_QUOTE_FIELDNAMES]]+[[v5:reference:adodb_quote_fieldnames|$ADODB_QUOTE_FIELDNAMES]]
  
 == Syntax == == Syntax ==
Line 19: Line 19:
 ===== Parameters ===== ===== Parameters =====
 ====  $result==== ====  $result====
-The parameter ''$result'' is the handle to the result obtained by [[reference:execute|executing]] a select statement to obtain the record, **not the recordset associated with the request**. There is no need to read the row.+The parameter ''$result'' is the handle to the result obtained by [[v5:reference:execute|executing]] a select statement to obtain the record, **not the recordset associated with the request**. There is no need to read the row.
  
 <code php> <code php>
Line 35: Line 35:
 ''$forceUpdate'' forces the sql statement to include updates for fields that have not changed. It may be necessary to force updates when, for example, distinction needs to be made between null and zero in integer fields. ''$forceUpdate'' forces the sql statement to include updates for fields that have not changed. It may be necessary to force updates when, for example, distinction needs to be made between null and zero in integer fields.
  
-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:execute()]] to fail if passed this parameter.+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:execute]] to fail if passed this parameter.
 ------------------------------------------------------------------------------- -------------------------------------------------------------------------------
 <WRAP right tip 300px> <WRAP right tip 300px>
Line 41: Line 41:
 </WRAP> </WRAP>
 ==== $dontFixQuotes ==== ==== $dontFixQuotes ====
-For a description of this behavior see [[reference:qstr|qStr()]].+For a description of this behavior see [[v5:reference:qstr|qStr()]].
 -------------------------------------------------------------------------------- --------------------------------------------------------------------------------
 <WRAP right tip 300px> <WRAP right tip 300px>
Line 48: Line 48:
 ==== $forceType ==== ==== $forceType ====
  
-see [[reference:adodb_force_type|$ADODB_FORCE_TYPE]]+see [[v5:reference:adodb_force_type|$ADODB_FORCE_TYPE]]
 ------------------------------------------- -------------------------------------------
 ===== Usage ===== ===== Usage =====
v5/reference/connection/getupdatesql.txt · Last modified: 2023/09/26 17:43 by dregad