Gabriele I think I suffered a bit of a brainstorm - I am sure that environment variables are displayed :-) What I tested with was %Date% - of course this isnt a variable but interpreted by the command processor and so didnt work. It would be very nice if these dummy env vars were mimicked by LogParser...

? Graham, environment variables are supposed to work in an LPHEADER: <LPHEADER> %COMPUTERNAME% </LPHEADER> .... This gives my computer name in the output.....are you saying it does not work for you? Can you send me the tpl file you've used for the test? Also, what do you have in mind exactly...

selavie This is what the LPHEADER does -- but Ive just run a test and environment variables dont work here The easiest thing is to take a leaf out of the excellent Logparser book the sample chapter 5 (availaible from the front page of the site) is the one you want to look at - and write part of the output...

I guess I'm not too familiar with the template output format. My real question is that I would like to be able to output a variable in the LPHEADER section. An example of template: %myTitle% %myTitle% How can I specify the 'myTitle' variable in my script file so that it displays in the HTML file only...

Selavie: what would LPTITLE look like? Can't you do that in an LPHEADER?

You know what would be really useful LPGROUPHEADER and LPGROUPFOOTER -- to be output at the start and end of each and every Group By set of records Graham

The template feature is really nice. It has the LPHEADER, LPBODY, and LPFOOTER. When can we expect a LPTITLE? How can we have something similar in Logparser now? thanks.

You could modify your query and add "SYSTEM_TIMESTAMP()" to the SELECT clause and then specify this field in the template file; however, you'll end up with the timestamp for each record. 2.2 will give you the possibility to specify environment variables in the .tpl file.

I would like to know if there is a way to add a time stamp to a template file? I have a template file and I want to add the date the query was run.

2.2 will be out in a month or so. Yes, 2.2 will be able to parse NCSA, NCSA Extended, and NCSA Combined log files. ------------------------------ This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www...