How do I pass database records to flash from a cfm page?

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>

Code (markup):

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

 

First of all, why do you have &CFresponse1=ok& instead of #CFresponse1=ok# ?
And, &CFresponse1=bad& instead of #CFresponse1=bad#

 

This is code I took from a login setup. It was set up with the "&" at the beginning and end. This part works though. I does pass the response as ok or bad. What I want to do is also pass a variable from a query to flash if the response is ok.