In the SQL server 2008 database, I have a table named 'article_link' and it has a column name 'external'. Since the 'external' column is a predefined keyword in SQL server 2008, it is throwing error as below while connecting the database through perl script :
DBD::ODBC::db do failed: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the
keyword 'external'. (SQL-42000) [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be
prepared. (SQL-42000)(DBD: st_execute/SQLExecute err=-1)
There is a module named ArticleLink.pm where the code has the table column details as below :
use Class::MethodMaker [ scalar => [qw/ id article_id link url external active rank /], new => 'new', ];
I have tried to change the 'external' keyword to [external], but it does not work.
Can you help me please, there is a problem with the Class::MethodMaker module syntax.
Thanks in advance
Don't put off till tomorrow, what you can do today.