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 ( [id://1194660]=note: print w/replies, xml )

Need Help??

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]

Domain Nodelet^?

Node Status^?

node history
Node Type: note [id://1194660]
help

Chatterbox^?

How do I use this? • Last hour • Other CB clients

Other Users^?

Others wandering the Monastery: (7)

As of 2024-04-24 07:18 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Voting Booth^?

No recent polls found