I have a select where I end like this:
...where week = 40 and year = 2004 order by trykkedato, presseID, godeaviser
but the statement logged by the server is
...where week = 40 and year = 2004 order by 1,3,20
Why? The order get messed up....
Regards,
BTJ
--
-----------------------------------------------------------------------------------------------
Bjørn T Johansen
btj@havleik.no
-----------------------------------------------------------------------------------------------
Someone wrote:
"I understand that if you play a Windows CD backwards you hear strange Satanic messages"
To which someone replied:
"It's even worse than that; play it forwards and it installs Windows"
-----------------------------------------------------------------------------------------------