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


Problems? Is your data what you think it is?
	PerlMonks

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

by poj (Abbot)

on Jul 10, 2017 at 07:01 UTC ( [id://1194663]=note: print w/replies, xml )

Need Help??

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

Domain Nodelet^?

www.com | www.net | www.org

Node Status^?

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

Chatterbox^?

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

Other Users^?

Others goofing around in the Monastery: (5)

As of 2024-04-19 13:25 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Today I Learned

Voting Booth^?

No recent polls found