RE: esql logicsheet, insert, update and delete, examples

[JEULIN Olivier]

> > I'll send you an example in a few minutes (I'm not sure the 
> rest of the
> > mailing list would be interested)
> 
> I would

OK, then:
this an old file I made to test something in the xml fragment I read from
the DB, and I've changed a few things between the working version and this
one.
It's a kind of draft, so don't take it too seriously
Anyway, the queries were OK when I first tested this file, and that's what
you're looking for.

Olivier








http://www.apache.org/1999/XSP/Core";
xmlns:auth="http://ulim.cocoonhost.com/auth";
xmlns:request="http://www.apache.org/1999/XSP/Request";
xmlns:session="http://www.apache.org/1999/XSP/Session";
xmlns:foo="http://localhost/foo";
xmlns:common="http://localhost/common";
xmlns:fragmentation="http://localhost/fragmentation";
xmlns:esql="http://apache.org/cocoon/SQL/v2";
xmlns:util="http://www.apache.org/1999/XSP/Util";
xmlns:xinclude="http://www.w3.org/1999/XML/xinclude";
>

localhost.basket.Basket


 
public Basket basket;






(Boolean)
(Boolean)





if ( != null)
{   
if (
!= null 
 != null 
 != null 
 != null ) {
try {
if
(Integer.parseInt((String)) > 0) {
// nouvelle commande de ce
produit
if
( == null) {
basket = new
Basket(5);
} else {
basket =
(Basket);
}

float promo;
try {
promo =
Float.parseFloat((String));
} catch
(NumberFormatException exc) {
promo =
Float.parseFloat((String));
}
basket.addProduct(

Integer.parseInt((String)),

(String),

Integer.parseInt((String)),

Float.parseFloat((String)),
promo
);

basket;

} else {
// supprime la commande de
ce produit

}
} catch (NumberFormatException exc)
{
// ne fait rien
}
}




foo

  
select p.promotion as promo,
p.reference as ref
from newprice p
  

  
 




 
  





foo

  
select b.reference as ref,
b.quantity as nb
from basket b
where
b.user=''
and b.idtitle =
Integer.parseInt((String))
  

  
 

Re: esql logicsheet, insert, update and delete, examples

[Hubert NEOtyk Iwaniuk]

- Original Message - 
From: "JEULIN Olivier" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 09, 2001 3:43 PM
Subject: RE: esql logicsheet, insert, update and delete, examples


> I'll send you an example in a few minutes (I'm not sure the rest of the
> mailing list would be interested)

I would

> 
> > does anybody have any examples where you insert, update and 
> > delete records
> > in databases, using xsp and esql logicsheet?
> 
> -
> Please check that your question has not already been answered in the
> FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
> 
> To unsubscribe, e-mail: <[EMAIL PROTECTED]>
> For additional commands, e-mail: <[EMAIL PROTECTED]>
> 
> 


---
Ausgehende Mail ist zertifiziert virenfrei.
Uberpruft durch AVG Antivirus System (http://www.grisoft.com/de).
Version: 6.0.265 / Virendatenbank: 137 - Erstellungsdatum: 2001-07-18


-
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>

RE: esql logicsheet, insert, update and delete, examples

[JEULIN Olivier]

I'll send you an example in a few minutes (I'm not sure the rest of the
mailing list would be interested)

> does anybody have any examples where you insert, update and 
> delete records
> in databases, using xsp and esql logicsheet?

-
Please check that your question has not already been answered in the
FAQ before posting. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>

esql logicsheet, insert, update and delete, examples

[annemarie . hartvigsen]

Hi,

does anybody have any examples where you insert, update and delete records
in databases, using xsp and esql logicsheet?

/AM

-
Please check that your question has not already been answered in the
FAQ before posting. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>