Watershed Bibliography
Log-in
|
Bibliography
:
Watershed Bibliography
Top Menu
Show
:
Comments
Attachments
History
Information
Print
:
Print
Print preview
Export as PDF
Export as RTF
Export as HTML
Export as XAR
Wiki code for
Watershed Bibliography
Hide Line numbers
1: 1 Watershed Bibliography 2: 3: #set($selectedarea = $request.getParameter("area")) 4: #set($selectedsubject = $request.getParameter("subject")) 5: #set($areaids = $xwiki.DBPlugin.getArrayListFromQuery("Bibliography","SELECT distinct(StudyAreaID) FROM studyarealist ORDER By StudyAreaID")) 6: #set($sids = $xwiki.DBPlugin.getArrayListFromQuery("Bibliography","SELECT distinct(SubjectID) FROM subjectlist Order By SubjectID")) 7: 8: <form action="" method="get"> 9: <input type="hidden" name="search" value="1"> 10: <table> 11: <tr> 12: <td align="right"> 13: Area: 14: </td> 15: <td> 16: <select name="area" size="1"> 17: #foreach ($id in $areaids) 18: <option value="$id" 19: #if ($selectedarea == $id) 20: selected 21: #end 22: > 23: $xwiki.DBPlugin.getStringValue("Bibliography","Select StudyArea From studyarea Where StudyAreaID = $id") 24: </option> 25: #end 26: </select> 27: </td> 28: </tr> 29: <tr> 30: <td align="right"> 31: Subject: 32: </td> 33: <td> 34: <select name="subject" size="1"> 35: #foreach ($id in $sids) 36: <option value="$id" 37: #if ($selectedsubject == $id) 38: selected 39: #end 40: > 41: $xwiki.DBPlugin.getStringValue("Bibliography","Select Subject From subject Where SubjectID = $id") 42: </option> 43: #end 44: </select> 45: </td> 46: </tr> 47: <tr> 48: <td colspan="2" align="center"> 49: <input type="submit" value="Search" /> 50: </td> 51: </tr> 52: </table> 53: </form> 54: 55: #if( $request.getParameter("search") ) 56: #tableFromDB("Bibliography", " 57: SELECT 58: R.ReferenceTitle As Title, 59: R.Summary 60: FROM 61: referenceauthors R, 62: studyarea A, 63: subject S 64: WHERE 65: A.StudyAreaID = $selectedarea 66: And A.StudyAreaID IN (SELECT StudyAreaID FROM studyarealist WHERE ReferenceTitleID = R.ReferenceTitleID) 67: And S.SubjectID = $selectedsubject 68: And S.SubjectID IN (SELECT SubjectID FROM subjectlist WHERE ReferenceTitleID = R.ReferenceTitleID) 69: ORDER BY 70: PublishedYear Desc;") 71: #end
Search
Quick Links
Home
Wiki Spaces
This Space Pages
Public Calendar
Blog
What's New
Help