Both feedbacks make sense.. can you clarify for me.. would it be
<cfquery>
Select Distinct * from #table#
</cfquery>
<cfoutput>
#book# #bookTitle# | #text#
</cfoutput>
and that would return what? Somethng like this:
1 Genesis | Text
2 Exodus | Text
3 Leviticus | Text?
----- Original Message -----
From: Bill Killillay <[EMAIL PROTECTED]>
To: SQL <[EMAIL PROTECTED]>
Sent: Wednesday, May 30, 2001 6:36 AM
Subject: RE: list once
> 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
