use Win32::ODBC; use CGI qw(:standard); use CGI::Carp qw/fatalsToBrowser/; sub NoFeedback {for (1 or 0) if (!($db=new Win32::ODBC($DSN))) { print "Error connecting to Database\n"; print "Error: " . Win32::ODBC::Error() . "\n"; } #end if (!($db=new Win32::ODBC($DSN))) $SqlStatement = $sql; print "SqlStatement = $SqlStatement"; if ($db->Sql($SqlStatement)) { print "SQL failed.\n"; print "Error: " . $db->Error() . "\n"; if ($DebugMode) { print "
##
SELECT DISTINCT Feedback.Email FROM Feedback LEFT OUTER JOIN FOSBriefer ON Feedback.Username = FOSBriefer.Username WHERE (ISNULL(FOSBriefer.Username, 'z') = 'z')
####
SQL failed. Error: [911] [1] [0] "[Microsoft][ODBC Driver Manager] Invalid string or buffer length"