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
Last revisionBoth sides next revision
reference:cacheexecute [2015/11/24 20:17] mnewnhamv5:reference:connection:cacheexecute [2016/05/15 15:26] – [Description] 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:errormsg|errorMsg()]].
 ==== Usage ==== ==== Usage ====
 <code php> <code php>
v5/reference/connection/cacheexecute.txt · Last modified: 2016/05/15 15:27 by mnewnham