Christopher,
IIUC, you need substitution: go to
http://xml.apache.org/cocoon/userdocs/transformers/sql-transformer.html and look for
the
"Substitution" topic
Regards,
---------------------------------------------
Luca Morandini
GIS Consultant
[EMAIL PROTECTED]
http://utenti.tripod.it/lmorandini/index.html
---------------------------------------------
> -----Original Message-----
> From: Delis, Christopher E. [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 18, 2003 1:53 AM
> To: Delis, Christopher E.; ''[EMAIL PROTECTED]' '
> Subject: sql transformer question; *not* esql... (was RE: ???ESQL update
> table???)
>
>
> i replied to the wrong topic. sorry... what i meant to ask was: is there
> a "place-holder" mechanism available using the sql transformer? --chris
>
> -----Original Message-----
> From: Delis, Christopher E.
> To: '[EMAIL PROTECTED]'
> Sent: 3/17/03 9:48 AM
> Subject: RE: ???ESQL update table???
>
> on a slightly different note, is there "place-holder" functionality in
> esql
> stylesheet language? e.g.,
>
> insert into atable (field1, field2) values (?, ?)
> select * from atable where field1 = ? limit ?
> ...
>
> TIA,
> chris
>
>
> > -----Original Message-----
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> > Sent: Friday, March 14, 2003 9:20 AM
> > To: [EMAIL PROTECTED]
> > Subject: ???ESQL update table???
> >
> >
> > Hi,
> > This is a part of a query. My problem is that when I make a
> > SELECT right
> > after an INSERT I don't get the last updated query :
> >
> > ---------------------------
> > <esql:execute-query>
> > <esql:query>
> > INSERT INTO Actions (at_name, at_order)
> > VALUES ('<esql:get-string column="at_name" ancestor="1"/>',
> > <xsp:expr>nouvOrder</xsp:expr>)
> > </esql:query>
> > <esql:update-results/>
> > </esql:execute-query>
> >
> > <esql:execute-query>
> > <esql:query>
> > SELECT TOP <xsp:expr>myTopCnt</xsp:expr> * FROM Actions
> > WHERE at_order = <xsp:expr>myOrderID</xsp:expr>
> > ORDER BY at_id DESC
> > </esql:query>
> > <esql:results>
> > <esql:row-results>
> > <xsp:logic>
> > nouvActionName = <esql:get-string column="at_name"/>;
> > </xsp:logic>
> > </esql:row-results>
> > </esql:results>
> > </esql:execute-query>
> >
> > <esql:execute-query>
> > <esql:query>
> > SELECT TOP 1 * FROM Actions
> > WHERE at_name = '<xsp:expr>nouvActionName</xsp:expr>'
> > ORDER BY at_id DESC
> > </esql:query>
> > <esql:results>
> > <esql:row-results>
> > <xsp:logic>
> > nouvAction = <esql:get-int column="at_order"/>;
> > </xsp:logic>
> > </esql:row-results>
> > </esql:results>
> > </esql:execute-query>
> > -------------------------------
> > What I mean is that in the last "execute-query" the value
> > "<esql:get-int
> > column="at_order"/>" returns a value, but in my SQL Profiler I get a
> > query witch returns another value (the right)!!!!
> > I think that it is due to the refreshing from the insert, because the
> > insert value is queried!
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
