Nope, that is not a bug IMO. If you want to construct dynamic SQL using $substitution$, I think that should work as it does.
Larry On 7/12/05, Brice Ruth <[EMAIL PROTECTED]> wrote: > So, if you include the '##' as part of the paramTempTable variable when its > passed into iBatis, you get an error? That seems like a bug to me. What do > you think, Larry? Clinton? The '#' and '$' symbols are reserved in the > SqlMap file itself, but passing in variables that include this should be > kosher. > > Brice > > 2005/7/12, Barnett, Brian W. <[EMAIL PROTECTED]>: > > I ended up doing this and it worked fine: > > > > SELECT * > > FROM ####$paramTempTable$ > > > > If I included the ## as part of paramTempTable, I got an error. I can't > > remember what the error was. Seems like it was some obscure error. > Something > > about "@P0" or something. > > > > Thanks all for your suggestions. > > > > -----Original Message----- > > From: Larry Meadors [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, July 12, 2005 8:59 AM > > To: [email protected]; Brice Ruth > > Subject: Re: How to get ## into a SQL statement > > > > > > The remapResults attribute should not be required - the table name > changes, > > but the column list does not. > > > > Larry > > > > On 7/12/05, Brice Ruth <[EMAIL PROTECTED]> wrote: > > > I think your problem is that you need to use $paramTempTable$ to > > > parameterize your table. You'll probably also need to set > > > remapResults="true" in your mapped statement definition. > > > > > **************************************************************************** > > This email may contain confidential material. > > If you were not an intended recipient, > > Please notify the sender and delete all copies. > > We may monitor email to and from our network. > > > **************************************************************************** > > > > > > -- > Brice Ruth > Software Engineer, Madison WI
