Skip to Content
Former Member
Feb 06, 2012 at 06:23 AM

sql call


- <payload operations="">
- <MT_Outlettest_B1 xmlns="">
  <CreateDate />    
<DSTRB1 /> 
  <DSTRB2 />         
  <SCODE /> 
  <STATUS /> 
  <query id="httpheader.???" value="" /> 
- <Payload Role="C" id="atom1" system="0010000117" mode="single" method="Automatic detection by key word(Automatic detection by key word)" sql="SELECT CreateDate, T0.[U_DSTRB], T0.[U_DSTRB],T0.[U_SCODE], T0.[U_STATUS], T0.[U_SALESORG] FROM "@CW_PJP" T0 where datename(dw,CreateDate) = 'Monday'" disable-output-escaping="false">
- <ResultSet xmlns="" rowCount="1">
- <Row>
  <CreateDate>2011-11-07 00:00:00.0</CreateDate> 
  <U_STATUS /> 

Here when i am using sql cal the data is taking from table but its not set in paload operation

I have used this function

						<xsl:value-of      select="/vpf:Msg/vpf:Body/vpf:Payload[./@Role='C' and ./@id='atom1']/jdbc:ResultSet/jdbc:Row/jdbc:createdate"></xsl:value-of>

but its not geting the value from result set of sql query.

Can any one help me?

Edited by: Sinha_Sinha on Feb 8, 2012 5:27 AM