Sorry if this is off-topic (not directly DBI), but I can't seem to figure out what's going on... I've never used the MSSQLReporter module before, and can't seem to get anything to work! When I call $reporter -> get_fieldNames($fieldname) with any variable I get a prepare failed error on the table name: DBD::ODBC::db prepare failed: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 3: Incorrect syntax near 'billcodes'. (SQL-37000) [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared. (SQL-37000)(DBD: st_prepare/SQLPrepare err=-1) at C:/Perl/site/lib/DBIx/MSSQLReporter.pm line 116. You can see that the variable looks to be working, as my table name is in the error. By replacing the variable with the table name (in single or double quotes) I don't have this problem. I've tried quoting or not quoting the variable, but it just doesn't seem to work! I'm using Activestate Perl 5.6.1 build 626 on Win2k with the latest MSSQLReporter (1.00) from Activestate's PPM repository against a MS-SQL 7.0 database. Thanks in advance for any help, Scott Phelps [EMAIL PROTECTED] Webkorner Internet Services --- [ This E-mail scanned for viruses by www.WebKorner.com ]
