thanks! i am so embarassed. ;-) i gazed right past that little paragraph... sheesh!
-----Original Message----- From: Luca Morandini To: [EMAIL PROTECTED] Sent: 3/18/03 1:15 AM Subject: RE: sql transformer question; *not* esql... (was RE: ???ESQL update table???) 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
