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