Click here to get back home

placeholder error

 HomeNewsGroups | Search | About
 comp.lang.perl.modules    Post an article   get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content
Subject Author Date
placeholder error lnatz 08-03-2006
Get Chitika Premium
Posted by lnatz on August 3, 2006, 1:33 pm
Please log in for more thread options


I am using DBD-Sybase 1.05-oc12.5.1. When running my script I get the
following error:

ct_result(ct_dynamic(CS_PREPARE)) returned -205 at
//ms/dist/perl5/PROJ/DBD-Sybase/1.05-oc12.5.1-5.8/lib/perl5/DBD/Sybase.pm
line 150, <DATA> line 283.

I believe the error lies within this line:

$DBH->prepare("UPDATE $table_name SET $del_col = $del_val WHERE
$user_col = ?")

I know you can't use the prepare() call with placeholders. My problem
is that I don't know what to use instead of the placeholder. If anyone
would help me out, I would greatly appreciate it.

Thank You,
Natalie


Posted by Paul Lalli on August 3, 2006, 1:56 pm
Please log in for more thread options


lnatz wrote:
> I am using DBD-Sybase 1.05-oc12.5.1. When running my script I get the
> following error:
>
> ct_result(ct_dynamic(CS_PREPARE)) returned -205 at
> //ms/dist/perl5/PROJ/DBD-Sybase/1.05-oc12.5.1-5.8/lib/perl5/DBD/Sybase.pm
> line 150, <DATA> line 283.
>
> I believe the error lies within this line:
>
> $DBH->prepare("UPDATE $table_name SET $del_col = $del_val WHERE
> $user_col = ?")
>

What makes you think that? I mean, for all I know, you're right, but
nothing about that error message points to a specific line of your
code. Did you look up the Sybase documentation to see what -205 means?

> I know you can't use the prepare() call with placeholders.

Huh?

> My problem
> is that I don't know what to use instead of the placeholder. If anyone
> would help me out, I would greatly appreciate it.

I don't know where you got the idea that you can't use placeholders in
a prepare()'d statement. On the contrary, that's one of the primary
reasons for using prepare (followed by multiple executes) rather than a
simple do()...

Paul Lalli


Similar ThreadsPosted
Error: RCPT TO: error (550 relay not permitted) February 11, 2006, 1:39 pm
GD.c: 533: error: syntax error before "void" March 24, 2006, 10:15 am
Error while using LWP December 1, 2005, 8:06 am
Have I an error in my POD? December 21, 2005, 6:35 pm
Deparse error July 7, 2004, 2:52 am
Out of Memory error September 12, 2004, 11:51 pm
expat error May 26, 2005, 9:01 pm
Error Installing XML::DOM October 15, 2004, 9:16 am
error with CPAN.pm October 19, 2004, 7:13 am
Error reporting in CGI May 19, 2005, 9:41 pm

Our other projects:

Art Dolls, Fairies and Mermaids - Sunnyfaces.net

Roy's Linux, Programming and Search Engines messages

1-Script XML SitemapXML Sitemap