RE: Problem with "update" statement

2003-02-28 Thread Russell Kroboth
Sent: Thursday, February 27, 2003 12:14 PM > To: [EMAIL PROTECTED] > Subject: Problem with "update" statement > > > I am having a problem using the UPDATE statement in a Perl > program, this > program does not update the field as expected: > > #!/usr/bin/pe

Problem with "update" statement

2003-02-27 Thread Russell Kroboth
I am having a problem using the UPDATE statement in a Perl program, this program does not update the field as expected: #!/usr/bin/perl use DBI; require "DBconnect.cgi"; $dbh = DBI->connect($data_source, $username, $password, 'Sybase') || die &DBerror; $dbh->do("use Partners") || die &DBerror; $sq

Re: Problem with update

2002-01-29 Thread Douglas Wilson
From: "Nilanjan Das" <[EMAIL PROTECTED]> > > update fmly set HQ_SRS_ID = N'20037026',HQ_SRS_NAME = N'TRADOC > DOCUMEWTAAO E SERVIOS' where fmly_id = 126908 > > DBD::Oracle::db prepare failed: ORA-01756: quoted string not properly > terminated (DBD ERROR: OCIStmtPrepare) That's what placeho

Problem with update

2002-01-29 Thread Nilanjan Das
Hi Gurus, I have DBI and DBD with Oracle on HP-UX. I am facing some problem in updating a table with data that has special characters, my database is having NLS character set enabled. I have a table which has the following data(the datatype of the columns are: name