Thanks Adrian,
On 2013-02-06, at 12:40 , Adrian Klaver <adrian.klaver@gmail.com> wrote:
> I am not seeing anything obvious.
> Is there a chance the import to the second machine did not go well?
Actually, these queries work on the machine that the import was done to =
- but not the original. However, not all is well on the development =
machine, I've sent a further email.
> Have you looked at the values for id and reportid to see if they look =
alright?
Yes, those I've scanned seem OK - I've tried some tests looking for =
nulls etc. (there are several million reports, and about 30 times as =
many results, hence I'm not posting a reproducible example - yet!)
cheers
Ben
--=20
Ben Madin
m : +61 448 887 220
e : ben@ausvet.com.au