How do I return database record to flash from cfm page

programming flash
1

I downloaded a flash login setup and have been trying to revise it to my specific needs.

I have the login function working in that when they enter a valid username and password, they are directed to the correct frame in flash.

What I want to do is for a specific field record from my Access database to be diplayed on that page. Let’s say, I have a field called “PetName”

Right now, the coldfusion setup is set to give a thumbs up or down as far as access. Here is the code:

<cfsetting enablecfoutputonly=“Yes”>

<cfquery name=“ClientLogin” datasource=“DSN name setup here”>
SELECT *
FROM Clients
WHERE Customer = ‘#form.usr#’
AND Secret = ‘#form.pw#’
</cfquery>

<cfoutput>
<cfif #ClientLogin.recordcount# is ‘1’>
&CFresponse1=ok&
<cfelseif #ClientLogin.recordcount# is ‘0’>
&CFresponse1=bad&
</cfif>
</cfoutput>

What would I need to add to this code for it to send the data from the field “PetName” along with the ok or bad response?

Also, from within flash, what code would I need to display that record? Something to this affect:

loadVariables(“f22clientlogin.cfm”, _root.form);
Name = _root.form.PetName;

This flash is setup so that on the root level, various movieclips are loaded throughout the process, hence the root level references.

Thanks,
Dave