General developer forum

 
 
Picture of Hubert Chathi
Re: get_records_sql
 

Aside from the semicolon that made your query fail, you also should not be hard-coding the "mdl_" table prefix; you should wrap your table names in braces.  So, instead of, for example, "mdl_role_assignments", write "{role_assignments}".

 
Average of ratings:Useful (2)