cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Terry Brick <terry_brick2...@yahoo.com>
Subject Re: Can't bind query parameters in SQLTransformer??
Date Tue, 06 Jul 2004 22:20:21 GMT
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" <avitous@avitous.net> 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 &lt; 
> <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 <terry_brick2000@yahoo.com> 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: users-unsubscribe@cocoon.apache.org
> For additional commands, e-mail: users-help@cocoon.apache.org
> 
> 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org


Mime
View raw message