Re^5: Inserting to a bigint data type in Sybase using prepare statements

in reply to Re^4: Inserting to a bigint data type in Sybase using prepare statements
in thread Inserting to a bigint data type in Sybase using prepare statements

Using CONVERT, did you remove the BIGINT type from the bind statement ?

my $insert_sth = "
  INSERT INTO some_table 
  ( transaction_id, ccn_masked, cardholder_name, exp_month, 
    exp_year,card_type, token_id ) 
  VALUES (?, ?, ?, ?, ?, ?, CONVERT(BIGINT,?) )"; 
.
.
.
$q_result->bind_param(7, "5114780000000000271");
[download]

poj

Comment on Re^5: Inserting to a bigint data type in Sybase using prepare statements Download Code

Replies are listed 'Best First'.
Re^6: Inserting to a bigint data type in Sybase using prepare statements by j_ochoa (Novice) on Jul 10, 2017 at 08:31 UTC
Yes, I have tried with data type BIGINT removed as well. JO	[reply]

In Section Seekers of Perl Wisdom