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