Send us the relavant part of the code as well as the error messages you are getting. Before you do that, you might want to try tracing your problem with trace(2, log.txt)
Ilya -----Original Message----- From: Khaliq, Abdul (A.) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 11:19 AM To: '[EMAIL PROTECTED]' Subject: SQL query problem I am migrating the application from old environment (PERL 5.004, CGI 2.36, DBI 0.91) to new environment (PERL 5.6.0, CGI 2.68, DBI 1.14). One of the SQL queries in PERL program not executing. It is a query in which I am selecting about 40 fields from a single database table and SUM functions is used on most of the fiedls. There is no error in query itself because It is running fine in SQL PLUS. If I take out some of the fields (reduce the no. of fields in the select statement) then the query executes but It does not execute if I include all the required fields in select statement. The execute statement $csr->execute(); does not return. Thanks, [EMAIL PROTECTED]
