not a valid Sybase result resource

[alrotem]

Hi

I have a small script.
When I'm running it from the shell (as a cgi program)
I'm getting this error message:
<b>Warning</b>: 2 is not a valid Sybase result resource in <b>./runActions.php</b> on line <b>15</b><br>

when I'm running it from the browser I don't get any error.

anyway I don't have a line number 15 in my script at all.

[sepodati]

Can you post your script?

---John Holmes...

[alrotem]

The errors now are for line 24and 14...

#!/usr/local/bin/php
<?
include ("/tti/bp/infra/php/phpFunctions.php");

readStructedFile("/tti/palmTracker/config/palmTracker.const","const");

include("/tti/palmTracker/php/action.class");

$sybase = dbConnect(TRACKER_DATASERVER);

$dbName = TRACKER_DATABASE;

$result = sybase_query("select * from $dbName..TRACKER_ACTIVE_ALARMS",$sybase);

while ($row = sybase_fetch_array($result)){

  $currentDate = "'" . date("m/d/y H:i") . "'";

  $correlateTag = $row["CORRELATE_TAG"];

  $actionResult = sybase_query("select * from $dbName..TRACKER_ACTIONS
                                 where CORRELATE_TAG = '$correlateTag'
                                   and convert(datetime,$currentDate)  > dateadd(mi,CYCLE,TIME_STAMP)",$sybase) ;

  while ($actionRow = sybase_fetch_array($actionResult))
     $a = new action($actionRow["ACTION_NAME"],$row);

}
?>

[alrotem]

Hi ,
I found the problem

don't compile php with sybase-ct
only with sybase

Achi.