We have added a custom data field for use in Ticket Orders.
The problem is that it only saves 12 characters to the T_Order table.
I ran a SQL Profiler on the order save and found the following:
UPDATE T_ORDER SET order_no = 1847029, transaction_no = 634807, custom_1 = 'Collect Conn' WHERE order_no = 1847029
The code is truncating my custom data field (custom_1). It allows 255 characters in the t_order table, and so I don't know why it is doing this. It doesn't seem to be part of a Stored procedure and therefore I can't find where to look at the code.
Thanks,
- Blair
That’s great that both options ended up being useful!
A Fan Club of my own! *blush*
In the words of Janis … Peace, Love and Tessitura … Man