freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- 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
-
update a DB,
gargiullo, 03/29/2002
- <Possible follow-up(s)>
- Re: update a DB, Michael Peppler, 03/29/2002
- Re: update a DB, Michael Gargiullo, 03/29/2002
- Re: update a DB, Michael Peppler, 03/29/2002
- Re: update a DB, Michael Gargiullo, 03/29/2002
Archive powered by MHonArc 2.6.24.