I’m trying to use memcached to store the result sets of my DB calls, but it doesn’t seem to want to save the result set object that I’m using. I can get memcached working fine to store objects, strings, etc.. I just can’t seem to get it to save the result set data type that I’m using. The code is as follows..
[CODE]
$strquery = “SELECT name, date FROM object”;
$rs = $db->Execute($strquery);
$memcache->set(md5($strquery), $rs, false, 100);
$rs = $memcache->get(md5($strquery));
while(!$rs->EOF)
{
$name = $rs->Fields[‘name’]->Value;
$date = $rs->Fields[‘date’]->Value;
echo $name . “<BR>”;
$rs->MoveNext();
}
$rs->Close();
Basically once is gets to the line “while(!$rs->EOF)”, it throws this error:
[QUOTE]
Fatal error: Uncaught exception ‘com_exception’ with message ‘this variant has no properties’
I’m using the ADODB object for DB connection..