Anyone have any idea why $sth->{NULLABLE}->[$cnt] would always returns 1? I
have a valid select, and I check other statement handle properties
($sth->{NAME}->[$cnt] and $sth->{TYPE}->[$cnt] ), but NULLABLE always seems
to be 1 ( it shouldn't be, 1 is for NULLable fields, 0 for NOT NULL fields,
2 for when the driver is unsure)
I am running Windows XP, Access 2002 ( although the DB is Access 2000 format
) , perl v5.6.1 built for cygwin-multi, DBI version 1.30, and DBD-ODBC
version 0.43.
Thanks in advance,
Josh
---------------------------------------------------
$sql = "SELECT * FROM tablename";
$sth = $dbh->prepare($sql);
$sth->execute || or die "$sql failed : $DBI::errstr";
$NUMFIELDS = $sth->{NUM_OF_FIELDS};
for ($cnt = 0; $cnt < $NUMFIELDS ; $cnt++) {
print $sth->{NULLABLE}->[$cnt]);
}
---------------------------------------------------
