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]