<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Arial","sans-serif";
color:navy;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:595.3pt 841.9pt;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body bgcolor=white lang=EN-US link=blue vlink=blue>
<div class=Section1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Roger,<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Since the equal sign is a special character for URLs, it is a
good idea to not use them in your data if possible. If you must use the
equal signs, you should URL encode them to ensure they work everywhere.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>In FileMaker there is the GetAsURLEncoded() function, and in PHP
there is the rawurlencode() function.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Andrew Denman<o:p></o:p></span></p>
</div>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
fx.php_list-bounces@mail.iviking.org
[mailto:fx.php_list-bounces@mail.iviking.org] <b>On Behalf Of </b>Steve Winter<br>
<b>Sent:</b> Tuesday, March 04, 2008 9:15 AM<br>
<b>To:</b> 'FX.php Discussion List'<br>
<b>Subject:</b> RE: [FX.php List] [OFF] sending email confirmation<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span lang=EN-GB style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>Hi Roger,<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-GB style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-GB style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>I presume that the presence of the two == are a function of
base64_encode…?? If not, what purpose do they serve…? <o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-GB style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-GB style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>Perhaps using an alternative encoding method (eg md5) might resolve
the issue, since it would not result in == characters…??<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-GB style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-GB style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>Cheers<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-GB style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>Steve<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-GB style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'><o:p> </o:p></span></p>
<div>
<div class=MsoNormal align=center style='text-align:center'>
<hr size=2 width="100%" align=center>
</div>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
fx.php_list-bounces@mail.iviking.org
[mailto:fx.php_list-bounces@mail.iviking.org] <b>On Behalf Of </b>Roger Price<br>
<b>Sent:</b> 04 March 2008 15:10<br>
<b>To:</b> FX.php Discussion List<br>
<b>Subject:</b> [FX.php List] [OFF] sending email confirmation</span><o:p></o:p></p>
</div>
<p class=MsoNormal><span lang=EN-GB><o:p> </o:p></span></p>
<div>
<p class=MsoNormal><span lang=EN-GB style='font-size:10.0pt;font-family:"Courier New"'>As
part of a web project I am collecting data from our some of our past students
that we have lost contact with.</span><span lang=EN-GB><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=EN-GB> <o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=EN-GB style='font-size:10.0pt;font-family:"Courier New"'>I
want to try to ensure that we don't get too many malicious returns so I intend
to send a confirmation to the entered email address with an activation link.</span><span
lang=EN-GB><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=EN-GB> <o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=EN-GB style='font-size:10.0pt;font-family:"Courier New"'>So
far so good!</span><span lang=EN-GB><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=EN-GB> <o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=EN-GB style='font-size:10.0pt;font-family:"Courier New"'>In
order that the database record key is not blatantly obvious I'm using base64_encode!</span><span
lang=EN-GB><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=EN-GB> <o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=EN-GB style='font-size:10.0pt;font-family:"Courier New"'>however
when I mail a link such as: </span><span lang=EN-GB> </span><span
lang=EN-GB style='font-size:10.0pt;font-family:"Courier New"'><a
href="http://www.xxx.xxx.xx.xx..edit2.html?rec=MDAwMQ"><span style='font-size:
12.0pt;font-family:"Times New Roman","serif"'>http://www.xxx.xxx.xx.xx..edit2.html?rec=MDAwMQ</span></a></span><span
lang=EN-GB>==</span><span lang=EN-GB style='font-size:10.0pt;font-family:"Courier New"'><o:p></o:p></span></p>
<p><span lang=EN-GB style='font-size:10.0pt;font-family:"Courier New"'>the two
'=' characters that are generated at the end of this particular record are
omitted from the hyperlink when viewed in Outlook Express or Windows Mail.
Entourage only omits one! However Outlook and my webmail program work
perfectly.<o:p></o:p></span></p>
<p><span lang=EN-GB style='font-size:10.0pt;font-family:"Courier New"'>If
anybody resolved this problem before I would be grateful to know the best way.<o:p></o:p></span></p>
<p><span lang=EN-GB style='font-size:10.0pt;font-family:"Courier New"'>Roger <o:p></o:p></span></p>
<p><span lang=EN-GB style='font-size:10.0pt;font-family:"Courier New"'> <o:p></o:p></span></p>
<p><span lang=EN-GB style='font-size:10.0pt;font-family:"Courier New"'> <o:p></o:p></span></p>
</div>
</div>
</body>
</html>