Need image w/hyperlink from ACCESS (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

rockyraccoon -> 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 -> 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



rockyraccoon -> 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.



rockyraccoon -> 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.



BeTheBall -> 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.



rockyraccoon -> 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



Spooky -> 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?



rockyraccoon -> 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.




BeTheBall -> RE: Need image w/hyperlink from ACCESS (1/9/2005 21:49:19)

Can you post the code you are currently trying?



Spooky -> 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>"



BeTheBall -> 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.



rockyraccoon -> 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!!!!!!



Smokeeater9999 -> 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.



rockyraccoon -> 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!



BeTheBall -> 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?



Smokeeater9999 -> 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.



Smokeeater9999 -> 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.



BeTheBall -> 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.



rdouglass -> 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.



Smokeeater9999 -> 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.



BeTheBall -> 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.



Smokeeater9999 -> 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>



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.09375