Doctrine

Timestamp:

06/02/08 21:46:51 (13 months ago)

Author:

hansbrix

Message:

quick fix to an un-aliased query, to prevent confusion as raised by a beginner in #doctrine

Files:

• branches/0.11/manual/docs/en/working-with-objects.txt (modified) (2 diffs)

branches/0.11/manual/docs/en/working-with-objects.txt

@@ -230 +230 @@
 <code type="php">
 $user = Doctrine_Query::create()
-    ->from('User')
-    ->leftJoin('Groups')
-    ->where('id = ?')
-    ->fetchOne(array(1));
+    ->select('u.*, g.*')
+    ->from('User u')
+    ->leftJoin('u.Groups g')
+    ->where('id = ?', 1)
+    ->fetchOne();
 
 // Display this object on a cool javascript form that allows you to:
@@ -245 +246 @@
 
 $user = Doctrine_Query::create()
-    ->from('User')
-    ->leftJoin('Groups')
-    ->where('id = ?')
-    ->fetchOne(array(1));
+    ->select('u.*, g.*')
+    ->from('User u')
+    ->leftJoin('u.Groups g')
+    ->where('id = ?', 1)
+    ->fetchOne();
 
 // sanitize the form input an get the data