It could also be useful for insert statements.
-- Patrick.
Eddie O'Neil wrote:
>Chad--
>
> Couldn't you do that by building up the String outside of the DB
>control, passing it in as a parameter, and doing the substitution with
>something like:
>
>@SQL(SELECT column_name FROM table_name WHERE column_name IN ({sql:inClause})
>public Customer[] getCustomersIn(String inClause);
>
>it's not an ideal solution, but it'd work at least. We could concieve
>of a filter object that could be used to build up complex where /
>order by clauses with a simple JavaBean API. Just a thought...
>
>Eddie
>
>
>
>On 10/5/05, Chad Schoettger <chad.schoettger@gmail.com> wrote:
>
>
>>Hi Patrick,
>>
>>This use case is currently not supported. I think it could be supported, I
>>would just need to spend a bit of time coming up with the proper design for
>>it. If you would like, go ahead an file an enhancement request on JIRA for
>>this use case.
>>
>>- Chad
>>
>>On 10/5/05, Patrick Osborne <patrick.osborne@bea.com> wrote:
>>
>>
>>>Hi All,
>>>
>>>I've been using Beehive pageflows and controls for a couple of
>>>applications and I find it a highly effective and productive tool to
>>>build webapps and to manipulate database data.
>>>
>>>Recently I've been looking at invoking some SQL code via a JDBC control
>>>using the SQL IN command, similar to this:
>>>
>>>SELECT column_name FROM table_name WHERE column_name IN (value1,value2,..)
>>>
>>>I've looked at the documentation, but I've been unable to find support
>>>for producing a list of values like (value1,value2,..) via databinding
>>>to a list or array. Is this use case supported? If not, any plans to
>>>add support for this sort of thing?
>>>
>>>Thanks,
>>>Patrick.
>>>
>>>________________________________________________________________________________
>>>BEAWorld 2005: coming to a city near you. Everything you need for SOA and
>>>enterprise infrastructure success.
>>>
>>>
>>>Register now at http://www.bea.com/4beaworld
>>>
>>>
>>>London 11-12 Oct| Paris13-14 Oct| Prague18-19 Oct |Tokyo 25-26 Oct|
>>>Beijing 7-8 Dec
>>>
>>>
>>>
>>
>>
>
>
>
________________________________________________________________________________
BEAWorld 2005: coming to a city near you. Everything you need for SOA and enterprise infrastructure
success.
Register now at http://www.bea.com/4beaworld
London 11-12 Oct| Paris13-14 Oct| Prague18-19 Oct |Tokyo 25-26 Oct| Beijing 7-8 Dec