[FX.php List] NeoCache

[Stephe Pocock]

Hi all

Is anyone using this?  I use it a bit and have just tried to use it on a page where I have two arrays/finds

It results in the same returned results being displayed.

Does anyone know how I can use the cache twice on the same page?

<?php

define('DEBUG', FALSE); 

include_once("../FX/FX.php");
include_once('FXneocache/FXneocache.php');
include_once("../FX/server_data.php");
include_once("../FX/FMErrors.php");

$Group=$_REQUEST['Group'];

$cat2=new FXneocache($serverIP,$webCompanionPort,'FMPro7');
$cat2->setDBData('Events.fp7','PHPWeb', '500');
$cat2->SetDBUserPass('xxx', 'xxx');

$today = date("m/d/Y");

$cat2->AddDBParam('Group Lookup',$Group);
$cat2->AddDBParam('Status','Active');
$cat2->AddDBParam('CD Type','Court Date');
$cat2->AddDBParam('Task Date',$today);

$cat2->AddSortParam('Task Date','ascend');

$cat2Result=$cat2->FMCacheFind();
foreach ($cat2Result['data'] as $key => $cat2Data) ;



$cat=new FXneocache($serverIP,$webCompanionPort,'FMPro7');
$cat->setDBData('Events.fp7','PHPWeb', '500');
$cat->SetDBUserPass('xxx', 'xxx');

$tomdate = mktime(0,0,0,date("m"),date("d")+1,date("Y"));
$fromdate = date("m/d/Y", $tomdate);

$todate = mktime(0,0,0,date("m"),date("d")+14,date("Y"));
$nextdate = date("m/d/Y", $todate);

$cat->AddDBParam('Group Lookup',$Group);
$cat->AddDBParam('Status','Active');
$cat->AddDBParam('CD Type','Court Date');
$cat->AddDBParam('Task Date',$fromdate.'...'.$nextdate);

$cat->AddSortParam('Task Date','ascend');

$catResult=$cat->FMCacheFind();
foreach ($catResult['data'] as $key => $catData)

?>

Cheers

Stephen
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.iviking.org/pipermail/fx.php_list/attachments/20110622/f983b2a6/attachment-0001.html