>
>> I've been trying to compile my BLB (Business Logic Bean) and have been
>> getting errors during compilation.  I haven't a clue as to how I could
>> debug this.  Any assistance would be appreciated.
>>
>

ResultSet rs =
stmt.executeQuery("SELECT FACIL_ID, FACIL_NAME, FACIL_NAME_SHORT, ORG_ID
FROM FACILITY WHERE FACIL_ID = '" + facilId + "'");

Change that line to:

rs =
stmt.executeQuery("SELECT FACIL_ID, FACIL_NAME, FACIL_NAME_SHORT, ORG_ID
FROM FACILITY WHERE FACIL_ID = '" + facilId + "'");

You can not redeclare a variable in the same scope.

The way you were trying to do it was have two variables called rs in the
same scope, the ammendment, simply replaces one resultset with another, for
the object reference - rs.

--
Mike W


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to