Prepend not working

I have the following code and does not work.  Is this a bug
or am I
not understanding how the prepend should work?  I get a
"sql error
near tp_Calls".  The prepends aren't adding in the
"and" to the
resultant sql string.

<dynamic prepend="WHERE">
	<![CDATA[
	  OffHookDt <= #EndDate# AND
	  OffHookDt >= #StartDate#
	]]>
	<isNotNull property="LocationCode">
		<isNotEqual prepend="and"
property="LocationCode"
compareValue="%">
			tp_Calls.LocationCd = #LocationCode#
		</isNotEqual>
	</isNotNull>
	<isNotEqual prepend="and"
property="RateType"
compareValue="-1">
		RateType = #RateType#
	</isNotEqual>
	<isEqual prepend="and"
property="PrivateAllowed"
compareValue="0">
		tp_Calls.Hidden = 0
	</isEqual>
</dynamic>

If I change it to the following everything works great.

<dynamic prepend="WHERE">
	<![CDATA[
	  OffHookDt <= #EndDate# AND
	  OffHookDt >= #StartDate#
	]]>
	<isNotNull  property="LocationCode">
		<isNotEqual property="LocationCode"
compareValue="%">
			and tp_Calls.LocationCd = #LocationCode#
		</isNotEqual>
	</isNotNull>
	<isNotEqual property="RateType"
compareValue="-1">
		and RateType = #RateType#
	</isNotEqual>
	<isEqual property="PrivateAllowed"
compareValue="0">
		and tp_Calls.Hidden = 0
	</isEqual>
</dynamic>

Mike

I know there are currently some bugs in how prepend is
working. Try 
adding prepend to the first isNotNull section also. For some
reason it 
seems you have to prepend="and" to places where
you wouldn't think it 
would be needed.

Michael Schall wrote:
> I have the following code and does not work.  Is this a
bug or am I
> not understanding how the prepend should work?  I get a
"sql error
> near tp_Calls".  The prepends aren't adding in
the "and" to the
> resultant sql string.
> 
> <dynamic prepend="WHERE">
>     <![CDATA[
>       OffHookDt <= #EndDate# AND
>       OffHookDt >= #StartDate#
>     ]]>
>     <isNotNull
property="LocationCode">
>         <isNotEqual prepend="and"
property="LocationCode"
compareValue="%">
>             tp_Calls.LocationCd = #LocationCode#
>         </isNotEqual>
>     </isNotNull>
>     <isNotEqual prepend="and"
property="RateType"
compareValue="-1">
>         RateType = #RateType#
>     </isNotEqual>
>     <isEqual prepend="and"
property="PrivateAllowed"
compareValue="0">
>         tp_Calls.Hidden = 0
>     </isEqual>
> </dynamic>
> 
> If I change it to the following everything works great.
> 
> <dynamic prepend="WHERE">
>     <![CDATA[
>       OffHookDt <= #EndDate# AND
>       OffHookDt >= #StartDate#
>     ]]>
>     <isNotNull 
property="LocationCode">
>         <isNotEqual
property="LocationCode"
compareValue="%">
>             and tp_Calls.LocationCd = #LocationCode#
>         </isNotEqual>
>     </isNotNull>
>     <isNotEqual property="RateType"
compareValue="-1">
>         and RateType = #RateType#
>     </isNotEqual>
>     <isEqual property="PrivateAllowed"
compareValue="0">
>         and tp_Calls.Hidden = 0
>     </isEqual>
> </dynamic>
> 
> Mike
> 

I actually tried that first .  I thought that the nested
isNotNull and
isNotEqual might be too complex so at first I added
"and
tp_Calls.LocationCd = #LocationCode#" and left the
other two as a
prepend.  The first simple one failed as well.

On 4/29/06, Rick Reumann <rickcrgmail.com> wrote:
> I know there are currently some bugs in how prepend is
working. Try
> adding prepend to the first isNotNull section also. For
some reason it
> seems you have to prepend="and" to places
where you wouldn't think it
> would be needed.
>
> Michael Schall wrote:
> > I have the following code and does not work.  Is
this a bug or am I
> > not understanding how the prepend should work?  I
get a "sql error
> > near tp_Calls".  The prepends aren't adding
in the "and" to the
> > resultant sql string.
> >
> > <dynamic prepend="WHERE">
> >     <![CDATA[
> >       OffHookDt <= #EndDate# AND
> >       OffHookDt >= #StartDate#
> >     ]]>
> >     <isNotNull
property="LocationCode">
> >         <isNotEqual prepend="and"
property="LocationCode"
compareValue="%">
> >             tp_Calls.LocationCd = #LocationCode#
> >         </isNotEqual>
> >     </isNotNull>
> >     <isNotEqual prepend="and"
property="RateType"
compareValue="-1">
> >         RateType = #RateType#
> >     </isNotEqual>
> >     <isEqual prepend="and"
property="PrivateAllowed"
compareValue="0">
> >         tp_Calls.Hidden = 0
> >     </isEqual>
> > </dynamic>
> >
> > If I change it to the following everything works
great.
> >
> > <dynamic prepend="WHERE">
> >     <![CDATA[
> >       OffHookDt <= #EndDate# AND
> >       OffHookDt >= #StartDate#
> >     ]]>
> >     <isNotNull 
property="LocationCode">
> >         <isNotEqual
property="LocationCode"
compareValue="%">
> >             and tp_Calls.LocationCd =
#LocationCode#
> >         </isNotEqual>
> >     </isNotNull>
> >     <isNotEqual property="RateType"
compareValue="-1">
> >         and RateType = #RateType#
> >     </isNotEqual>
> >     <isEqual
property="PrivateAllowed"
compareValue="0">
> >         and tp_Calls.Hidden = 0
> >     </isEqual>
> > </dynamic>
> >
> > Mike
> >
>
>