[transfer-dev] Re: Query Of Queries runtime error.

2011-10-11 Thread Robert Rawlins
I appear to have solved this issue. It looks to be something to do with me using type="numeric" in transfer, but actually having the column datatype as varchar. It appears that CF has some clever auto data-type recognition stuff going on behind of QofQ's and this was confusing it. Robert --

[transfer-dev] Help with TQL Join

2011-10-11 Thread Robert Rawlins
Hello Guys, I have the following TQL query, which runs as expected: from inventory.Stock As Stock join order.item As Item where Stock.StockNumber = :StockNumber Now, I want to create an additional join, this time from the Item object to the 'Order' object.