Do you want to see all the items, ie their IDs and Pagename? Or do you actually want to group all the same types together?
  ----- Original Message -----
  From: Daniel Farmer
  To: CF-Talk
  Sent: Sunday, December 21, 2003 2:43 PM
  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]

Reply via email to