I think you want to use < rather than <. SqlMaps will understand. Also use > instead of >
-Wolf
On Thu, 19 May 2005, Pham Anh Tuan 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