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

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,  }