If you only need to display those 66 you could use
Select Distinct book, id, ....
>From books
Is that what your looking for, that would give you each book only I
believe...
-----Original Message-----
From: Tony Hicks [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 30, 2001 6:39 AM
To: SQL
Subject: list once
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
