cfmail 1

[brianjay]

Hi,
I'm stuck on an e-mail problem. I'm sending the URL with a persons userID and a random password. The e-mail gets through nicely, but when the action page comes up, it has a problem verifying both bits of info. Can anyone see what I'm doing wrong. The "API." fields are in the database.

Thank you,
brianjay

MAIL PAGE

<CFMAIL
QUERY=&quot;nds&quot;
TO=&quot;#APIObject#@jhmi.edu&quot;
FROM=&quot;employee@jhu.edu&quot; SUBJECT=&quot;test&quot;
>

http://server/0103Modify.cfm?userID=#APIObject#?dixiecup=#APIPassword#

</CFMAIL>


ACTION PAGE

<cfquery DATASOURCE=&quot;apidb&quot; NAME=&quot;NDS&quot;>
SELECT * FROM nds ORDER BY APIObject, APIpassword
</cfquery>

<CFIF IsDefined (&quot;dixiecup&quot>

<CFOUTPUT QUERY=&quot;nds&quot; GROUP=&quot;APIObject&quot;>
<CFFORM ACTION=&quot;0103update.cfm&quot; METHOD=&quot;POST&quot;>
<INPUT TYPE=&quot;Hidden&quot; NAME=&quot;index&quot; VALUE=&quot;#index#&quot;>
<TABLE WIDTH=&quot;400&quot; CELLPADDING=&quot;1&quot; CELLSPACING=&quot;1&quot;
BGCOLOR=&quot;Silver&quot;>
<TR><!--- userID --->
<TH ALIGN=&quot;right&quot; WIDTH=&quot;108&quot;>
<B><FONT SIZE=&quot;2&quot;
FACE=&quot;Arial&quot;>UserID : </FONT></B>
</TH>
<CFOUTPUT>
<TD WIDTH=&quot;286&quot;><B>
<FONT SIZE=&quot;3&quot; FACE=&quot;Arial&quot; COLOR=&quot;Blue&quot;>
#APIobject#
</FONT></B>
</TD>
</CFOUTPUT>
</TR>
<TR><!--- last name--->
<TH ALIGN=&quot;right&quot; WIDTH=&quot;108&quot;>
<B><FONT SIZE=&quot;2&quot; FACE=&quot;Arial&quot;>Last
Name : </FONT></B>
</TH>
<CFOUTPUT>
<TD WIDTH=&quot;286&quot;><B><FONT SIZE=&quot;3&quot;
FACE=&quot;Arial&quot; COLOR=&quot;Blue&quot;> #APIlastname#</FONT></B>
</TD>
</CFOUTPUT>
</TR>
</CFFORM>
</CFOUTPUT>
<CFELSE>
the program failed
</CFIF>

 

[GunJack]

I think your problem may be that you're using a question mark instead of an ampersand in your url. The question mark should start the beginning of the url string and the ampersand should be used to separate variable/value pairs. Here's an example.

scriptName.cfm?var1=1&var2=2&var3=3....

If you change your second question mark to an ampersand, I think it will work.

Good luck,
GJ

 

[strantheman]

hi brianjay,

I see where #APIobject# comes from (the url), but I don't see where you're setting #APIlastname#.

Also, what is your query doing?

<cfquery DATASOURCE=&quot;apidb&quot; NAME=&quot;NDS&quot;>
SELECT * FROM nds ORDER BY APIObject, APIpassword
</cfquery>

You have no WHERE clause that might get you some info based on who's info is being passed in the url.

Let me know if I helped.

 

[brianjay]

GunJack,
Thank you, Thank you, THANK YOU. It was so easy, I don't know how I missed it except to say that I couldn't find it in any of my books. Program is running fine and I'm glad you could help me.

Brianjay

 

[GunJack]

Glad I could help

GJ