Odd behavior - it worked yesterday but not today

2004-11-01 Thread remus
Ok here is a good one. I have been working for several months with a few scripts that I am coding for a new site. The scripts have been working just fine until I rebooted my workstation last night. Today, the scripts are not working I kee getting this message: Name main::DBI used only once:

Derefencing DBI SQL statements

2004-08-13 Thread remus
Is there a way to dereference the SQL statement that is send to the DBD? I am loading a master table with 19+ fields and there seem to be a problem at the end of the SQL statement. I want to see what is the DBI/DBD sending to the Database. example: $q3 = $dbh-prepare(INSERT INTO

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