DbmsLibrarySelectMethods < MasonSQL

Method Name	Arguments	Description	Default Contents	Example Usage
`EVAL_WHERE`		Evaluates the query provided by the browser. It is called from SelectWhere() to check the SQL query for unauthorized access (sql injection).	Method does not exist by default.
	`$where`	The parameter contains the query from the browser.
`SELECT_WHERE`		Is passed to the EvalSqlWhere().	`<%method SELECT_WHERE> <&SELF:WHERE&> </%method>`
	`$PARAMS`	The argument contains optional parameters for the prepared query.
	`$ID`		Parameter undefined by default. When defined it is compared to `<&SELF:KEY&> = <% encodeSql($ID)`
	`$WHERE`	WHERE statement.
`DIV_SELECT`
`SELECT_FIELDS`		A list of fields to be inserted into table's `select` query.	`<%method SELECT_FIELDS> <&SELF:FIELDS&> </%method>` By default identical to the `FIELDS` method.	`<%method SELECT_FIELDS> nome, cognome, codice_fiscale, descrizione, indirizzo, provincia, citta, tel1, tel2, cell_sms, email, login, '' as password, no_psw_expiration </%method>`
`PRE_SELECT`		The method is called just before SELECT query.	Method does not exist by default.	See `data/public/logs_report.mql`
`JOIN_TABLES`		Is used for defining additional join clauses.	`<%method JOIN_TABLES> <&SELF:SCHEMA_FROM&> </%method>`	See `data/public/messages_users_detail.mql` and `data/public/user_messages.mql`
`WHERE`		A contents of WHERE statement.	Empty.	`<%method WHERE> zone.id_coordinatore = soci.id </%method>`

Topic revision: r8 - 22 Apr 2018, GuidoBrugnara