|
|
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
|
|