Re: fetchall_arrayref and Can't set DBI::st=HASH(0x850eeb0)->{NAME}: unrecognised attribute or invalid value

2004-08-06 Thread Tim Bunce
On Thu, Aug 05, 2004 at 10:50:07PM -0400, Rudy Lippan wrote: > On Thu, 5 Aug 2004, Tim Bunce wrote: > > > I don't see any metion of it in the docs. but I recall that DBD::mysql > > only makes statement handle attributes like NAME available while > > the statement handle is still Active. > > Shoul

Re: fetchall_arrayref and Can't set DBI::st=HASH(0x850eeb0)->{NAME}: unrecognised attribute or invalid value

2004-08-05 Thread Rudy Lippan
On Thu, 5 Aug 2004, Tim Bunce wrote: > I don't see any metion of it in the docs. but I recall that DBD::mysql > only makes statement handle attributes like NAME available while > the statement handle is still Active. Should DBD::mysql make the attribs available when the handle is not active? Ru

Re: fetchall_arrayref and Can't set DBI::st=HASH(0x850eeb0)->{NAME}: unrecognised attribute or invalid value

2004-08-05 Thread Tim Bunce
I don't see any metion of it in the docs. but I recall that DBD::mysql only makes statement handle attributes like NAME available while the statement handle is still Active. fetchall_arrayref() will fetch all the data and so leave the statement handle in-Active. Just get the NAME array ref before

fetchall_arrayref and Can't set DBI::st=HASH(0x850eeb0)->{NAME}: unrecognised attribute or invalid value

2004-08-04 Thread remus
SENARIO: I have downloaded a CSV file for the past 8 months with about 50k lines of data. The data does change a little each day, just some fields. I have uploaded all the files to a MySQL database. I have been able to compare one row of data at a time. Easy!. But I want to compare a whole bun