in reply to Re: Accessing MS-Access memofield via DBI
in thread Accessing MS-Access memofield via DBI
Can I do the binding dynamically depending on the datatype of the field??
I tried
But I got the following errormessage:
DBI::st=HASH(0x3e9c2dc)->bind_param(...): attribute parameter 'SQL_INTEGER' is not a hash ref at C:/access.pl line 19
I tried
#! /usr/bin/perl use strict; use warnings; use DBI ':sql_types'; my $dbh = DBI->connect('DBI:ODBC:driver=Microsoft Access-Treiber (*.md +b);dbq=db1.mdb',user,pass); my $col = 'Testcol'; my $statement = "INSERT INTO table (`$col`) VALUES(?)"; my $coltype = get_type($col,$dbh); $coltype = 'SQL_'.$coltype; my $sth = $dbh->prepare($statement); for(2..1000){ my $var = <STDIN>; chomp $var; $sth->bind_param(1,$var,$coltype); $sth->execute($var) or die $dbh->errstr(); } sub get_type{ my ($name,$dbh) = @_; my ($sthcolinfo) = $dbh->column_info(undef,undef,undef,$name); my $hashref = $sthcolinfo->fetchrow_hashref(); return $hashref->{TYPE_NAME}; }
But I got the following errormessage:
DBI::st=HASH(0x3e9c2dc)->bind_param(...): attribute parameter 'SQL_INTEGER' is not a hash ref at C:/access.pl line 19
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^3: Accessing MS-Access memofield via DBI
by reneeb (Chaplain) on Sep 14, 2005 at 07:27 UTC | |
by reneeb (Chaplain) on Sep 14, 2005 at 10:32 UTC | |
by dorianwinterfeld (Acolyte) on Oct 03, 2005 at 04:13 UTC |
In Section
Seekers of Perl Wisdom