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: > > < > > 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 > > >

