If all the #value-or-parameter# strings were converted to ? before the $subs$ substitutions were done, that wouldn't be a problem though, right? Would that detrimentally affect the dynamic SQL logic? The way I see it, #value# and $subs$ both need to be 'processed' before a PreparedStatement is created. In this case, the order is causing this symptom.
Of course, this is all guess-work, as I don't have the code in front of me ;)
Brice
2005/7/12, Larry Meadors <[EMAIL PROTECTED]>:
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
--
Brice Ruth
Software Engineer, Madison WI
