This is just plain funny. Can you tell that we love the easy questions?

Brandon

On 5/19/05, Ron Grabowski <[EMAIL PROTECTED]> wrote:
> You can use:
> 
>  &lt;
> 
> Or enclose the text within CDATA:
> 
> <select id="getNOFBidding" resultClass="int" parameterClass="string">
>  <![CDATA[
>   SELECT * FROM Sale WHERE TO_DAYS(NOW()) - TO_DAYS(SALEDATE) <= 15
>  ]]>
> </select>
> 
> --- Pham Anh Tuan <[EMAIL PROTECTED]> wrote:
> > Hi,
> >
> > I can't not type < sign in sql definition xml file, I don't know why,
> > plz help me solve this problem :(
> >
> > <select id="getNOFBidding" resultClass="int" parameterClass="string">
> >
> > select COUNT(distinct ITEMID)
> >
> > from SALE
> >
> > where SALESTATUS = 0 and MAXPRICE = 1
> >
> > and TO_DAYS(NOW()) - TO_DAYS(SALEDATE) <= 15 and TO_DAYS(NOW()) -
> > TO_DAYS(SALEDATE) > 0
> >
> > and BUYERUSERID = #value#
> >
> > </select>
> >
> > report error: The content of elements must consist of well-formed
> > character data or markup
> >
> > Thanks for reading
> >
> > Anh Tuan
> >
>

Reply via email to