[-
# get data to pre-populate text fields use ICDP::dmzdb;
$maxrow = 2000; $dat = ICDP::dmzdb::executeSP("dw_kola..dw_SummaryLithounits", "MDY1_YYYY"); $asciifile = ICDP::dmzdb::exportAsASCII($dat, "/sites/kola/tmp", "\t"); $csvfile = ICDP::dmzdb::exportAsCSV($dat, "/sites/kola/tmp", ","); ICDP::dmzdb::replaceNULL ($dat, "n.a."); -]

Kola Superdeep Borehole Summary Lithological Report

---

download data in ASCII-Format or CSV-Format

visualise as graphical profile

[$ if $row == 0 $] [$ endif $]

UNIT	DEPTH INTERVAL(m)	GROUP	SUITE	TYPE	ROCK NAME
[+$dat->[$row]{LITHO_UNIT}+]	[+ sprintf "%.1f",$dat->[$row]{STARTING_DEPTH}+] - [+sprintf "%.1f", $dat->[$row]{ENDING_DEPTH}+]	[+$dat->[$row]{UNIT_CLASS}+]	[+$dat->[$row]{UNIT_SUITE}+]	[+$dat->[$row]{UNIT_TYPE}+]	[+$dat->[$row]{ROCK_NAME}+]