commit e808aac2627c35d50082f814d9778c4bf976011c
author Derek Allard <derek.allard@ellislab.com> Sun Apr 06 18:22:00 2008 +0000
committer Derek Allard <derek.allard@ellislab.com> Sun Apr 06 18:22:00 2008 +0000
tree 28db5d8b761dc02560e0f4c347a4e569f1dd66b2
parent 3ad8efe07deb3ec27a205815dc9097c20c728e9b

Added the ability to prevent escaping in having() clauses.

user_guide/changelog.html

diff --git a/user_guide/changelog.html b/user_guide/changelog.html
index af51c0e..62e4541 100644
--- a/user_guide/changelog.html
+++ b/user_guide/changelog.html
@@ -60,6 +60,11 @@
 <h2>Version 1.6.2</h2>

 <p>Release Date: not currently released</p>

 <ul>

+    <li>Active Record

+    	<ul>

+    		<li>Added the ability to prevent escaping in having() clauses.</li>

+    		</ul>

+    </li>

     <li>Config

     	<ul>

     		<li>Added 'application/vnd.ms-powerpoint' to list of mime types.</li>

user_guide/database/active_record.html

diff --git a/user_guide/database/active_record.html b/user_guide/database/active_record.html
index 533d52d..a9889d5 100644
--- a/user_guide/database/active_record.html
+++ b/user_guide/database/active_record.html
@@ -403,21 +403,29 @@
         <br />

     // Produces: SELECT DISTINCT * FROM table</code></p>

 <h2>$this->db->having();</h2>

-<p>Permits you to write the HAVING portion of your query:</p>

+<p>Permits you to write the HAVING portion of your query. There are 2 possible syntaxe, 1 argument or 2:</p>

 	

 <code>$this->db->having('user_id = 45');

-<br /><br />

-// Produces: HAVING user_id = 45</code>

+<br />

+// Produces: HAVING user_id = 45<br />

+<br />

+$this-&gt;db-&gt;having('user_id',  45'); <br />

+// Produces: HAVING user_id = 45<br />

+<br />

+</code>

 	

 <p>You can also pass an array of multiple values as well:</p>

 

 

-<code>$this->db->having(array('title =' => 'My Title', 'id <' => $id));

-<br /><br />

-// Produces: HAVING title = 'My Title', id < 45</code>

-

-	

-	

+<p><code>$this->db->having(array('title =' => 'My Title', 'id <' => $id)); <br />

+		<br />

+	// Produces: HAVING title = 'My Title', id < 45</code></p>

+<p>If you are using a database that CodeIgniter escapes queries for, you can prevent escaping content by passing an optional third argument, and setting it to FALSE.</p>

+<p><code>$this-&gt;db-&gt;having('user_id',  45'); <br />

+// Produces: HAVING `user_id` = `45` in some databases such as MySQL

+		<br />

+		$this-&gt;db-&gt;having('user_id',  45', FALSE); <br />

+// Produces: HAVING user_id = 45</code></p>

 <h2>$this-&gt;db-&gt;or_having();</h2>

 <p>Identical to having(), only separates multiple clauses with &quot;OR&quot;.</p>

 <h2>$this->db->order_by();</h2>