SELECT * FROM project_info WHERE project_id = SELECT * FROM vw_project_researchers WHERE project_id = AND project_member = SELECT * FROM vw_project_researchers WHERE project_id = AND project_leader = <cfoutput query="get_info">#ucase('#project_id#')# - #Replace(title,"<br>","","all")#</cfoutput>


#get_info.title#  
SELECT * FROM project_info WHERE published = ORDER BY project_id Project Listing



Project ID Title
#project_id# #title# #project_id# #title#
There are no published projects at this time.