select *
from faculty_staff as a
where a.homepage_ind = 1
select faculty_id
from faculty_staff
where last_name = 'Hadzikadic'
select *
from faculty_staff as a, departments as b
where a.homepage_ind = 1
and a.department_id = b.department_id
and faculty_id = #profid#
select *
from fac_lab as a, lab_lookup as b
where faculty_id = #qryFac.faculty_id#
and a.lab_id = b.lab_id
select *
from fac_research as a, research_lookup as b
where faculty_id = #qryFac.faculty_id#
and a.research_id = b.research_id
select *
from fac_institute as a, institute_lookup as b
where faculty_id = #qryFac.faculty_id#
and a.institute_id = b.institute_id
select *
from news_events
where view_start_date < #now()#
and view_end_date > #now()#
order by date_entered DESC
select *
from spotlights
order by spotlight_order ASC;
select link_id
from fac_infolink
where faculty_id = #profid#
and link_type = 'spotlights'
select *
from articles
where unit='COIT'
and homepage_position IS NOT NULL
order by homepage_position
select *
from dirListing
where name NOT IN ('Thumbs.db', '_vti_cnf')
<cfoutput>#application.title#</cfoutput>
background="images/coit_global_bg.gif" marginheight="0" topmargin="0" onResize="reloadWin();">
>
College of Computing and Informatics
9201 University City Blvd, Charlotte, NC 28223
