I have the following trigger:


CREATE TRIGGER TRIG_RAW_IPLINK_EVENT FOR RAW_IPLINK ACTIVE
AFTER INSERT OR UPDATE POSITION 1
AS
DECLARE VARIABLE iplink char(4);
DECLARE VARIABLE received varchar(40);
DECLARE VARIABLE eventstring varchar(44);
BEGIN
iplink = cast(new.IPLINK as char(4));


eventstring = 'RAW:' || iplink;
post_event eventstring;
END^


So, what I THINK happens - is on any insert or update (and on this table
it's only inserts) I should be generating events named RAW:1116, or
whatever iplink happens to be. new.iplink is a smallint that is always
4 digits.


Assuming I've got that part right - over in php land I have the
following. Obviously I'm doing something wrong - I just have no clue
what yet. The output of the below gives me my two sanity checks - but
nothing from the loop.


$iplink_node = 1116;
$dbh = ibase_connect( 'test.fdb', 'SYSDBA', 'masterkey', 'ASCII' );


echo "Database handler $dbh\n";


$evs = "RAW:$iplink_node";
echo "Event is $evs\n";


while ( $handler = ibase_wait_event( $dbh, "raw_line_handler" ) ) {
// just keep looping...just keep looping...
echo "$handler looped\n";
flush();
sleep(1);
}


function raw_line_handler( $event_name, $dbh ) {
$iplink_node = substr( $event_name, 4, 4 );


echo "iplink is $iplink_node\n";


$qs = "select first RAWLINE from RAW_IPLINK where IPLINK=? order by
RECEIVED desc";


$qh = ibase_query( $dbh, $qs, $iplink_node );


if ( $qh ) {
while ( $row = ibase_fetch_row( $qh ) ) {
echo $row[0];
}
}
return true;
}


--
Daniel