ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brice Ruth <bdr...@gmail.com>
Subject Re: How do I use the dollar sign notation (i.e. $xyz$) to send a string to the database that has a pound sign on either side of it?
Date Thu, 07 Apr 2005 13:16:46 GMT
Note - the $xyz$ notation does not create a '?' for a prepared statement ... 
it's value (as indicated by Brandon) is placed into the SQL string before 
the prepared statement is generated.

On Apr 6, 2005 4:25 PM, Ron Grabowski <rongrabowski@yahoo.com> wrote: 
> 
> How do I use the dollar sign notation (i.e. $xyz$) to send a string to
> the database that has a pound sign on either side of it?
> 
> According to this post:
> 
> http://tinyurl.com/44je6
> 
> http://www.mail-archive.com/ibatis-user-java@incubator.apache.org/msg01358.html
> 
> I should use a double pound to send the literal pound. Given this sql
> statement:
> 
> <select parameterClass="map" resultClass="string">
> SELECT Name FROM Band WHERE Name = '12##34$BandName$56##78'
> </select>
> 
> Which of the two choices below should I see in my log files?
> 
> A) SELECT Name FROM Band WHERE Name = '12?78'
> B) SELECT Name FROM Band WHERE Name = '12#34?56#78'
> 
> Thanks,
> Ron
> 



-- 
Brice Ruth
Software Engineer, Madison WI

Mime
View raw message