Using an <AS> tag in query i have problems in cfoutput.

Hello experts.
i have a query like:
<cfquery name="artikel" datasource="#dsn#">
SELECT a.Art_ID,a.User_ID, a.Kat_ID,............
Output:
<input name="imageField3" type="image" class="imageFieldresult" id="imageField3" onClick="MM_openBrWindow('Detailansicht.cfm?Art_ID=<cfoutput>#URLEncodedFormat(WADAdboartikel.Art_ID)#','','')</cfoutput>"src="images/<cfoutput>#WADAdboartikel.Photo1#</cfoutput>" align="right"  width="60
                        " height="44" />
Now when i use  the query :
SELECT a.Art_ID as AID,a.User_ID, a.Kat_ID,............
Ihave an error :Art_ID is undefined in artikel.
Any help?
Start Free Trial