Ask a Question related to Macromedia Flash Actionscript, Design and Development.
-
chrism59 webforumsuser@macromedia.com #1
Query returns first record everytime?
I have a .cfm page that takes an email address and qureies the database for proper record. The query seems not to accept the "where" statement and returns record 1 no matter what the email address is. Any suggestions?
Action script:
formData = new LoadVars();
formData.Email = Email;
agentReply = new LoadVars(); // then initialize all the fields
formData.sendAndLoad(submitURL, agentReply, "post");
This returns all the proper fields in the proper format.
CF code:
<cfsetting enablecfoutputonly="YES">
<cfcontent type = "application/x-www-urlform-encoded">
<cfset Email = form.Email>
<cfquery name="AgentInfo" datasource="register" username="Xplainitmedia" password="eim">
SELECT *
FROM Users
WHERE Email = Email
</cfquery>
*/ set return values
<cfprocessingdirective suppresswhitespace="Yes">
<cfoutput>
#returnToFlash#
</cfoutput>
</cfprocessingdirective>
This query ignors the email address passed and returns on the first record. HELP
chrism59 webforumsuser@macromedia.com Guest
-
#26132 [Bgs]: pg_fetch_object returns NULL on serial and INT in record but returns strings NP
ID: 26132 User updated by: steven at pearavenue dot com Reported By: steven at pearavenue dot com Status: Bogus Bug... -
#26132 [Opn->Bgs]: pg_fetch_object returns NULL on serial and INT in record but returns strings NP
ID: 26132 Updated by: iliaa@php.net Reported By: steven at pearavenue dot com -Status: Open +Status: ... -
#26132 [Opn]: pg_fetch_object returns NULL on serial and INT in record but returns strings NP
ID: 26132 User updated by: steven at pearavenue dot com Reported By: steven at pearavenue dot com Status: Open Bug... -
#26132 [NEW]: pg_fetch_object returns NULL on serial and INT in record but returns strings NP
From: steven at pearavenue dot com Operating system: Redhat 9.0/Apache 2.0 PHP version: 4.3.4 PHP Bug Type: PostgreSQL... -
Adding a new record when the record source is a query.
Hello All, I have a form that runs a query. The reason it runs on a query is because prior to it opening I have a form from which you can pick...



Reply With Quote

