Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change

DBI 1.625, DBD::Sybase 1.14, ASE 15.7: no placeholder support for UNSIGNED INT datatype in SET clause

by Anonymous Monk
on Nov 03, 2014 at 15:08 UTC ( #1105911=perlquestion: print w/replies, xml ) Need Help??

Help for this page

Select Code to Download

  1. or download this
    DBD::Sybase::st execute failed: Server message number=257 severity=16 
    +state=1 line=0 server=DB_SERVER procedure=DBD2 text=Implicit conversi
    +on from datatype 'VARCHAR' to 'UNSIGNED INT' is not allowed.  Use the
    + CONVERT function to run this query.
     Statement=    UPDATE db..table
              -- %d
        WHERE search_col = :p2
  2. or download this
    DBD::Sybase::db prepare failed: Server message number=12828 severity=1
    +6 state=1 line=1 server=DB_SERVER procedure=DBD2 text=The datatype of
    + a parameter marker used in the dynamic prepare statement could not b
    +e resolved.
     Statement=    UPDATE db..table
          CONVERT( UNSIGNED INT , :p1 )
          -- %d
        WHERE search_col = :p2
  3. or download this
    # SQL.
    create table pqr
    $n = 3;
    #  works (same as %s, this is all string in the end).
    $dbh->do( sprintf q/UPDATE pqr SET y = %d/ , $n );

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://1105911]
Approved by Corion
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others about the Monastery: (6)
As of 2020-11-27 20:44 GMT
Find Nodes?
    Voting Booth?

    No recent polls found