ibatis-user-cs mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Uwe Lesta <le...@sbs-softwaresysteme.de>
Subject Re: sqlmap parameter question
Date Wed, 28 Jun 2006 14:45:43 GMT
do you have your sql in

	<![CDATA[
		WHERE      (Date > '4/1/2006')
	]]>

cause '>' is part of XML

Paul Sullivan wrote:

> Hello,
> 
> I have a query in a sql map that contains sub queries, within those sub
> queries I compare dates and I want to be able to pass in a custom date.
> What is the best way to do this? I have a domain class containing the
> data but if I add it to the dynamic where clause it bombs (which it
> should). Here is an example of the where clause contained in the sub
> query (I want to be able to use whatever date I want instead of
> '4/1/2006'):
> 
>  
> 
> WHERE      (Date > '4/1/2006')   
> 
>  
> 
> Thanks,
> 
>   
> 
>  
> 
> Paul Sullivan
> 
>   <http://www.pcssinc.com> 
> 
> paul@pcssinc.com
> 
> 864-578-1038
> 
> :
> 
> Ext 125
> 
> 864-578-0980
> 
> :
> 
> Fax
> 
> 
> 
> 
>  
> 
>  
> 
>  
> 
>  
> 
>  
> 
> 

-- 

Kind regards

Uwe
Lesta at SBS-Softwaresysteme.de


Mime
View raw message