This has me beat, and everybody else, it seems

I've created table within a member search page linked to an Access DB. From the
DB I extract the variables for Name, Address, Telephone number etc, and all
works well.

From the same database and within the same table I extract the members web and
email address.
Without using any addional code (like so:
:<%=(rsResults.Fields.Item("mlemail").Value)%> ) this shows up on the results
page, but in order to make the links active I've added '<a href="mailto:' and a
closing </a> tag
like so:
<a
href="mailto:<%=(rsResults.Fields.Item("mlemail"). Value)%>"><%=(rsResults.Fields
..Item("mlemail").Value)%></a>
and for the web address
<a href="<%=(rsResults.Fields.Item("mlWebsite").Value )%>"
target="_blank"><%=(rsResults.Fields.Item("mlWebsi te").Value)%></a>

and yet the result from this shows an empty blank field in the table, why is
it that by adding the extra code the result appears to be invisiable?

Sorry I'll paste the code outside this message box

Email address

<a
href="mailto:<%=(rsResults.Fields.Item("mlemail"). Value)%>"><%=(rsResults.Fields
..Item("mlemail").Value)%></a>

Website address

<a href="<%=(rsResults.Fields.Item("mlWebsite").Value )%>"
target="_blank"><%=(rsResults.Fields.Item("mlWebsi te").Value)%></a>

Ok paste the output from the program, ie the HTML.

Cheers,
Tom


On Wed, 7 Jul 2004 08:29:29 +0000 (UTC), "AlanShaw"
<webforumsuser (AT) macromedia (DOT) com> wrote:

I've created table within a member search page linked to an Access DB. From the
DB I extract the variables for Name, Address, Telephone number etc, and all
works well.

From the same database and within the same table I extract the members web and
email address.
Without using any addional code (like so:
:<%=(rsResults.Fields.Item("mlemail").Value)%> ) this shows up on the results
page, but in order to make the links active I've added '<a href="mailto:' and a
closing </a> tag
like so:
a
href="mailto:<%=(rsResults.Fields.Item("mlemail"). Value)%>"><%=(rsResults.Fields
.Item("mlemail").Value)%></a
and for the web address
a href="<%=(rsResults.Fields.Item("mlWebsite").Value )%>"
target="_blank"><%=(rsResults.Fields.Item("mlWebsi te").Value)%></a

and yet the result from this shows an empty blank field in the table, why is
it that by adding the extra code the result appears to be invisiable?

It's to do with cursors. See my article on the subject

http://www.charon.co.uk/content.aspx?CategoryID=30&ArticleID=6

ie. Cheange the CursorType of the recordset to 3.

--
Jules
http://www.charon.co.uk/charoncart
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

Hi Julian
I have tried what you advised but still no joy. I have not been able to get it
to work for a couple of weeks now, but it has been working. I don't believe
that I have changed anything. I posted the same question on another forum a
couple of days ago, with the completed code for the page. Those that answered
said that there was nothing wrong with my code. At one stage I put up 2 tables
on the same page, one with a red border and the other blue. In the red table I
enter the variable without the 'Mailto:' etc and in the blue one the variable
with 'mailto:' etc with. The result was the red table showed results and the
blue table was completey blank.

Just like me right now.

Did you change the CursorType of the recordset to 3? What does the code look
like now.

--
Jules
http://www.charon.co.uk/charoncart
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

Hi Julian
It must have been a hard day, I've done what you suggested and it works, BUT,
I've another problem now, although the links are now active, they don't work as
they should. I seem to be getting a 'double' result.

I'll attach the code, but see here: http://www.cai.org.uk/asp/installer.asp
choose England then Surrey
The website address does not take you there and the email address is strange.

<td><a
href="mailto:<%=(rsResults.Fields.Item("mlemail"). Value)%>"><%=(rsResults.Fields
..Item("mlemail").Value)%></a> </td>
</tr>
<tr class="sitemapheaders">
<td>&nbsp;</td>
<td><a
href="<%=(rsResults.Fields.Item("mlWebsite").Value )%>"
target="_blank"><%=(rsResults.Fields.Item("mlWebsi te").Value)%></a></td>

The fields should be text fields in Access, not hyperlink fields

--
Jules
http://www.charon.co.uk/charoncart
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004