Differences

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

--- v5:userguide:learn_abstraction:record_insertion [2016/03/15 02:10] – mnewnham
+++ v5:userguide:learn_abstraction:record_insertion [2016/03/20 16:48] (current) – [Inserting A Record] mnewnham
@@ Line 1: / Line 1: @@
-<- v5:userguide:learn_abstraction:using_execute|Using Execute ^ v5:userguide:learn_abstraction:start_lesson|Start Of Lesson ^ v5:userguide:learn_dictionary:start_page|The Data Dictionary ->
+<- v5:userguide:learn_abstraction:using_execute|Using Execute ^ v5:userguide:learn_abstraction:start_lesson|Start Of Lesson ^ ->
 ~~NOTOC~~
 ====== Inserting And Updating Records ======
 ===== AutoExecute =====
-ADOdb provides a helper routine, [[v5:reference:connection:autoexecute|autoExecute()]]. AutoExecute() simplifies the task of inserting and updating records by providing a structured, easy to understand methodology.
+ADOdb provides a helper routine, [[v5:reference:connection:autoexecute|autoExecute()]]. It simplifies the task of inserting and updating records by providing a structured, easy to understand methodology.
 ==== Inserting A Record ====
 In order to insert a record, it is sufficient to know:
@@ Line 26: / Line 26: @@
 /*
- * result executes "INSERT INTO people (first_name,last_name) values ('Carol',Smith')";
+ * result executes "INSERT INTO people (first_name,last_name)
+                                values ('Carol',Smith')";
  */
 </code>
+AutoExecute helps, because it can automatically determine the type of the field to be created, quoting data appropriately, and can even handle special characters in the fields.
 ==== Updating A Record ====
 To update a record, we must also know how to retrieve the record uniquely, for example there might be a sequence number on the table that uniquely identifies each one. In the following example, the requested record is identified by an id number of 305:
@@ Line 42: / Line 45: @@
 /*
- * result executes "UPDATE people SET first_name='Caroline',last_name='Jones' WHERE id=305";
+ * result executes "UPDATE people SET first_name='Caroline',
+*                                     last_name='Jones'
+*                                     WHERE id=305";
  */
 </code>
@@ Line 49: / Line 54: @@
 If the record match statement produces a non-unique result set, then **ALL** records that match will be updated.
-  "last_name like 'Sm%'";
+<code php>
+$db->autoExecute($table, $record, 'UPDATE', "last_name like 'Sm%'");
+</code>
+===== Limitations =====
+AutoExecute is designed to be used as a UX helper, and contains multiple layers of validation which may cause performance issues. For improved performance, use can be made of [[v5:reference:connection:getinsertsql|getInsertSql()]] and [[v5:reference:connection:getupdatesql|getUpdateSql()]]. In OLTP environments, consider crafting inserts/updates programatically and using [[v5:reference:connection:execute|execute()]]
+<WRAP info 300px center>
+**End Of Lesson**
+</WRAP>