DbHandle)) { // SQL $sql="-- references select decode(reference_type, 'Journal Article', '' || Author || ' (' || Year ||') ' || Title || '. ' || Secondary_Title || decode(volume,null,'', ', ' || Volume || decode(issue,null,'', ' (' || Issue ||')') || ': ') || Pages || '.', 'Book Section', '' || Author || ' (' || Year ||') ' || Title || '. ' || 'In: ' || decode(secondary_author,null,'', secondary_author || ' (ed.) ') || Secondary_Title || ', ' || decode(tertiary_author,null,'', tertiary_author || ' (ed.) ') || decode(tertiary_title,null,'', tertiary_title || ', ') || decode(publisher,null,'', publisher || ', ') || decode(place_published,null,'', place_published || ', ' ) || decode(volume,null,'', ', ' || Volume || decode(issue,null,'', ' (' || Issue ||')') || ': ') || decode(instr(Pages,'-'),0, Pages || ' p', Pages) || '.', 'Book', '' || Author || ' (' || Year ||') ' || Title || '. ' || decode(secondary_author,null,'', secondary_author || ' (ed.) ') || decode(secondary_title,null,'', Secondary_Title || ', ' ) || decode(tertiary_author,null,'', tertiary_author || ' (ed.) ') || decode(tertiary_title,null,'', tertiary_title || ', ') || decode(publisher,null,'', publisher || ', ') || decode(place_published,null,'', place_published || ', ' ) || decode(volume,null,'', ', ' || Volume || decode(issue,null,'', ' (' || Issue ||')') || ': ') || decode(instr(Pages,'-'),0, Pages || ' p', Pages) || '.', 'Conference Proceedings', '' || Author || ' (' || Year ||') ' || Title || '. ' || decode(secondary_title, null, '', 'In: ' || decode(secondary_author,null,'', secondary_author || ' (ed.) ') || Secondary_Title || ', ' ) || decode(tertiary_author,null,'', tertiary_author || ' (ed.) ') || decode(tertiary_title,null,'', tertiary_title || ', ') || decode(date_conference,null,'',date_conference || ', ') || decode(place_published,null,'', place_published || ', ' ) || decode(publisher,null,'', publisher ) || decode(volume,null,'', ', ' || Volume || decode(issue,null,'', ' (' || Issue ||')') || ': ') || decode(instr(Pages,'-'),0, Pages || ' p', Pages) || '.', 'Thesis', '' || Author || ' (' || Year ||') ' || Title || '. ' || decode(secondary_title,null, '', Secondary_Title || ', ' ) || decode(tertiary_author,null,'', tertiary_author || ' (ed.) ') || decode(tertiary_title,null,'', tertiary_title || ', ') || decode(publisher,null,'', publisher || ', ') || decode(place_published,null,'', place_published || ', ' ) || decode(volume,null,'', Volume || decode(issue,null,'', ' (' || Issue ||')') || ': ') || decode(instr(Pages,'-'),0, Pages || ' p', Pages) || '.', '' || Author || ' (' || Year ||') ' || Title || '. ' || decode(secondary_author, null, '', 'In: ' || decode(secondary_author,null,'', secondary_author || ' (ed.) ') || Secondary_Title || ', ' ) || decode(tertiary_author,null,'', tertiary_author || ' (ed.) ') || decode(tertiary_title,null,'', tertiary_title || ', ') || decode(date_conference,null,'',date_conference || ', ') || decode(place_published,null,'', place_published || ', ' ) || decode(publisher,null,'', publisher ) || decode(volume,null,'', ', ' || Volume || decode(issue,null,'', ' (' || Issue ||')') || ': ') || decode(instr(Pages,'-'),0, Pages || ' p', Pages) || '.') || decode(url, null, '', decode(doi,null,' [ >>> ] ', '')) || decode(doi, null, '', ' [' || doi || '] ') as ref from waldner.lwf_publications where year is not null \n"; $sql=$sql." and record_number=".$ref."\n"; echo ""; echo "

Abstract

\n"; $Db->HtmlReport($sql,"h4"); echo "

Keywords\n"; echo "

\n"; $Db->HtmlReport("select keywords from waldner.lwf_publications where record_number=".$ref); echo "

\n"; echo "

Abstract\n"; echo "

\n"; $Db->HtmlReport("select abstract from waldner.lwf_publications where record_number=".$ref); echo "

\n"; echo "

LWF Classification\n"; echo "

\n"; $Db->HtmlReport("select decode(label,null,'','Network: ' || label || ', ') || decode(custom_7,null,'','Sites: ' || custom_7 || ', ') || decode(custom_8,null,'','Category: ' || custom_8 || ', ') from waldner.lwf_publications where record_number=".$ref); echo "

\n"; } ?>