Webmaster Forum / Flash / Flash Remoting / June 2007

I'm trying to display data in Flash pulled from an Access database.  I was
using the tutorial on the Data Connection Wizard and just entering my own
information.  My web service connection works because it pulls up the right
functions from my .cfc and the Data Connection Wizard appears to work fine but
when I test the movie, no data shows up.  I tested the .cfc by creating a
dynamic table in a .cfm and it works perfectly.  Here's the cffunction I'm
trying to use

<!-- Get all the Guide info for guides in the SW Region -->
<!-- Used in directory.fla -->
<cffunction name="getSwGuides" access="remote" returntype="query">
      <cfquery name="swGuides" datasource="guide" username="" password="">
  SELECT *
FROM Profile
WHERE guideState = 'AZ'
OR guideState = 'NM'
OR guideState = 'OK'
OR guideState = 'TX'
  </cfquery>
  <cfreturn swGuides>
</cffunction>

Any ideas on what I'm doing wrong?