Re: How to get ## into a SQL statement

[Brice Ruth]

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: user-java@ibatis.apache.org; 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