You should first make sure your query runs outside of Perl. -----Original Message----- From: Brian Johnson [mailto:[EMAIL PROTECTED] Sent: Thursday, February 22, 2007 10:22 AM To: [email protected] Subject: DBI Number of fields
Hey Folks - We are having a problem with a script that uses DBI and ODBC to connect to a MSSQL database. The script was running fine, until we added some fields to a select statement. Now the scripts hangs at that select. The script has multiple fields (as many as 22 fields), multiple joins (5 left joins), and pulls from as many tables. If we remote any single field, the script works. If we remove one of the joins, the script works. We have tried to disconnect/reconnect to the database just before this select statement, with the same results. None of the fields are long enough for LongReadLen or LongTruncOk to be the culprits. Does anybody have any ideas? ------------------------------------- Brian Johnson Systems Administrator Work: 248.577.0383 ext 203 Cell: 906.281.0589 e-Mol - Electronic Medical Office Logistics
