Re: Can't bind query parameters in SQLTransformer??

[Anderson J. Vitous]

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 <[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]