Re: Derefencing DBI SQL statements

2004-08-13 Thread Hardy Merrill
Use "trace". Here's the whole section from "perldoc DBI" about using trace: "trace" DBI->trace($trace_level) DBI->trace($trace_level, $trace_filename) DBI trace information can be enabled for all handles using the "trace" DBI class method. To enable trace

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 MasterRealt