10 : <cfquery name="cekmhs" datasource="uwmakad">
11 : select nrp, nama, a.kodeunit, namaunit, level from ms_mahasiswa a, ms_unit b
12 : where a.kodeunit=b.kodeunit and level=2 and substring(nrp,1,1)='8' and b.kodeunit='#url.ckodeunit#'
13 : </cfquery>
14 : <cfquery name="cekyudisium" datasource="akademik">
|