from yourTable
group by type, id
order by id
hth
....tony
tony weeg
[EMAIL PROTECTED]
www.revolutionwebdesign.com
rEvOlUtIoN wEb DeSiGn
410.334.6331
-----Original Message-----
From: Daniel Farmer [mailto:[EMAIL PROTECTED]
Sent: Sunday, December 21, 2003 2:43 PM
To: CF-Talk
Subject: a query
This will probably be simple, but I'm no sql master.
I have three columns
ID, TYPE, PAGENAME
I want to select all items, group by type and order by id.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Daniel Farmer
Coldfusion Developer / Producer
http://www.bernardclark.com/danfarmer.ca/
613.284.1684
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
