get value from table cache(a,b,c,d)
|
Group |
Returns the value of a table cache a with primary key b and column c.
If no value is found, the default value d is returned.
Description of Parameters
|
Parameter |
Description |
|
a |
Name of cache. |
|
b |
Primary key (the first column). |
|
c |
Column name. |
|
d |
Default value. |
Examples
Defined is a table cache article with the values {id=100, name=mobile phone, supplier_Id=4711} and the table cache supplier with the values {id=4711, supplier_name=The Supplier's Ltd,supplier_country=IvoryCoas}.
|
Parameter a |
Parameter b |
Parameter c |
Parameter d |
Result |
|
article |
100 |
name |
not available |
mobile phone |
|
article |
1000 |
name |
not available |
not available |
|
article |
100 |
supplier_Id>supplier_country |
not available |
Ivory Coast |