SQL server 2008 error

l.frankline has asked for the wisdom of the Perl Monks concerning the following question:

Hi,

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',
     ];
[download]

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
-Franklin

Don't put off till tomorrow, what you can do today.

Back to Seekers of Perl Wisdom