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