Re: [HELP] I can't not type < sign in my sqlmap xml file

[Ron Grabowski]

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
>