Skip to Content.
Sympa Menu

freetds - Re: [freetds] ***POTENTIAL SPAM*** error 778672 ...

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Bob Hetzel <beh AT case.edu>
  • To: freetds AT lists.ibiblio.org
  • Subject: Re: [freetds] ***POTENTIAL SPAM*** error 778672 ...
  • Date: Wed, 17 May 2006 09:08:49 -0400

When the prepare succeeds but the execute fails in my perl programs, it's always been because of a bad syntax, most likely due to a character that confuses the perl interpreter (i.e. a value you need to escape before it can be combined in perl code).

Check for and escape all the special perl characters like $, @, &, single quotes, double quotes, the backslash character, (, ), [, ], etc.

Bob

>>
>> I'm doing a simple insert:
>>
>> my $sth = $dbh->prepare(
>> "insert into Contacts ( Salutations, FirstName, LastName,
>> Title, Area,
>> PhoneSTD, PhoneNo, FaxSTD, FaxNo, Mobile, Email, BulkEmail, BillID )
>> values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )" ) || die
>> $dbh->errstr;
>>
>> $sth->execute( @values ) || die $dbh->errstr;
>>
>> It dies on the execute line:
>>
>> [unixODBC][FreeTDS][SQL Server]RAISERROR could not locate entry for
>> error 778672 in sysmessages. (SQL-42000)(DBD:
>> st_execute/SQLExecute err=-1)
>>
>> There's nothing surprising in the data - each element of the
>> array has a
>> non-NULL value etc. Does anyone know what this error is? Is
>> there some
>> place I should look for this error myself?
>>
>>






Archive powered by MHonArc 2.6.24.

Top of Page