navigation
a webmaster learning community
     Home    Register     Search      Help      Login    
Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums
 

Advanced search
Recent Posts

 Todays Posts
 Most Active posts
 Posts since last visit
 My Recent Posts
 Mark posts read

Microsoft MVP

 

Need image w/hyperlink from ACCESS

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
Users viewing this topic: none
Printable Version 

All Forums >> Web Development >> ASP and Database >> Need image w/hyperlink from ACCESS 		Page: [1]
 
rockyraccoon

 

Posts: 14
Joined: 12/28/2004
Status: offline

  		Need image w/hyperlink from ACCESS - 1/5/2005 10:54:03   
Hi there, great forum.

I have FP2000 and need to insert a link, inside of the image properties coming from ACCESS. (i.e, click on the car thumbnail, go to that detail page).

I have the Data Results Table working, showing a separate link and a separate image (pulled from the table) but cant' seem to pull the the columns so you click on the image and execute the hyperlink.


Also, I can pull a hyperlink from ACCESS using actual HTML code in the column, but can't get the actual ACCESS Hyperlink to work. Subtle difference, but would like to use the ACCESS Hyperlink if possible.

Thanks in advance!
rocky raccoon
Spooky

 

Posts: 26603
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		RE: Need image w/hyperlink from ACCESS - 1/5/2005 12:12:12   
Do you have the code you are using?
If you are talking specifiically about the "hyperlink' type column, then its best to use a text column as the hyperlink column is used mainly in office applications

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)k¥


(in reply to rockyraccoon)
rockyraccoon

 

Posts: 14
Joined: 12/28/2004
Status: offline

  		RE: Need image w/hyperlink from ACCESS - 1/5/2005 12:36:51   
Spooky,
Thanks for the prompt reply.

I am currently using a text column (with anchored code), that is already working, so I'll leave that.

However, I still need to get an additional link working in conjunction with the thumbnail image.

I did not code this native, but am using the Database results stuff in FP2000.

This is what I am doing.

image ACCESS column contains file name of image
link ACCESS column contains HTML code for hyperlink/display text

Database results Column properties:
<<link>> just flag "contains html code" (this is working)
delete <<image>>, insert dummy pic, change image properties to include parameter "image". This display's the image pulled from the ACCESS table.

Now I need it to pull the link out of the ACCESS table and tie it to the image. I tried using the image properties and using parameter under "hyperlink", but that does not work.

I need to keep the link in a separate DBR table column, so that's not longer an issue. Just including a hyperlink for the pic.

Hope that's clear.

I can pull the actually FP generated stuff if you still want it.

(in reply to Spooky)
rockyraccoon

 

Posts: 14
Joined: 12/28/2004
Status: offline

  		RE: Need image w/hyperlink from ACCESS - 1/8/2005 19:33:33   
Haven't been able to do much with this, as my broadband has been out. :)


Since I'm not coding this native, do you still need to see the generated code? Everything else is in the previous post.

Any help would be greatly appreciated.

(in reply to rockyraccoon)
BeTheBall

 

Posts: 6362
Joined: 6/21/2002
From: West Point Utah USA
Status: offline

  		RE: Need image w/hyperlink from ACCESS - 1/8/2005 20:21:25   
Not positive I follow, but in case I do, try this:

In the db results, right click <<image>> and choose hyperlink. Delete everything listed in the URL textbox. Then click the button labeled, "Parameters". Click the button labled, "Insert Field Value". Choose the field that has your link from the list. Click "OK" twice and you are done. That is if I understand what you need to do.

_____________________________

Duane

Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.

(in reply to rockyraccoon)
rockyraccoon

 

Posts: 14
Joined: 12/28/2004
Status: offline

  		RE: Need image w/hyperlink from ACCESS - 1/9/2005 9:38:52   
Thanks. I tried this using the hyperlink/parameter, under the image properties, and it didn't work. I try it this way, and see what happens when my broadband comes back up (IF it ever comes back up, :) :) :)

To be clear all I am trying to do is to produce a thumbnail of a car, and when you click on the thumbnail you go to another page.

I have the image location and the URL in a database. I can pull the image, and pull the link, in separate columns. But I can't get them to work together.

regards,
rocky raccoon

(in reply to BeTheBall)
Spooky

 

Posts: 26603
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		RE: Need image w/hyperlink from ACCESS - 1/9/2005 14:17:37   
What does the column for the "link" actually contain? the full <a href=.....</a> code?

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)k¥


(in reply to rockyraccoon)
rockyraccoon

 

Posts: 14
Joined: 12/28/2004
Status: offline

  		RE: Need image w/hyperlink from ACCESS - 1/9/2005 19:40:42   
Yes, that is what it contains.

When listing the URL by itself, I just check "contains HTML code" under database results column properties.

But in the image case, the actual database results column is no longer there, as it's been substituted with a dummy image and then the parameter to pick up the image location from ACCESS.

Thanks, sorry this is so drawn out and sorry if I'm not explaining very well.


(in reply to Spooky)
BeTheBall

 

Posts: 6362
Joined: 6/21/2002
From: West Point Utah USA
Status: offline

  		RE: Need image w/hyperlink from ACCESS - 1/9/2005 21:49:19   
Can you post the code you are currently trying?

_____________________________

Duane

Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.

(in reply to rockyraccoon)
Spooky

 

Posts: 26603
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		RE: Need image w/hyperlink from ACCESS - 1/9/2005 23:10:26   
That makes it a little more difficult if it contains the full URL code.
You want to take a n image and then try and insert it into the middle of that URL code if I read you correctly.

eg - one field is "<a href=.....</a>" and you want it to become "<a href=.....><IMG SRC=...></a>"

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)k¥


(in reply to BeTheBall)
BeTheBall

 

Posts: 6362
Joined: 6/21/2002
From: West Point Utah USA
Status: offline

  		RE: Need image w/hyperlink from ACCESS - 1/10/2005 9:14:49   
OK, played with this a bit more and this seems to work well. I believe you mentioned that you already are displaying a picture right? If so, then the rest should be easy. In Normal View, right-click the image (which probably shows in FP as a broken image) and choose "Picture Properties". Click the tab labeled, "General". Then in the text box labeled, "Default hyperlink", enter:

<%=FP_FieldVal(fp_rs,"link")%>

That worked great for me.

_____________________________

Duane

Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.

(in reply to Spooky)
rockyraccoon

 

Posts: 14
Joined: 12/28/2004
Status: offline

  		RE: Need image w/hyperlink from ACCESS - 1/11/2005 18:11:30   
Sorry for the delay in responding. I still have my Internet out, at home.

Both of these solutions look like what I need. I'll try them as soon as I can and post the results.


THANKS!!!!!!

(in reply to BeTheBall)
Smokeeater9999

 

Posts: 5
Joined: 1/16/2005
Status: offline

  		RE: Need image w/hyperlink from ACCESS - 1/16/2005 19:02:46   
I am trying to do this a little differently and am running into a similiar issue. Instead of having an image file stored in my Access Database I have places a image file in my Database Results area, and am trying to link the parameters to it. I can link the appropriate field to the image, save it, etc., however when I click on the picture I get a 404 File not found error. The issue I believe is that the web address is adding my address in front of the link such as:

http://mysite.com//http://SiteToGo.com

I have tried changing the '<%=FP_FieldLink(fp_rs,"MapLink")%>' code to remove my web site address from the total hyperlink, but have not been successful.

Any help is greatly appreciate.

(in reply to rockyraccoon)
rockyraccoon

 

Posts: 14
Joined: 12/28/2004
Status: offline

  		RE: Need image w/hyperlink from ACCESS - 1/17/2005 11:36:51   
Both of these work great, depending on what you are trying to do.

For the image, I needed a column with the destination URL, with no "<a href....." to use the add parameter.


Thanks again!

(in reply to rockyraccoon)
BeTheBall

 

Posts: 6362
Joined: 6/21/2002
From: West Point Utah USA
Status: offline

  		RE: Need image w/hyperlink from ACCESS - 1/17/2005 11:59:19   
quote:

ORIGINAL: Smokeeater9999

I am trying to do this a little differently and am running into a similiar issue. Instead of having an image file stored in my Access Database I have places a image file in my Database Results area, and am trying to link the parameters to it. I can link the appropriate field to the image, save it, etc., however when I click on the picture I get a 404 File not found error. The issue I believe is that the web address is adding my address in front of the link such as:

http://mysite.com//http://SiteToGo.com

I have tried changing the '<%=FP_FieldLink(fp_rs,"MapLink")%>' code to remove my web site address from the total hyperlink, but have not been successful.

Any help is greatly appreciate.


Welcome to Outfront. When you look at the URL in HTML view, what is generated?

_____________________________

Duane

Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.

(in reply to Smokeeater9999)
Smokeeater9999

 

Posts: 5
Joined: 1/16/2005
Status: offline

  		RE: Need image w/hyperlink from ACCESS - 1/18/2005 11:40:18   
Duane,

I will get back to you on the HTML Code. I have been traveling, and will be back in a day or so.

Thanks.

(in reply to BeTheBall)
Smokeeater9999

 

Posts: 5
Joined: 1/16/2005
Status: offline

  		RE: Need image w/hyperlink from ACCESS - 1/20/2005 18:06:37   
Duane,

The image hyperlink is adding my web site address to the front of the URL, like this:

http://mysite.com//http://SiteToGo.com

and then it adds the location of the actual URL.

I am inserting my image into the database results area of my page. I don't really want to insert it into my access database, unless that is the only way to fix the problem. Doing so will give me several hundered image file in my database, which in turn will make it quite large in size.

Thanks for your help.

(in reply to BeTheBall)
BeTheBall

 

Posts: 6362
Joined: 6/21/2002
From: West Point Utah USA
Status: offline

  		RE: Need image w/hyperlink from ACCESS - 1/20/2005 18:28:16   
No, you shouldn't need to insert it into the db, in fact, I recommend against it. Now, let's make sure I understand you correctly. The image is displaying in the database results area just fine, right? But you want a link off of the image and that is not working, right? How is the URL stored in your database? Is it relative, say mypage.htm or literal, say, www.mysite.com/mypage.htm? Again, it would be helpful if you could post the html code for your page.

_____________________________

Duane

Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.

(in reply to Smokeeater9999)
rdouglass

 

Posts: 9265
From: Biddeford, ME USA
Status: offline

  		RE: Need image w/hyperlink from ACCESS - 1/21/2005 16:17:35   
Just my $.02

I've seen that prob before if you do something like this:

<a href="/<%=FP_FieldVal(fp_rs,"link")%>">

Have you tried just this:

<a href="<%=FP_Field(fp_rs,"link")%>">

Just a guess.

_____________________________

Don't take you're eye off your final destination.

ASP Checkbox Function Tutorial.

(in reply to BeTheBall)
Smokeeater9999

 

Posts: 5
Joined: 1/16/2005
Status: offline

  		RE: Need image w/hyperlink from ACCESS - 1/21/2005 20:50:21   
Duane,

I'm not sure what you mean by the HTML Code. Sorry.

(in reply to BeTheBall)
BeTheBall

 

Posts: 6362
Joined: 6/21/2002
From: West Point Utah USA
Status: offline

  		RE: Need image w/hyperlink from ACCESS - 1/21/2005 20:53:19   
In Frontpage, switch to HTML View, copy the code and paste it here.

_____________________________

Duane

Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.

(in reply to Smokeeater9999)
Smokeeater9999

 

Posts: 5
Joined: 1/16/2005
Status: offline

  		RE: Need image w/hyperlink from ACCESS - 1/22/2005 20:48:40   
Here is the code. I put some spaces in this code to show where the link is, and the second line is the image I inserted in the database results area. On the image, I assigned the appropriate paramerter (MapLink) to the image.

fp_sQry="SELECT * FROM qryDepartmentListWeb WHERE (Alpha = '::Alpha::') ORDER BY DepartmentName ASC"
fp_sDefault="Alpha="
fp_sNoRecords="Please select from the Drop-Down Search Box"
fp_sDataConn="IVFA_Dept"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice="DepartmentName"
fp_sMenuValue="DepartmentName"
fp_sColTypes="&RecordID=3&DepartmentName=202&Address=202&Hidden Address=202&City=202&Zip=5&District=202&County=202&Contact=202&ContactPosition=202&ContactPhone=202&Email=202&WebLink=203&MapLink=203&WebList=11&Alpha=202&"
fp_iDisplayCols=13
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="48792" --><p style="margin-top: 0; margin-bottom: 0">
<font face="Verdana" style="font-size: 9px">
<span style="font-size: 9pt; font-weight: 700">
<!--webbot bot="DatabaseResultColumn" s-columnnames="RecordID,DepartmentName,Address,Hidden Address,City,Zip,District,County,Contact,ContactPosition,ContactPhone,Email,WebLink,MapLink,WebList,Alpha" s-column="DepartmentName" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>DepartmentName<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"DepartmentName")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="42651" --></span></font></p>
<p style="margin-top: 0; margin-bottom: 0"><font face="Verdana">
<span style="font-size: 9pt; font-weight: 700">
<!--webbot bot="DatabaseResultColumn" s-columnnames="RecordID,DepartmentName,Address,Hidden Address,City,Zip,District,County,Contact,ContactPosition,ContactPhone,Email,WebLink,MapLink,WebList,Alpha" s-column="Address" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Address<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"Address")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="12103" --></span></font></p>
<p style="margin-top: 0; margin-bottom: 0"><font face="Verdana">
<span style="font-size: 9pt"><b>
<!--webbot bot="DatabaseResultColumn" s-columnnames="RecordID,DepartmentName,Address,Hidden Address,City,Zip,District,County,Contact,ContactPosition,ContactPhone,Email,WebLink,MapLink,WebList,Alpha" s-column="City" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>City<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"City")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="4267" --></b>, 
<b>
<!--webbot bot="DatabaseResultColumn" s-columnnames="RecordID,DepartmentName,Address,Hidden Address,City,Zip,District,County,Contact,ContactPosition,ContactPhone,Email,WebLink,MapLink,WebList,Alpha" s-column="Zip" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Zip<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"Zip")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="3973" --></b></span></font></p>
<p style="margin-top: 0; margin-bottom: 0"><font face="Verdana">
<span style="font-size: 9pt"><b>
<!--webbot bot="DatabaseResultColumn" s-columnnames="RecordID,DepartmentName,Address,Hidden Address,City,Zip,District,County,Contact,ContactPosition,ContactPhone,Email,WebLink,MapLink,WebList,Alpha" s-column="County" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>County<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"County")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="15566" -->
County</b></span></font></p>
<p style="margin-top: 0; margin-bottom: 0"> </p>
<p style="margin-top: 0; margin-bottom: 0"><font face="Verdana">
<span style="font-size: 9pt"><font color="#800000">District:</font> <b><!--webbot bot="DatabaseResultColumn" s-columnnames="RecordID,DepartmentName,Address,Hidden Address,City,Zip,District,County,Contact,ContactPosition,ContactPhone,Email,WebLink,MapLink,WebList,Alpha" s-column="District" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>District<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"District")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="15457" --></b></span></font></p>
<p style="margin-top: 0; margin-bottom: 0"><font face="Verdana">
<span style="font-size: 9pt"><font color="#800000">Contact:</font> <b><!--webbot bot="DatabaseResultColumn" s-columnnames="RecordID,DepartmentName,Address,Hidden Address,City,Zip,District,County,Contact,ContactPosition,ContactPhone,Email,WebLink,MapLink,WebList,Alpha" s-column="Contact" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Contact<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"Contact")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="13525" --></b>;</span></font><font face="Verdana" style="font-size: 9px"><span style="font-size: 9pt"> <b><!--webbot bot="DatabaseResultColumn" s-columnnames="RecordID,DepartmentName,Address,Hidden Address,City,Zip,District,County,Contact,ContactPosition,ContactPhone,Email,WebLink,MapLink,WebList,Alpha" s-column="ContactPosition" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>ContactPosition<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"ContactPosition")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="41314" --></b></span></font></p>
<p style="margin-top: 0; margin-bottom: 0">
<font face="Verdana" style="font-size: 9pt" color="#800000">Phone</font><font face="Verdana" style="font-size: 9px"><span style="font-size: 9pt"><font color="#800000">:</font> <b><!--webbot bot="DatabaseResultColumn" s-columnnames="RecordID,DepartmentName,Address,Hidden Address,City,Zip,District,County,Contact,ContactPosition,ContactPhone,Email,WebLink,MapLink,WebList,Alpha" s-column="ContactPhone" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>ContactPhone<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"ContactPhone")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="31791" --></b>  
</span></font><font face="Verdana"><span style="font-size: 9pt">
<font color="#800000">Email:</font> <b><!--webbot bot="DatabaseResultColumn" s-columnnames="RecordID,DepartmentName,Address,Hidden Address,City,Zip,District,County,Contact,ContactPosition,ContactPhone,Email,WebLink,MapLink,WebList,Alpha" s-column="Email" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Email<font size="-1">&gt;&gt;</font>" s-ColumnTypes="3,202,202,202,202,5,202,202,202,202,202,202,203,203,11,202" startspan --><%=FP_FieldVal(fp_rs,"Email")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="8328" --> </b></span></font></p>
<p style="margin-top: 0; margin-bottom: 0">
<font face="Verdana" style="font-size: 9pt" color="#800000">Map Link</font><font face="Verdana" style="font-size: 9px"><span style="font-size: 9pt"><font color="#800000">:</font> 




<a href="'<%=FP_FieldLink(fp_rs,"MapLink")%>'">
<img border="0" src="images/New%20&%20Updates/Test.jpg" width="42"




height="12"></a></span></font></p>[/color]<p style="margin-top: 0; margin-bottom: 0">
<font face="Verdana" style="font-size: 9pt" color="#800000">Web Link</font><font face="Verdana" style="font-size: 9px"><span style="font-size: 9pt"><font color="#800000">: </font><!--webbot bot="DatabaseResultColumn" s-columnnames="RecordID,DepartmentName,Address,Hidden Address,City,Zip,District,County,Contact,ContactPosition,ContactPhone,Email,WebLink,MapLink,WebList,Alpha" s-column="WebLink" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="TRUE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font><a href=".">WebLink</a><font size="-1">&gt;&gt;</font>" s-ColumnTypes="3,202,202,202,202,5,202,202,202,202,202,202,203,203,11,202" startspan --><%="<a href=""" & FP_FieldLink(fp_rs,"WebLink") & """>" & FP_FieldVal(fp_rs,"WebLink") & "</a>"%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="16387" --></span></font></p>
<p style="margin-top: 0; margin-bottom: 0">
</p>
<hr>
<p style="margin-top: 0; margin-bottom: 0"> </p>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE" b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside tag="BODY" preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00"><font color="#000000">This is the end of a Database Results region.</font></td></tr></table>" startspan --><!--#include file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" --></body></html>

(in reply to BeTheBall)
Page:   [1]

All Forums >> Web Development >> ASP and Database >> Need image w/hyperlink from ACCESS 		Page: [1]
Jump to: 1





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts


Back to top

  Microsoft Corporation in no way endorses or is affiliated with "OutFront."
  OutFront is published and edited by Thomas Brunt.
  440 Great Circle Dr., St. Matthews, SC 29135.
  © 2008 All Rights Reserved
  Click here to view our privacy statement.