Technical Documentation

Show a record

 
Submit data …
ID 201
Category string: SQL
Required no
Element $zz['fields'][n]['sqlorder']
Description
Description de
Example
Default value
Mother ID $zz['fields'][n] | [10]
Relation
Updated 02 Jul 2011 17:57:09
IDCategoryReq.Element Action
423integerno$zz['fields'][n]['size_select_too_long'] if set, this will be the size of input if a select is not shown but input field instead

Relations: select

Show
405integerno$zz['fields'][n]['size'] Maximum length of characters that may be entered in input field, size of input field, standard for number 16, for time 8 and for all other fields 32 (or maxlength if smaller)Show
872arrayno$zz['fields'][n]['sql_character_set'] Character sets for fields in 'sql'-query (if different collations among the database are used); used for checking reselects

Relations: $zz['fields'][n]['sql']; select

Show
896arrayno$zz['fields'][n]['sql_fieldnames_ignore'] list of field names that will be ignored for checking a text input against a list of values from the database

Relations: select

Show
415arrayno$zz['fields'][n]['sql_ignore'] doesn't display fields of sql query in form view. this is useful if you need the fields for an identifier field; array, fields won't display in form view.

Relations: $zz['fields'][n]['sql']; select

Show
467booleanno$zz['fields'][n]['sql_index_only'] only show index field (e. g. for SHOW COLUMNS ... queries)

Relations: select

Show
787string: SQLno$zz['fields'][n]['sql_not_unique'] Detail records migh be shown with an n:m relation as well (read only). The SQL query for n:1 goes into the 'sql'-variable, the 1:m LEFT JOIN (or similar) has to go into the 'sql_not_unique' variable. Will be shown in record as well as in list view. Show
404string: SQLno$zz['fields'][n]['sql_password_check'] SQL query that is used to check if the given password equals the existing password

Relations: password_change

Show
873arrayno$zz['fields'][n]['sql_table'] Table names of fields in SQL query if not included in this query (to get correct character set for reselect)

Relations: $zz['fields'][n]['sql']; select

Show
958arrayno$zz['fields'][n]['sql_translate'] Allows translation for this table (or key => table or list of tables or keys and tables) with wrap_translate() from zzwrap library

Relations: $zz['sql']

Show
623booleanno$zz['fields'][n]['sql_where_with_id'] Adds WHERE (or AND)-clause with main_record_id = main_record_value to SQL query if there is a main_record_idShow
1002booleanno$zz['fields'][n]['sql_where_without_id'] Adds WHERE (or AND)-clause with main_record_id != main_record_value to SQL query if there is a main_record_idShow
413arrayno$zz['fields'][n]['sql_where'] adds where to sql-string, rather complicated ... :-) $zz['fields'][4]['sql_where'][1] = array( 'team_id', 'paarung_id', 'SELECT heim_team_id FROM ligen_paarungen WHERE paarung_id = '); Target: additional where-clause in sql-clause, e. g. WHERE team_id = 1 How to do it: - element [0] = field_name in WHERE-clause, e. g. team_id - element [1] = field_name which has to be queried - element [2] = SQL-clause where [1] is inserted to get value for [0] as result.

Relations: select

Show
414booleanno$zz['fields'][n]['sql_without_id'] where['id']-value will be appended automatically

Relations: select

Show
181string: SQLno$zz['fields'][n]['sql'] SQL-Query for select, first field is key field which will not be displayed but entered into database field

Relations: select

Show
946string: SQLno$zz['fields'][n]['sqlcount'] query which has to have something like `COUNT(record_id) AS record_id` in it to provide a faster alternative to querying several records up to max_select for counting all records available for a select field

Relations: $zz['fields'][n]['sql']; $zz_conf['max_select']

Show
201string: SQLno$zz['fields'][n]['sqlorder'] Show
299arrayno$zz['fields'][n]['subselect'] Displays records of detail tables in list view, allows to search through these detail tables as well. Key 'sql' is required, rest is optional.Show
302string: HTMLno$zz['fields'][n]['subselect']['concat_fields'] Show
301string: HTMLno$zz['fields'][n]['subselect']['concat_rows'] Show

916 records total

in