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
Last revisionBoth sides next revision
v5:reference:connection:getinsertsql [2016/03/23 14:26] – [$recordSet] fix broken link dregadv5:reference:connection:getinsertsql [2016/03/23 19:15] – [$dontFixQuotes] fix broken link dregad
Line 21: Line 21:
 ===== Parameters ===== ===== Parameters =====
 ====  $recordSet ==== ====  $recordSet ====
-The parameter ''$recordSet'' is either a recordset obtained by [[v5:reference:connection:execute|executing]] a select statement to obtain an **empty recordset**. There is no need to read the row.+The parameter ''$recordSet'' is either 
  
-<code php>+  * a //recordset// obtained by [[v5:reference:connection:execute|executing]] a select statement to obtain an **empty recordset**. There is no need to read the row. <code php>
 $SQL = "SELECT * FROM employees WHERE emp_no=-1"; $SQL = "SELECT * FROM employees WHERE emp_no=-1";
 $result = $db->execute($SQL); $result = $db->execute($SQL);
 $sql = $db->getInsertSql($result,..... $sql = $db->getInsertSql($result,.....
 </code> </code>
-or +   
-<code php>+  * a //string// specifying a table name <code php>
 $table = 'employees'; $table = 'employees';
 $sql = $db->getInsertSql($table,.... $sql = $db->getInsertSql($table,....
-</code> +</code> Note that in this casedue to the fact that the function passes the table name by reference, the following syntax is //not valid//: <code php>
-Note that in the second instancebecause the function passes the table name by reference, the following syntax is not valid+
-<code php>+
 /* /*
  * Incorrect syntax  * Incorrect syntax
  */  */
 $sql = $db->getInsertSql('employees',.... $sql = $db->getInsertSql('employees',....
-</code> +</code> Also note that this usage causes ADOdb to read the recordset information for itself, which may cause performance issues.
- +
-Also note that in the second example, ADOdb must attempt to read the recordset information for itself, and there may be performance issues.+
  
 ==== $fieldArray ==== ==== $fieldArray ====
Line 57: Line 53:
 </WRAP> </WRAP>
 ==== $dontFixQuotes ==== ==== $dontFixQuotes ====
-For a description of this behavior see [[v5:reference:qstr|qStr()]].+For a description of this behavior see [[v5:reference:connection:qstr|qStr()]].
 -------------------------------------------------------------------------------- --------------------------------------------------------------------------------
 <WRAP right tip 300px> <WRAP right tip 300px>
v5/reference/connection/getinsertsql.txt · Last modified: 2021/01/25 03:16 by mnewnham