[thelist] authorize.net transaction ID value

[Anthony Baratta]

Bob...

That's going to be a DB issue. Check the Database and see what column type stores that info for you. If it's a numeric/integer type make sure it's large enough to support numbers bigger than 2 billion. That field might be a varchar and then you just have to support more than 10 characters.

e.g. with mySQL you'd want to move to BitInt:

Type      Minimum Value                    Maximum Value
INT        -2147483648                     2147483647
BIGINT  -9223372036854775808    9223372036854775807

Hope that helps.

--
Anthony Baratta


-----Original Message-----
From: Bob Meetin <bobm at dottedi.biz>
To: "thelist at lists.evolt.org" <thelist at lists.evolt.org>
Date: 07/30/08 14:20
Subject: [thelist] authorize.net transaction ID value

I received an automated message a little bit ago from authorize.net 
informing me/us that whatever eCommerce solution in use must be able to 
accept transaction ID (x_trans_id) values greater than 2,147,483,647. 
Are any of you familiar with how to check this, and/or any eCommerce 
programs that are likely to have problems with this now?  -Bob