Re: Strange behaviour with SQL vars and order by

2002-04-23 Thread Gerald Clark
I see no column named Site.nome showing that it is wrong. ds wrote: >Hi, > >I'm having a strange problem using SQL vars (@variable) and an order by >expression. > >I have a query that returns a record for each day. >Each record has a date (data), a column with the daily total value >(uv_views)

Strange behaviour with SQL vars and order by

2002-04-22 Thread ds
Hi, I'm having a strange problem using SQL vars (@variable) and an order by expression. I have a query that returns a record for each day. Each record has a date (data), a column with the daily total value (uv_views) and other with the accumulated value until the current day (acc_views). The ot