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

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
    ...
              :p1
              -- %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?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://1105911]
Approved by Corion
help
Chatterbox?
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
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?