Thanks for the tip. I started with SqlTransformer because I *thought* that it was the
new/improved/suggested way of doing things with sql.
I'm starting to get the impression db support is low priority here. I guess that's
fine... I
guess I just could've figured it out sooner :)
--- "Anderson J. Vitous" <[EMAIL PROTECTED]> wrote:
> I've not done anything using SqlTransformer, but parameter binding can
> be done with ESQL in XSPs, in which your query becomes something like
>
> <esql:query>
> select * from foo
> where foo_date <
> <esql:parameter><xsp:expr>datevar</xsp:expr></esql:parameter>
> </esql:query>
>
> That being said, I've had trouble doing this with date values but
> instead of looking for a 'proper' solution just did format conversion
> and passed strings...
>
> HTH,
> Anderson
>
> On 7/6/2004 1:05 PM, Terry Brick wrote:
>
> > Anyone?
> > Am I the only one attempting serious database back-end work with cocoon?
> >
> > --- Terry Brick <[EMAIL PROTECTED]> wrote:
> >
> >>Looking through the doc and the source code, I don't see that it's possible to use
> >>standard
> JDBC
> >>query parameter binding. I would've expected to be able to do something like
> >>this...
> >>
> >><query>
> >>select * from foo where foo_date < ?
> >><param type="date" value="${datevar}"/>
> >></query>
> >>
> >>.... or something along those lines.
> >>
> >>Is something like this possible? If not, I would conside the SqlTransformer thing
> >>not ready
> for
> >>prime time.... what would be the suggested approach (besides implementing an
> >>entirely custom
> >>approach, which I AM leaning toward at this point)?
> >>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
