|
|
sybperl-l Archive
Up Prev Next
From: "venkat Reddy" <chittepu at forindia dot com>
Subject: insertion into database using script
Date: Apr 24 2000 6:39AM
hi,
How do I insert,update the tables?
Below is the script I wrote.
use Sybase::DBlib;
$pwd = "";
$server = "srvr01";
$database = "tempdb";
$dbh = new Sybase::DBlib 'sa', $pwd, $server,$database;
$dbh->dbcmd("insert into Users(Name,Sex) values(\"Venkat\",\"M\")");
$dbh->dbsqlexec;
$status=$dbh->dbresults;
print "The status is returned as == $status\n";
----
the following are the errors I got:
Users not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).
DB-Library error:
General SQL Server error: Check messages from the SQL Server.
----
see u
venkat
chittepu
e-mail: chittepu@forindia.com
--------------------------------------------------------
Feed Your Greed !!!
Get your 10MB Free space only at http://www.forindia.com NOW!
--------------------------------------------------------
|
