[code] <?xml version='1.0'?> <?xm

[Lupo]

Hi,

first of all, i'am a beginner in xml/xsql. I have the following xsql statement. the result i need is ok. the problem i have. I would like to have a history file each time the xsql statement has been executed. the filename should something like "yyyymmddhhmm.xml" or any other filetype e.g. flat txt file. what do I have to change in the code below?

<?xml version='1.0'?>
<?xml-stylesheet type=&quot;text/xsl&quot; href=&quot;suppliers.xsl&quot; ?>
<page xmlns:xsql=&quot;urn:oracle-xsql&quot; connection=&quot;{@conn}&quot;>
  <General>  
	<IDJob>00000000-0000-0000-0000-000000000000</IDJob>   
	<IDUser>-1</IDUser>   
	<IDServer>-1</IDServer>   
	<IDAnswerType>1</IDAnswerType>   
	<AnswerAddress>NO</AnswerAddress>   
<xsql:query max-rows=&quot;-1&quot; 
            null-indicator=&quot;no&quot; 
            rowset-element=&quot;Generated&quot; >
SELECT TO_CHAR( SYSDATE, 'YYYY-MM-DD HH24:MI.SS' ) dummy from dual
</xsql:query>
  </General>
  <Schedule>  
	<Type>0</Type>   
  </Schedule>
  <Tasks>
	<Task>
	  <Reference>1</Reference>   
	  <ClassAlias>SupplierImport</ClassAlias>   
	  <Method>createSuppliers</Method>   
	  <Predecessors></Predecessors>   
<ParameterList>
<Suppliers>
<xsql:query max-rows=&quot;-1&quot; null-indicator=&quot;no&quot; tag-case=&quot;lower&quot;
            rowset-element=&quot;&quot;
            row-element=&quot;&quot;>
SELECT SYS_ID systemid
from organisations
</xsql:query>
<xsql:query max-rows=&quot;-1&quot; 
            null-indicator=&quot;no&quot; 
            tag-case=&quot;lower&quot;
            rowset-element=&quot;&quot; >
SELECT count(*) count 
from suppliers
where sup_stat IN ( '1', '2' )
</xsql:query>
<xsql:query max-rows=&quot;-1&quot; null-indicator=&quot;yes&quot; tag-case=&quot;lower&quot;
            row-element=&quot;Supplier&quot;
            rowset-element=&quot;&quot;
            id-attribute=&quot;&quot;
            id-attribute-column=&quot;&quot;
>
SELECT sup_id id, 
       name,
       cursor ( select addr_1 line1,
                       addr_2 line2,
                       addr_3 line3,
                       addr_4 line4,
                       pstl_distct location,
                       post_cd code,
                       jur_jur_id country,
                       e_mail_addr email,
                       tel_no phone,
                       fax_no fax,
                       cntct_name contact
                from addresses addresses
                WHERE sup_id = addr_for
                AND   addr_type = '4'
                AND   addr_clsn = '1' ) as address
from suppliers supplier
where sup_stat IN ( '1', '2' )
</xsql:query>
</Suppliers>  
</ParameterList>
<ResultList></ResultList>
</Task>  
</Tasks>  
<Maps></Maps>
</page>

thankis in advance in for any help.
regards
WEB Designer & WEB Developer (as per my working contract) and ASP Newbie

 

[Lupo]

Thanks for your help!

WEB Designer & WEB Developer (as per my working contract) and

 

[Cagliostro]

You're welcome [LOL]

Ion Filipski

 

[Lupo]

Don't mention it! I am always at your service!

Lupo


WEB Designer & WEB Developer (as per my working contract) and