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

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

Hi poj,

these are the versions:

Perl 5.14

DBD::Sybase 1.15

Sybase: Adaptive Server Enterprise/15.7.0/EBF 22644 SMP SP52

Thanks!

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

Replies are listed 'Best First'.
Re^5: Inserting to a bigint data type in Sybase using prepare statements by poj (Abbot) on Jul 10, 2017 at 07:01 UTC
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	[reply] [d/l]
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