[slightly OT] reliability of mySQL & Rev cgi ?

jbv jbv.silences at club-internet.fr
Fri Dec 26 14:04:18 EST 2008



Kee Nethery a *crit :

> not a mySql guy but I'm betting there is something you could add to
> the statement to get the data in the same order every time.
> Kee Nethery
>
> On Dec 26, 2008, at 6:57 AM, jbv wrote:
> >
> >
> > SELECT col1, col2, col3, col4 FROM myTable WHERE myList LIKE "% value1
> > %" OR
> > myList LIKE BINARY("% value2 %") OR myList LIKE "% value3 %" OR myList
> > LIKE "% value4 %" OR...
>
>   order by col1 desc
>

I tried that already but it doesn't help...

I'm sure you're right, there's something I should add to my requests to get the same
results no matter the order in which requests are sent to mySQL, but I still have to
figure out what...
Any wise suggestion is welcome...

JB




More information about the use-livecode mailing list