freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
Re: [freetds] ***POTENTIAL SPAM*** error 778672 ...
- 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?
>>
>>
-
Re: [freetds] ***POTENTIAL SPAM*** error 778672 ...,
Bort, Paul, 05/16/2006
- Re: [freetds] ***POTENTIAL SPAM*** error 778672 ..., Daniel Kasak, 05/16/2006
-
Re: [freetds] ***POTENTIAL SPAM*** error 778672 ...,
Daniel Kasak, 05/16/2006
- Re: [freetds] ***POTENTIAL SPAM*** error 778672 ..., Daniel Kasak, 05/16/2006
- <Possible follow-up(s)>
- Re: [freetds] ***POTENTIAL SPAM*** error 778672 ..., ZIGLIO, Frediano, VF-IT, 05/16/2006
- Re: [freetds] ***POTENTIAL SPAM*** error 778672 ..., Bob Hetzel, 05/17/2006
Archive powered by MHonArc 2.6.24.