ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:reference:connection:getinsertsql

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Next revisionBoth sides next revision
v5:reference:getinsertsql [2016/01/13 02:30] – ↷ Page moved from reference:getinsertsql to v5:reference:getinsertsql mnewnhamv5:reference:connection:getinsertsql [2016/01/16 22:15] – ↷ Page moved from v5:reference:getinsertsql to v5:reference:connection:getinsertsql 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]]\\ 
-[[reference:adodb_force_type|$ADODB_FORCE_TYPE]]\\ +[[v5:reference:adodb_force_type|$ADODB_FORCE_TYPE]]\\ 
-[[reference:autoexecute|AutoExecute()]]\\+[[v5:reference:autoexecute|AutoExecute()]]\\
  
  
Line 21: Line 21:
 ===== Parameters ===== ===== Parameters =====
 ====  $recordSet ==== ====  $recordSet ====
-The parameter ''$recordSet'' is either a recordset obtained by [[reference:execute|executing]] a select statement to obtain an **empty recordset**. There is no need to read the row.+The parameter ''$recordSet'' is either a recordset obtained by [[v5:reference:execute|executing]] a select statement to obtain an **empty recordset**. There is no need to read the row.
  
 <code php> <code php>
Line 46: Line 46:
 ''$fieldArray'' is an associative key=>value pair of fieldnames and values. The values in the pair will be inserted into the record. Note also ''$fieldArray'' is an associative key=>value pair of fieldnames and values. The values in the pair will be inserted into the record. Note also
   * Any key in the array that does not match a field name in the table will be discarded before the SQL statement is produced.   * Any key in the array that does not match a field name in the table will be discarded before the SQL statement is produced.
-  * The value of any field in the table that does not appear in the ''$fieldArray'' is controlled by the [[reference:adodb_force_type|$ADODB_FORCE_TYPE]] variable.+  * The value of any field in the table that does not appear in the ''$fieldArray'' is controlled by the [[v5:reference:adodb_force_type|$ADODB_FORCE_TYPE]] variable.
   * Auto-increment fields should not be included in the field list.   * Auto-increment fields should not be included in the field list.
  
Line 57: Line 57:
 </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 64: Line 64:
 ==== $forceType ==== ==== $forceType ====
  
-see [[reference:adodb_force_type|$ADODB_FORCE_TYPE]]+see [[v5:reference:adodb_force_type|$ADODB_FORCE_TYPE]]
 ------------------------------------------- -------------------------------------------
 ===== Usage ===== ===== Usage =====
v5/reference/connection/getinsertsql.txt · Last modified: 2021/01/25 03:16 by mnewnham