Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

Re: How to enable placeholders for Sybase ASE on linux?

by genehack (Beadle)
on Nov 22, 2008 at 12:03 UTC ( #725322=note: print w/replies, xml ) Need Help??


in reply to How to enable placeholders for Sybase ASE on linux? (SOLVED)

Does it work if you switch to first preparing your statement handle, then executing it? I.e.,

my $sth = $dbh->prepare(<<'SQL'); select count(*) from syskeys where type = ? SQL $sth->execute(1);

and then pull the results out?

Also, you may want to have a look at http://search.cpan.org/~mewp/DBD-Sybase-1.09/Sybase.pm#Using_?_Placeholders_&_bind_parameters_to_$sth->execute if you haven't already.

Finally, if you're using version 1.0 of DBD::Sybase, you should probably upgrade to the latest -- looking at the CHANGES file (http://search.cpan.org/src/MEWP/DBD-Sybase-1.09/CHANGES) it's seen a lot of work since that time, including several things that sound like they could be related to the problem you're seeing.

Replies are listed 'Best First'.
Re^2: How to enable placeholders for Sybase ASE on linux?
by ccn (Vicar) on Nov 22, 2008 at 13:15 UTC
    Thanks, the problem has been solved with upgrading DBD::Sybase

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://725322]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (3)
As of 2020-10-31 05:30 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    My favourite web site is:












    Results (286 votes). Check out past polls.

    Notices?