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]
