{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]Project type/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, }

Archive Index


{subtable :
SELECT cat_archive.ern,
ifnull(cat_archive.A_category,' ') as A,
ifnull(cat_archive.B_category,' ') as B,
ifnull(cat_archive.C_category,' ') as C,
ifnull(cat_archive.D_category,' ') as D,
ifnull(cat_archive.E_category,' ') as E,
ifnull(cat_archive.F_category,' ') as F,
ifnull(cat_archive.G_category,' ') as G,
ifnull(cat_archive.H_category,' ') as H,

ifnull(cat_archive.I_category,' ') as I,

ifnull(cat_archive.J_category,' ') as J,

ifnull(cat_archive.K_category,' ') as K,

ifnull(cat_archive.L_category,' ') as L,

ifnull(cat_archive.M_category,' ') as M,

ifnull(cat_archive.N_category,' ') as N
from cat_archive
where cat_archive.ern=[ern]
group by cat_archive.ern;

title:[b]A. REPORTS  -  [/b] ,A,  [br][b]B. SITE WRITTEN DATA  -  [/b] ,B, [br][b]C. DRAWINGS - NON-PUBLICATION -  [/b] ,C, [br][b]D. PHOTOGRAPHS -  [/b] ,D, [br][b]E. FINDS DATA -  [/b] ,E,  [br][b]F. ENVIRONMENTAL AND TECHNOLOGICAL DATA -  [/b] ,F, [br][b]G. DOCUMENTARY DATA -  [/b] ,G, [br][b]H. HUMAN REMAINS -  [/b] ,H, [br][b]I.  DRAFT REPORTS -  [/b] ,I, [br][b]J. PUBLICATION DRAWINGS -  [/b] ,J, [br][b]K. PUBLIC RELATIONS -  [/b] ,K, [br][b]L. PRE- AND POST-EXCAVATION DESIGN -  [/b] ,L, [br][b]M. CORRESPONDENCE -  [/b] ,M, [br][b]N. GENERAL MISCELLANEOUS -  [/b] ,N,  }