I'm trying to modify a trigger on one of my tables and I keep getting
the message "Unsupported Column Type: 0".

What does this mean and how do I fix it? Please tell me it's
something I'm doing wrong and it's easliy fixed.

Thanks,
Ryan

The original trigger code is this:
...
as
declare variable memid integer;
begin
for
select memberid
from organizationmember
where organizationid = new.organizationid and
memberwantsemails = 1 and
memberstatus >= 1 and
memberid not in (select memberid
from emailjobstats
where emailjobid = new.emailjobid)
into :memid
do
begin
insert into emailjobstats (emailjobid, memberid)
values (new.emailjobid, :memid);
end
end


The new code I'm trying to compile is this:
.....
as
declare variable memid integer;
DECLARE VARIABLE wisjot smallint;
DECLARE VARIABLE wwantsjot smallint;
BEGIN
SELECT isjot
FROM emailjobs
WHERE emailjobid = new.emailjobid
INTO :wisjot;

for
select memberid,
memberwantsjot
from organizationmember
where organizationid = new.organizationid and
memberwantsemails = 1 and
memberstatus >= 1 and
memberid not in (select memberid
from emailjobstats
where emailjobid = new.emailjobid)
into :memid, :wwantsjot
do
BEGIN
IF (((wisjot=1) and (wwantsjot=1)) or (wisjot=0)) then
begin
INSERT into emailjobstats (emailjobid, memberid)
values (new.emailjobid, :memid);
end
end
END