Borrower Notification Preferences

I'm trying to set up the system to send overdues by e-mail where the borrower has a preference.

I have added 'POST' and 'EMAIL' to the borrower analysis parameters, and I have set up a test overdue on a borrower with a preference of 'EMAIL', and added an e-mail address to his borrower record.

I have installed the local perl tool, GetBorrowerNotification.

I have set up a test ovedue script (based on the loa_odue_letter_ftr script which we use) and I have altered the select.pl to include:

-----------------------------------------
sub select
{
require "/users/report/mis/local_perl_tool/get_borrower_notification.pl";

GetBorrowerNotification($BorrowerId,'POST');

if ($notification ne 'POST')
{
return 0;
}
-----------------------------------------

and I have altered the format.pl to include the email field.

-----------------------------------------
format LETTER1 =

@<<<<<<<<<<<<<<<<<<<<<~
$BorrowerFullName
@<<<<<<<<<<<<<<<<<<<<<~
$BorrowerAddressLine1
@<<<<<<<<<<<<<<<<<<<<<~, @<<<<<<<<<<<<<<<<<<<<<~
$BorrowerAddressLine2 $BorrowerAddressLine3
@<<<<<<<<<<<<<<<<<<<<<~
$BorrowerAddressPostCode
@<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
$EmailAddress1

Number: @<<<<<<<<<<<<< Dated: @<<<<<<<<<<<<<<<<<
$BorrowerBarcode $ShortCurrentDate
Branch: @<<<<<<<<<<<<<<<<<~ Phone: @<<<<<<<<<<<<<<<<<~
$LocationAddressLine1 $LocationAddressPhoneNo
======================================================
FIRST OVERDUE
.

-----------------------------------------

However, when I run the overdue script, halfway through, it churns out the following error message:

Sybase message 156, Severity 15, state 1
Server `SYBASE'
Line 5
Incorrect syntax near the keyword 'and'.

1>
2> select GROUPING_ID
3> from BORROWER_GROUPING_LINK
4> where BORROWER_ID =
5> and SUB_TYPE = 1
6> and GROUPING_ID in ('POST','EMAIL')

It looks to me like the $bor_id is not being passed from the perl tool, but I don't really understand perl, so I'm not sure what the problem is....

Would I need to populate everyones borrower record with either 'POST' or 'EMAIL', or is the select.pl script supposed to default to 'POST' if one isn't present.

If this makes sense to anyone, do you have any ideas why it's failing?

Cheers
Mark