Forum OpenACS Q&A: Response to Query problem after upgrade of PG and driver.

Don,

The previous version of psql was 7.0.3. The current version is 7.1.3.

I followed your suggestions and got the order by to work correctly. Here is a summary of the order by changes I had to make:

7.0.3                         7.1.3
o.order_id                    order_id
u.first_names, u.last_name    first_names,last_name
ec_total_price(o.order_id)    price_to_display (the as ...)

It seems like the last time I tried the last one in oracle, it didn't work like this, although I had hoped that it would.

Thanks for your help, and Happy New Year!