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?

2005-04-07 Thread Ron Grabowski
, 2005 4:25 PM, Ron Grabowski <[EMAIL PROTECTED]> 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: > > > > h

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?

2005-04-07 Thread Brice Ruth
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 <[EMAIL PROTECTED]> wrote: How do I use the dollar sign notation (i.e. $x

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?

2005-04-06 Thread Brandon Goodin
assuming the $BandName$ literal had the value of "Stellar" you should see: SELECT Name FROM Band WHERE Name = '12#34Stellar56#78' On Apr 6, 2005 3:25 PM, Ron Grabowski <[EMAIL PROTECTED]> wrote: > How do I use the dollar sign notation (i.e. $xyz$) to send a string

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?

2005-04-06 Thread Ron Grabowski
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