From e808aac2627c35d50082f814d9778c4bf976011c Mon Sep 17 00:00:00 2001
From: Derek Allard <derek.allard@ellislab.com>
Date: Sun, 6 Apr 2008 18:22:00 +0000
Subject: Added the ability to prevent escaping in having() clauses.

---
 user_guide/changelog.html              |  5 +++++
 user_guide/database/active_record.html | 26 +++++++++++++++++---------
 2 files changed, 22 insertions(+), 9 deletions(-)

(limited to 'user_guide')

diff --git a/user_guide/changelog.html b/user_guide/changelog.html
index af51c0e24..62e4541e0 100644
--- a/user_guide/changelog.html
+++ b/user_guide/changelog.html
@@ -60,6 +60,11 @@ Change Log
 <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>
diff --git a/user_guide/database/active_record.html b/user_guide/database/active_record.html
index 533d52dc1..a9889d559 100644
--- a/user_guide/database/active_record.html
+++ b/user_guide/database/active_record.html
@@ -403,21 +403,29 @@ $this-&gt;db-&gt;or_not_like('body', 'match'); <br />
         <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>
-- 
cgit v1.2.3-24-g4f1b