Re: Query of Queries

[Matt Genevieve]

Coldfusion, on a windows machine. MySQL 4.1.8

1st query is:
select id, cip,date,time
from weblogs

the second queries the first

select distinct(cip) as a,count(id) as t
from firstquery

the above both work fine. But when I try to use time_format in a query of queries its not happy.

I take it that maybe this is a CF problem.

How would I correctly format
select distinct(time_format( time, '%H' )) as a
from weblogs

M@)?