cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Matthew Cordes <mcord...@maine.edu>
Subject Re: ESQL installation
Date Wed, 06 Dec 2000 06:46:25 GMT
Donald, 

Thanks for the help.

You were right, the org.apache.turbine.services.db.PoolBrokerService 
class was there, I was inadvertantly viewing an older cvs branch 
via the ViewCVS interface.  My mistake.

-matt

On Wed, Dec 06, 2000 at 12:52:33AM -0500, Donald Ball wrote:
> On Wed, 6 Dec 2000, Matthew Cordes wrote:
> 
> > I too would like to know this as well as:
> >
> > 	1.	Is the version of esql supplied with cocoon-1.8 out of date?
> 
> yes.
> 
> >
> > 	2.	Can the cvs version simply be added to cocoon-1.8 ( when I tried
> > 	this it requires
> > org.apache.turbine.services.db.PoolBrokerService
> > 	which doesn't appear to be part of turbine-pool.jar (even the cvs
> > 	version ).
> 
> yes it can, and the turbine-pool.jar in cvs certainly does contain this
> class.
> 
> > 	3.	Does the version of esql supplied with 1.8 allow one to
> > 	insert/update as well as select from db? If so, could you
> > 	post some sample code?
> 
> yes.
> 
> <esql:connection>
>   ...
>   <esql:execute-query>
>     <esql:query>insert into my_table (id,name) values (
>       <esql:parameter type="int">1</esql:parameter>,
>       <esql:parameter><request:get-parameter name="name"/></esql:parameter>
>     </esql:query>
>     <esql:update-results>
>       <message>there were <esql:get-update-count/> rows updated</message>
>     </esql:update-results>
>   </esql:execute-query>
> </esql:connection>
> 
> (note i just checked in support for esql:get-update-count - i'd
> inadvertantly left it out of cvs. note also that the esql:parameter
> elements are only if you want to use prepared statements - you can just as
> easily put expressions right inside the esql:query element, but you lose
> the type checking, conversion, and string escaping that comes with
> prepared statements).
> 
> - donald
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
> For additional commands, e-mail: cocoon-users-help@xml.apache.org
> 

Mime
View raw message