beehive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Eddie O'Neil <ekon...@gmail.com>
Subject Re: Is there JDBC control support for SQL IN?
Date Wed, 05 Oct 2005 17:58:24 GMT
  Not following -- what do you mean?  What sort of insert behavior are
you looking for?

  And, as an aside, in the future, these questions are best addressed
on user@beehive.

  :)

Eddie


On 10/5/05, Patrick Osborne <patrick.osborne@bea.com> wrote:
>
> 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
>

Mime
View raw message