[thelist] authorize.net transaction ID value

Bob Meetin bobm at dottedi.biz
Wed Jul 30 16:36:34 CDT 2008


Anthony Baratta wrote:
> 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
>  
> ==>>  Responding to both Ben and Anthony -->>
>   
That helps.  Rereading their message, there was nothing to indicate that 
this was the value of a field in MySQL.  The eCommerce solutions I am 
currently using are both in MySQL (zen-cart and virtuemart). So long as 
I know what to look for I can easily access/check the db fields.  It 
would be nice had they noted the table, but that probably varies too much.

Your advice helps a lot.

-Bob




More information about the thelist mailing list