<br><font size=2 face="sans-serif">Hi Charley,</font>
<br><font size=2 face="sans-serif">(I had to send this twice, because the
maplab list bounced the first message back to me)</font>
<br>
<br><font size=2 face="sans-serif">Thanks for your help. Unfortunately,
I do not have the function working yet, but I feel I am close. </font>
<br><font size=2 face="sans-serif">In your posting, are the characters
"==" and "||" valid php syntax?</font>
<br><font size=2 face="sans-serif">Also, your posting is just a portion
of your query.phtml file right? Or is that your entire query.phtml
file?</font>
<br>
<br><font size=2 face="sans-serif">Below is my code, for the areas where
I describe my columns of the attribute table. Do you see any thing
that appears incorrect?</font>
<br><font size=2 face="sans-serif">The URL (with photo name) to my jpegs
is contained in the column "MS_PATH", the column "photo"
contains only the photo name.</font>
<br>
<br><font size=2 face="Courier New">// loop and use key for titles</font>
<br><font size=2 face="Courier New">
foreach ($aRows[0] as $key => $value)</font>
<br><font size=2 face="Courier New">
{</font>
<br><font size=2 face="Courier New">
//***********ADDED
FOR HYPERLINK</font>
<br><font size=2 face="Courier New">
if (strcasecmp($key,
"Long_DD") = "Long_DD";</font>
<br><font size=2 face="Courier New">
strcasecmp($key,
"Lat_DD") = "Lat_DD";</font>
<br><font size=2 face="Courier New">
strcasecmp($key,
"photo") = "photo";</font>
<br><font size=2 face="Courier New">
strcasecmp($key,
"MS_PATH") = "MS_PATH")</font>
<br><font size=2 face="Courier New">
</font>
<br><font size=2 face="Courier New">
//********************************</font>
<br><font size=2 face="Courier New">
$szReturnValue .= "<td bgcolor=\"E2EFF5\"><font
face=\"Arial, Helvetica, sans-serif\" size=\"2\">".$key."</font></td>\n";</font>
<br><font size=2 face="Courier New">
}</font>
<br>
<br><font size=2 face="sans-serif">*************************</font>
<br>
<br><font size=2 face="Courier New">//Look for the attribute value in column
of Job_no, location, siteplan and //summary_2</font>
<br><font size=2 face="Courier New">
if (strcasecmp($key, "Long_DD")
= "Long_DD";</font>
<br><font size=2 face="Courier New">
strcasecmp($key, "Lat_DD")
= "Lat_DD" )</font>
<br><font size=2 face="Courier New">
{$szReturnValue .= "<td bgcolor=\"#ffffff\"><font
face=\"Arial, Helvetica, sans-serif\" size=\"2\">".
$xCell."</font></td>\n";}</font>
<br>
<br><font size=2 face="Courier New">
else if (strcasecmp($key, "photo")
= "photo";</font>
<br><font size=2 face="Courier New">
strcasecmp($key,
"MS_PATH") = "MS_PATH" )</font>
<br><font size=2 face="Courier New">
//$xCell
is the attribute value in URL format such as http://localhost/test/test.pdf</font>
<br><font size=2 face="Courier New">
</font>
<br><font size=2 face="Courier New">
{$szReturnValue .= "<td bgcolor=\"#ffffff\">
<a href=\"".$xCell."\"> Click here to document</a></td>\n";}
</font>
<br><font size=2 face="Courier New">
}</font>
<br><font size=2 face="Courier New">
$szReturnValue .= "</tr>\n";</font>
<br><font size=2 face="Courier New">
}</font>
<br>
<br><font size=2 face="sans-serif">********************</font>
<br>
<br><font size=2 face="sans-serif">Thanks!</font>
<br>
<br><font size=2 face="sans-serif">Kevin<br>
</font>
<p><font size=2 color=blue face="Times New Roman">______________________________</font><font size=5 color=blue face="Times New Roman"><br>
Baird </font><font size=2 color=blue face="Times New Roman"><i><br>
Innovation, Excellence, & Service</i></font><font size=3> </font><font size=2 color=blue face="Times New Roman"><i><br>
Oceans, Lakes & Rivers</i></font><font size=2 face="Times New Roman"><b><br>
Kevin Grootendorst </b><br>
905-845-5385 phone 905-845-0698 fax<br>
627 Lyons Lane, Suite 200<br>
Oakville, Ontario, Canada L6J 5Z7 </font><font size=2 color=blue face="Times New Roman"><u><br>
</u></font><a href=mailto:kgrootendorst@baird.com><font size=2 color=blue face="Times New Roman"><u>mailto:kgrootendorst@baird.com</u></font></a><font size=3>
</font><a href=http://www.baird.com/ target=_blank><font size=2 color=blue face="Times New Roman"><u>http://www.baird.com/</u></font></a><font size=3>
</font><font size=5 color=blue face="Times New Roman"><br>
______________________________</font>