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

Hi poj,

I have also tried that, but in that case I was getting this error

<Couldn't prepare statement: Server message number=12828 severity=16 state=1 line=1 server=DEVEL1 procedure=DBD3 text=The datatype of a parameter marker used in the dynamic prepare statement could not be resolved.

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

Replies are listed 'Best First'.
Re^3: Inserting to a bigint data type in Sybase using prepare statements by chacham (Prior) on Jul 07, 2017 at 14:18 UTC
How about using INSERT...SELECT instead of INSERT...VALUES? It might be legal in that statement instead.	[reply]
Re^3: Inserting to a bigint data type in Sybase using prepare statements by poj (Abbot) on Jul 07, 2017 at 14:29 UTC
What version of Sybase, Perl and DBD::Sybase are you using ?	[reply]
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