{sql : select * from cat_archive
where cat_archive.ern = @enter ERN@
}

Dyfed Archaeological Trust,

Corner House,

6 Carmarthen Street,

Llandeilo,

Carmarthenshire,

SA19 6AE
Tel (01558) 823131, Email info@dyfedarchaeology.org.uk


{subtable
SELECT cat_archive.ern,
ifnull(cat_archive.project_title,' ') as P1,
ifnull(cat_archive.related_prns,' ') as rel_1,
ifnull(cat_archive.related_nprns,' ') as rel_2,
ifnull(cat_archive.related_sms,' ') as rel_3,
ifnull(cat_archive.related_lbs,' ') as rel_4,
ifnull(cat_archive.other_ref_nos,' ') as rel_5,
cat_archive.ngr,
cat_archive.site_name_and_address,
ifnull(cat_archive.site_types,' ') as type_1,
ifnull(cat_archive.project_types,' ') as type_2,
cat_archive.client,
cat_archive.project_manager,
cat_archive.project_date,
cat_archive.categories_present,
cat_archive.location_digital as location1,
cat_archive.accession_no as accession1,
cat_archive.copyright_digital as copyright1,
cat_archive.access_restrictions as access1,
cat_archive.paper_location as location2,
cat_archive.accession_no_paper as accession2,
cat_archive.copyright_paper_archive as copyright2,
cat_archive.paper_access_restriction as access2,
cat_archive.location_finds as location3,
cat_archive.accession_no_finds as accession3,
cat_archive.copyright_finds_archive as copyright3,
cat_archive.access_restrictions_finds as access3
from cat_archive
where cat_archive.ern=[ern]
group by cat_archive.ern;

title[b]ERN[/b] ,ern,  [br][b]Project Title[/b] ,P1, [br][b]Related PRNs[/b] ,rel_1, [br] [b]Related NPRNs[/b] ,rel_2, [br][b]Related SM Nos[/b] ,rel_3,  [br][b]Related LB Nos[/b] ,rel_4, [br][b]Other related ref nos[/b] ,rel_5, [br][b]NGR[/b] ,ngr, [br][b]Site Name and Address[/b] ,site_name_and_address, [br][b]Site type/s[/b] ,type_1, [br][b]Projecttype/s[/b] ,type_2, [br][b]Client[/b] ,client, [br][b]Project Manager[/b] ,project_manager, [br][b]Project dates[/b] ,project_date, [br][b]Categories present from archive index[/b] ,categories_present, [br][b]Location of digital archive[/b] ,location1, [br][b]Accession No of digital archive[/b] ,accession1, [br][b]Copyright of digital archive[/b] ,copyright1, [br][b]Restrictions on access to digital archive[/b] ,access1, [br][b]Location of paper archive[/b] ,location2, [br][b]Accession No of paper archive[/b] ,accession2, [br][b]Copyright of paper archive[/b] ,copyright2, [br][b]Restrictions on access to paper archive[/b] ,access2, [br][b]Location of finds archive[/b] ,location3, [br][b]Accession No of finds  archive[/b] ,accession3, [br][b]Copyright of finds archive[/b] ,copyright3, [br][b]Restrictions on access to finds archive[/b] ,access3, }