markup HTML query help

[JasonMcConnell]

Hi

I have the following query that publishes the results to a HTMl file.

How can I make this not publish the query at the top of the HTMl file?

Also every 14 rows it publishes table headings

e./g Application Number, Application type Development address etc? How can I only make it publish this once only (at the top of the table)

set markup HTML on
spool c:\TEST.html
SELECT "PA_VIEW"."APPLICATION_NUMBER", "PA_VIEW"."APPLICATION_TYPE", "PA_VIEW"."DEVELOPMENT_ADDRESS", "PA_VIEW"."DEVELOPMENT_DESCRIPTION", "PA_VIEW"."WARD", "PA_VIEW"."RECEIVED_DATE", "PA_VIEW"."SYS_STATUS"
FROM "LAND"."PA_VIEW" "PA_VIEW"
WHERE ("PA_VIEW"."RECEIVED_DATE between
TO_TIMESTAMP('2007-07-01 00:00:00.00','YYYY-MM-DD HH24:MI:SS.FF2') and TO_TIMESTAMP('2007-07-04 00:00:00.00','YYYY-MM-DD HH24:MI:SS.FF2') AND ("PA_VIEW"."SYS_STATUS"='4' OR "PA_VIEW"."SYS_STATUS"='7');
spool off
set markup HTML off



Thanks for your help

 

[Dagon]

Some of these settings may help:

set pagesize 0
set echo off
set feedback off
set heading off
set trimspool on

 

[JasonMcConnell]

Hi Dagon

This has helped but the query still appears at the top of the HTML file?

 

[hoinz]

Not sure if it can be done that way.
As a workaround you might consider to run your select from a script stored in another file.
thread759-1347631 may be helpful.

 

[Beilstwh]

You have to run a script. Even with echo off running your script by typing it in will always spool it to the spool file.

Bill
Oracle DBA/Developer
New York State, USA