nshd:approved2018onwards

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revisionBoth sides next revision
nshd:approved2018onwards [17/05/2018 @ 11:09] adammoorenshd:approved2018onwards [02/10/2018 @ 13:07] – Needed database qualification on table name p.curran
Line 5: Line 5:
  
 <datatables page-length="25" buttons='[ "copy", "csv", "print" ]' searching="true"> <datatables page-length="25" buttons='[ "copy", "csv", "print" ]' searching="true">
-<sql>select SQL_NO_CACHE projid as "Project ID", Year, papp as "Principal Applicant", title as "Title", summary as "Summary" from projects;</sql>+<sql>select SQL_NO_CACHE projid as "Project ID", Year, papp as "Principal Applicant", title as "Title", summary as "Summary" from dshare.projects;</sql>
 </datatables> </datatables>
 ---- ----
  
  • nshd/approved2018onwards.txt
  • Last modified: 17 months ago
  • by p.curran