[geeklog-cvs] Geeklog-2/system/DataAccess NamedQueries.xml,1.5,1.6

[vinny at iowaoutdoors.org]

Update of /var/cvs/Geeklog-2/system/DataAccess
In directory www:/tmp/cvs-serv4645/DataAccess

Modified Files:
	NamedQueries.xml 
Log Message:
First draft of Comment class, missing functionality (marked with FIXME)
requires changes in DAO to support UPDATEs.


Index: NamedQueries.xml
===================================================================
RCS file: /var/cvs/Geeklog-2/system/DataAccess/NamedQueries.xml,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** NamedQueries.xml	29 Dec 2004 19:17:15 -0000	1.5
--- NamedQueries.xml	17 Jan 2005 15:41:47 -0000	1.6
***************
*** 1,7 ****
--- 1,14 ----
  <?xml version="1.0" encoding="UTF-8"?>
  <named_queries>
+     <!-- Group Queries -->
      <query name="getGroupsSubs" type="propel">
          <criteria propelPeer="Gl2GroupAssignmentPeer" column="ASSIGNED_GROUP_ID" propelOperator="IN"/>
      </query>
+     
+     <!-- Comment Queries -->
+     <query name="getCommentPid" type="sql">
+         <sql propelPeer="Gl2CommentPeer">SELECT * FROM gl2_comment WHERE sid = "?" lft < ? AND rht > ? ORDER BY lft DESC LIMIT 1</sql>
+     </query>
+ 
  	<query name="getUserByUserName" type="propel">
  		<criteria propelPeer="GL2UserPeer" column="USER_NAME" propelOperator="" testValue="tony"/>