Up Prev Next
From: "J dot H dot P" <jong at ebi dot ac dot uk>
Subject: Re: always failing in INSERT
Date: Jul 25 1999 4:15PM
Thanks a lot. Your advice was really good as I now know
what is going on. I use 'sybase' account and checks
Could you also tell me how I can check if
> A suggestion would be build your entire SQL statement in a variable prior to
> executing it. Then display the statement prior to execution. If you don't
> see any errors, cut/paste the SQL and run that exact SQL in whatever tool
> you use. Verify the exact same SQL you are running through SybPerl runs in
> your standard SQL Editor.
> Check and make sure your strings are quoted.
> -----Original Message-----
> From: owner-SYBPERL-L@listproc.net
> [mailto:owner-SYBPERL-L@listproc.net]On Behalf Of J.H.P
> Sent: Sunday, July 25, 1999 10:47 AM
> To: SybPerl Discussion List
> Subject: always failing in INSERT
> I always fail in inserting.
> I use LInux version of ASE 11.0.33.
> I have installed it with SYBASE as an SQL server.
> I use DBI:Sybase;database=SYBASE
> And then I created a table called TEST.
> Then I always fail at the following:
> $dbh->do( "INSERT INTO TEST values ( $sub_title, $sub_funcion, $sub_version,
> $sub_content, $sub_contact )" )
> || print "\n Failed to insert
> Can anybody tell me what I am doing wrong?
> -- Jong Park : a Biology student -- Tel work: +44 1223 49-4613
> BioPerl Conference with ISMB 99 in Heidelberg ==>
-- Jong Park : a Biology student -- Tel work: +44 1223 49-4613
BioPerl Conference with ISMB 99 in Heidelberg ==>