SELECT

Method Name Arguments Description Default Contents Example Usage
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>
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>
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>
 
PRE_SELECT   The method is called just before SELECT query. Method does not exist by default. See data/public/logs_report.mql
  $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        
Topic revision: r8 - 22 Apr 2018, GuidoBrugnara
This site is powered by FoswikiCopyright (©) Leader.IT - Italy P.I. IT01434390223 Privacy policy & use of cookies