Skip to Content.
Sympa Menu

freetds - update a DB

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: gargiullo AT comcast.net
  • To: freetds AT franklin.oit.unc.edu
  • Subject: update a DB
  • Date: Fri, 29 Mar 2002 10:20:06 -0500


I have the following query:

my $dbh = DBI->connect('DBI:Sybase:server=192.168.0.2', $user, $pass)or
die "Can't connect to database: $DBI::errstr\n" . DBI->errstr;
my $insert_handle = $dbh->prepare("UPDATE zipcodes SET county=$arr[0],
areacode=$arr[1] Where zip = $zip") || die "Couldn't prepare queries;
aborting:\n$!" . $dbh->errstr;
$insert_handle->execute() or return 0 . dbh->errstr;
return 1;

But I get the following error.

DBD::Sybase::st execute failed: Server message number=208 severity=16
state=1 line=1 server=WHITETAIL text=Invalid object name 'zipcodes'. at
./zip.pl line 32.
Can't locate object method "errstr" via package "dbh" at ./zip.pl line 32.


I'm going crazyI've made a bunch a changes over the past 2 days, and this
is as close as I got.

Thanks

-Mike





Archive powered by MHonArc 2.6.24.

Top of Page