I need help with a small problem. I have a ASP web page built through Frontpage. It has a MS Access database in the background to store the information. In one case the web page is showing a Point of Contact page, based off a Access table. One of the fields in that table is for E-mail address. I need to figure out how to tell the SQL commands on the actual web page, to take the data in that field of the access table, and make it a "mailto:" hyperlink. I think it can be done, i just don't know how to do it.....<br><br><br>IF anyone can help....i would really appreciate it.<br><br>Dynapen
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Insteringn a Mailto: Hyperlink command in SQL.
- Thread starter Dynapen
- Start date
If I understood you problem then this should help<br>Your query to get the mailto field should look like this<br>select 'mailto: ' + field_name AS EMail<br>from table_name<br><br>if the records in your table look like this:<br><A HREF="mailto:abc@abc.com">abc@abc.com</A><br><A HREF="mailto:cde@cde.com">cde@cde.com</A><br>SQL will bring them to you like this:<br>mailto: <A HREF="mailto:abc@abc.com">abc@abc.com</A><br>mailto: <A HREF="mailto:cde@cde.com">cde@cde.com</A><br><br>I hope this helps any.<br><br>Ian.
- Status