asp_databases thread: Dynamic Links from a Access Databse
Message #1 by Simon Goldsmith <Simon@A...> on Thu, 26 Apr 2001 09:23:17 +0100
|
|
I am wondering if someone can help me.
I have an access database an it contains URLS and Email addresses as text.
I want to output these URLS and Email addresses to a page so that they
actually work and people can click them.
What is the best way for me to accomplish this task?
My table containing this data is called: dwfClientsUK
The URl firl s called: ClientWebsite
The Email field is called: ClientEmail
Cheers
Simon
Message #2 by "Ken Schaefer" <ken@a...> on Thu, 26 Apr 2001 23:48:03 +1000
|
|
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: I have an access database an it contains URLS and Email addresses as text.
: I want to output these URLS and Email addresses to a page so that they
: actually work and people can click them.
:
: What is the best way for me to accomplish this task?
:
: My table containing this data is called: dwfClientsUK
: The URl firl s called: ClientWebsite
: The Email field is called: ClientEmail
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Create a recordset, and create the necessary HTML...
<a href="<% =objRS("ClientWebsite")%>">Click Here to visit <%
=objRS("ClientWebsite")%></a>
<a href="mailto:<% =objRS("ClientEmail")%>">Click here to email <%
=objRS("ClientEmail")%></a>
Chers
Ken
Message #3 by "Jesse Slater" <jslater@n...> on Sat, 28 Apr 2001 01:50:52
|
|
I have a similar problem. I run an SQL query and the results are
displayed in a tabular format. It is needed that one of these columns the
problem Report Number column numbers be listed as links. I currently have
them as links, but I'm having trouble because these links need to take the
user to a page which displays the record in a HTML Text field page. How
can I know which problem report number they clicked on and generate the
correct corresponding page. Thanks
Jesse
>
> Create a recordset, and create the necessary HTML...
>
> <a href="<% =objRS("ClientWebsite")%>">Click Here to visit <%
> =objRS("ClientWebsite")%></a>
>
> <a href="mailto:<% =objRS("ClientEmail")%>">Click here to email <%
> =objRS("ClientEmail")%></a>
>
> Chers
> Ken
>
Message #4 by Gregory_Griffiths@c... on Mon, 30 Apr 2001 09:10:31 +0100
|
|
you could try some Javascript to give each row a value and then pass
that value into a funciton that acts depending on the value.
> -----Original Message-----
> From: jslater@n... [mailto:jslater@n...]
> Sent: 28 April 2001 01:51
> To: asp_databases@p...
> Cc: jslater@n...
> Subject: [asp_databases] Re: Dynamic Links from a Access Databse
>
>
> I have a similar problem. I run an SQL query and the results are
> displayed in a tabular format. It is needed that one of
> these columns the
> problem Report Number column numbers be listed as links. I
> currently have
> them as links, but I'm having trouble because these links
> need to take the
> user to a page which displays the record in a HTML Text field
> page. How
> can I know which problem report number they clicked on and
> generate the
> correct corresponding page. Thanks
>
> Jesse
> >
> > Create a recordset, and create the necessary HTML...
> >
> > <a href="<% =objRS("ClientWebsite")%>">Click Here to visit <%
> > =objRS("ClientWebsite")%></a>
> >
> > <a href="mailto:<% =objRS("ClientEmail")%>">Click here to email <%
> > =objRS("ClientEmail")%></a>
> >
> > Chers
> > Ken
> >
>
|
View Cart
