Posted by Bob Bedford on 09/14/05 09:13

Hello Oli,

thanks for reply,

"Oli Filth" <catch@olifilth.co.uk> a écrit dans le message de news:
DvdUe.26$2y.0@newsfe7-win.ntli.net...
> Bob Bedford said the following on 09/09/2005 08:04:
>> We have no access to a mysql NG on my provider's server, so we ask here:
>>
>> We have a long query (long in text) with a UNION between 2 select.
>>
>> We have been informed that some times the query doesn't return any
>> result.
>> We have tried on our server and we always get a result. BUT, trying on
>> the
>> hosting server, many times the query doesn't return any result and
>> doesn't
>> get any error.
>>
>> Any idea ?
>
> What is the query?

it something like (select x,y,z from 3 tables, with 10 left and inner join)
union (same thing than first query)

It shouldn't change anything, since the real problem is that sometimes it
works and sometimes it doesn't.

Bob

[Back to original message]