placeholder error

[lnatz]

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

[Paul Lalli]

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