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

Replies are listed 'Best First'.
Re^4: Inserting to a bigint data type in Sybase using prepare statements by j_ochoa (Novice) on Jul 10, 2017 at 06:36 UTC
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!	[reply]
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]