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

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