Differences

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

Link to this comparison view

Both sides previous revision Previous revision
nshd:approved2018onwards [17/05/2018 @ 11:09]
adammoore
nshd:approved2018onwards [02/10/2018 @ 13:07] (current)
p.curran Needed database qualification on table name
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>​
 ---- ----