text/memo/clob/blob column.
Just do a distinct query on the other fields
Then create a ValueList or Quoted ValueListt from the query column
containing the IDs
Then do a second query selecting all the fields WHERE ID IN
(#ListCreatedAbove#)
HTH
Dick
On Jul 2, 2004, at 2:29 PM, [EMAIL PROTECTED] wrote:
> Hi list,
> the following query "kills"
> all the duplicates
> in a query:
>
> <CFQUERY name="CollectArtikel_1" DATASOURCE="something">
> SELECT distinct ArtikelNum, Artikeltext
> FROM dbo.Artikeltext
> </CFQUERY>
>
> But I would like to view:��"Artikeltext"
> which is a memo-DB-field.
>
> How can I view this field ?
> Even if I am always getting the following error:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid columname
> 'Artikeltext'.
>
> Thanks for helping me !
>
> Uwe
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
