hyperlink field in access and ultradev

[credo]

I have an access db with a column set up as hyperlink containing website URLs. This data is dynamically retrieved into a DW Ultradev page. I want users to be able to click on the this hyperlink within the web page.

When retrieving this column data into DW Ultradev I notice that #'s have been put outside the url so that it's #

http://www.myURL.com#

when testing the SQL.

Therefore when viewing the page in the browser it then shows up as #

http://www.myURL.com#

ie. it is not clickable.

Do I need to change the column type field in Access to normal text instead of a hyperlink ? Also how do I specify to open the link in a new window using _blank ?

thanks in advance.

 

[Dorff]

I would recommend changing the column type to just a plain string type. That would make them easier to deal with. About your second question with the _blank, I'm know at some point in order for your user to click on the link you have to put it into an <a href=?>. Basically all you have to do is add in target=&quot;_blank&quot;.

Here's an example:
<a href=&quot;<%=Recordset1.Fields.Item(&quot;YourLinkColumn&quot.Value%>&quot; target=&quot;_blank&quot;>Link Name</a>
Ryan
rmindorff@hotmail.com

 

[credo]

thanks Ryan - that worked.... I now have text retrieved from the datasbe that becomes a hyperlink that is clickable.

One final thing I'd like to do is set Alt or Title text for these dynamic rollover links. Here's the code :

<td valign=&quot;top&quot; colspan=&quot;3&quot; class=&quot;small&quot;><a href=&quot;<%=(rs_getCom.Fields.Item(&quot;email1&quot.Value)%>&quot;><%=(rs_getCom.Fields.Item(&quot;email1&quot.Value)%></a> </td>

such as &quot;Click to e-mail author&quot; - is this possible ? I'm not sure where to put the alt/title tag in the above html string.

 

[derren]

Just tack

alt=&quot;your text&quot;

onto the end of your link:

<a href=&quot;<%=(rs_getCom.Fields.Item(&quot;email1&quot;).Value)%>&quot; alt=&quot;your text&quot;>

To be honest though, if you need to do something like this again just do a normal, undynamic whatever in Ultradev and use the properties inspector to change the values, then look at the resultant code to see what you need to add. That'll save you a heck of a lot of time.

Derren
[Mediocre talent - spread really thin]