1) In order to access a column (field) you must include it in a SELECT
statement
2) if you include DISTINCT in a SELECT statement it applies to all
columns in the SELCET statement
3) You cannot apply DISTINCT to a memo/text. clob. blob field.
So, you cant get what you want in a single query *
* unless your db supports subqueries -- a whole 'nother topic.
My original suggestion will getcha' where ya' wanna' go!
HTH
Dick
On Jul 3, 2004, at 3:28 AM, [EMAIL PROTECTED] wrote:
> Thank you Dick.
> You didn't really understand my problem
> I guess. I am not doing
> a distinct on the memo field.
> But on another field. This works well.
> But if I am doing s.th. like:
>
> <CFQUERY name="CollectArtikel_1" DATASOURCE="something">
> SELECT distinct ArtikelNum
> FROM dbo.Artikeltext
> </CFQUERY>
>
> When I want to output The field "beschreibung"
> I get an error, because it is not included
> in the select, so how can I addditionally include
> this memo field ?
>
> Uwe
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
