> moving on to the next bug...
>
> Now, I'm having problems with the
>
> $args{'select'} = "$args{'group_by'}, AVG(prices) ";
>
> line. The sql that is being produced is:
>
> SELECT t2.type, t1.AVG{prices) ....
>
> so throws an error. The sql should be:
>
> SELECT t2.type, AVG(t1.prices) ....
>
> I've been looking through the docs trying to figure out how to properly
> specify AVG(COLUMN) in the 'select' argument with no success. Is it
> possible?
It just occurred to me that I could just to a regex on the sql statement
and fix the SELECT portion. I'm going to try that out.
Take care,
Kurt
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Rose-db-object mailing list
Rose-db-object@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rose-db-object
