ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:reference:connection:cacheexecute

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
reference:cacheexecute [2015/08/02 18:05] – [Description] mnewnhamv5:reference:connection:cacheexecute [2016/05/15 15:27] (current) – [Result] mnewnham
Line 2: Line 2:
 ~~NOTOC~~ ~~NOTOC~~
 <WRAP right tip> <WRAP right tip>
-Use of [[reference:adodb_fetch_mode|$ADODB_FETCH_MODE]] and [[reference:setfetchmode|setFetchMode()]] is incompatible with use of cached result sets as the results of the cached query are stored using the original fetch mode settings.+Use of [[v5:reference:adodb_fetch_mode|$ADODB_FETCH_MODE]] and [[v5:reference:connection:setfetchmode|setFetchMode()]] is incompatible with use of cached result sets as the results of the cached query are stored using the original fetch mode settings.
 </WRAP> </WRAP>
 <WRAP right box> <WRAP right box>
Line 16: Line 16:
  
   - If the first parameter passed is a positive integer, then the query cache is searched for a matching query cached within that period. If no matching cache file is found, A new statement is executed and cached.   - If the first parameter passed is a positive integer, then the query cache is searched for a matching query cached within that period. If no matching cache file is found, A new statement is executed and cached.
-  - If the first parameter is the SQL statement, the query cache default is used [[reference:local_cache#default_ cache_secs|$cacheSecs]]+  - If the first parameter is the SQL statement, the query cache default is used [[v5:userguide:local_cache#default_ cache_secs|$cacheSecs]]
  
 ===== Parameters ===== ===== Parameters =====
Line 34: Line 34:
  
 ==== Result ===== ==== Result =====
-If the execution succeeds, it returns a recordset. This recordset can be used by functions such as [[reference:getupdatesql|getUpdateSQL()]] or [[reference:fetchrow|fetchRow()]]. +If the execution succeeds, it returns a recordset. This recordset can be used by functions such as [[v5:reference:connection:getupdatesql|getUpdateSQL()]] or [[v5:reference:recordset:fetchrow|fetchRow()]]. 
-if the execution fails, it returns false. You can access errors using [[reference:errormsg|errorMsg()]].+if the execution fails, it returns false. You can access errors using [[v5:reference:connection:errormsg|errorMsg()]].
 ==== Usage ==== ==== Usage ====
 <code php> <code php>
Line 50: Line 50:
                          
 </code> </code>
 +{{tag>[cache]}}
                    
v5/reference/connection/cacheexecute.1438531509.txt.gz · Last modified: 2017/04/21 11:36 (external edit)