Inserting Values using DBI::ODBC 1

[Rieekan]

I'm attempting to save values to a memo field in an Access database, but when I attempt to insert with the statement below, it throws an error of 'Invalid Precision Value'. The problem is occurring when I have a value for $comments that is greater than 250 characters. (The max size for a Text field in Access).

Has anyone ran into this before and have any suggestions on how to fix this?

my %attr = { TYPE => 'SQL_LONGVARCHAR'};

my $comment = param('comment');

my $update = qq{insert into FUND_COMMENTS (FUND_CODE, USER_SEQ_ID, COMMENT) values (?, ?, ?)};

my $update_st = $fundsappdb->prepare($update) or keelover("Cannot prepare Comment Insert statement for fund $fund_code: ". $fundsappdb->errstr ." ", "2");

$update_st->bind_param(1, $fund_code);
$update_st->bind_param(2, $user_seq_id);
$update_st->bind_param(3, $comment, \%attr);

$update_st->execute() or keelover("Cannot execute Comment Insert statement for fund $fund_code: ". $fundsappdb->errstr ." ", "2");

Any and all help would be much appreciated!

 

[Rieekan]

I have figured out this problem It turns out that the documentation is slightly incorrect for the ODBC DB Driver. Once I changed my bind parameter to the following, it worked like a dream.

$update_st->bind_param(3, $comment, DBI::SQL_LONGVARCHAR);

Thanks to anyone that tried to help figure this out.

- George