Re: sql ERROR -309...BUG IN 7.31?

From: allenj <allenj@ndr.com> > >So on my prior 7.22.UC1 I could do a: > > select company[1,25] from clients > order by company ; > >with no problem whatsoever. >(I need the first 25 characters because I am tailoring the output for a >drop-down on a web page) >------------- >Now I have upgraded to 7.31.UC2 and when I try the same thing I get: > > 309: ORDER BY column (company) must be in SELECT list.> >Looks to me like column company IS in my select list. Is this a bug in >7.31.UC2?????????? Dunno, but try ORDER BY 1 -- i.e., positional notation HTH. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com