Pathologically Eclectic Rubbish Lister | |
PerlMonks |
Re: DBI problem with Access's Memo fieldby cadfael (Friar) |
on Nov 01, 2000 at 20:08 UTC ( [id://39429]=note: print w/replies, xml ) | Need Help?? |
Why are you getting an "Invalid precision value" while dealing
with character data?
I have no experience using DBD::ODBC to query an Access database, but it seems to me that the memo field is somewhat like the "text" datatype in SQL server and Sybase. i.e. it holds quantities of alphanumeric data and is stored in a different manner than the rest of the table rows You might want to look at the fetchall_arrayref() in the DBI manual (pp 131-135 in Programming the Perl DBI. This will return a hash of all the data, and you can then access the rows sequentially, and the elements within the rows randomly. I use something similar with Sybase text fields, and it works just fine. It may be worth a try. Good Luck. -----
In Section
Seekers of Perl Wisdom
|
|