sql:query - Aliases and Aggregates

2004-04-14 Thread Brett Randall
Hi All, I have two questions about the use of sql:query: 1) Can sql:query handle aliases of the form select column1 as alias1 from table1. I find nothing in variable.alias1. If not, how does sql:query handle column name collisions (that are usually handled with an alias), 2) Can sql:query

Re: sql:query - Aliases and Aggregates

2004-04-14 Thread Hassan Schroeder
Brett Randall wrote: I have two questions about the use of sql:query: 1) Can sql:query handle aliases of the form select column1 as alias1 from table1. 2) Can sql:query handle aggregates of the form select column1, count(*) from table1 group by column1. With reference to 1) above, does