Cold Fusion Datasource Not Working - Help!

[skadar]

I'm having trouble using a Cold Fusion template as a datasource for a
scrolling list within a Generator template. I feel as though I'm doing
everything 100% correctly, and it is just not working. Here's what I've
got.

My SWT has a scrolling list with this datasource:

http://123.123.123.123/mysite/myproject/demo/itemlistsql.cfm

I call my SWT from my Flash movie using getURL that calls "items.cfm" which
loads my SWT.

My datasource CFM file (itemlistsql.cfm) looks like this:

<cfsetting showdebugoutput=&quot;no&quot;>
<cfsetting enablecfoutputonly=&quot;Yes&quot;>
<cfquery name=&quot;getItemList&quot; datasource=&quot;#Application.DataSource#&quot;>
SELECT 'ItemNameList' AS Clip, ItemName, ItemID
FROM Items
ORDER BY ItemName
</cfquery>
<cfoutput>
<cfcontent type=&quot;text/plain&quot;>Clip,ItemName,ItemID
<cfloop from=&quot;1&quot; to=&quot;#getItemList.recordcount#&quot; index=&quot;i&quot;>
#getItemList.Clip#,&quot;#getItemList.ItemName#&quot;,&quot;#getItemList.ItemID#&quot;
</cfloop>
</cfoutput>

This page works perfectly, and when I view the source, the data is formatted
correctly. However, when I publish my SWT from Flash, I ALWAYS get the
error, &quot;CLIP column not found in datasource&quot;.

When I attempt to run my application, my SWT file comes up correctly, but
contains no data.

When I run my application using a text file as my datasource, it works
perfectly. If I use a hard datasource using the
&quot;fgjdbc:///?driver=sun.jdbc.odbc.JdbcOdbcDriver&quot; syntax, it works perfectly.
It just never works with a Cold Fusion datasource. I'm a very experienced
Cold Fusion developer and I've tried everything I can think of. Any hints?

Skadar