I think a similar question has been asked but..

is there a way to arrange data inside <cfquery> so that it bases the where off 'book' 
and if but since there's about 300,000 rows in the db.. and only about 66 values for 
Book, that it only displays one row for each data

so that if there was

1 | Genesis | Text
1 | Genesis | More Text
1 | Genesis | Even more
....
2 | Exodus | Text
2 | Exodus | Even More Text

it would only display

1 | Genesis | Text
2 | Exodus  | Text

Thanks, 
Tony Hicks


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to