|
 |
asp_web_howto thread: Hyperlink with asp database
Message #1 by "Andy" <andy@t...> on Thu, 6 Mar 2003 04:17:55 +0800
|
|
Hello,
I am trying to pass some value to another page using the hyperlink with asp
but have no idea how this can be done.
<%Response.write "<a
href=remove.asp?confirm=rsAuthors("id")>Remove</a></font></td>>"%>
I have field id in one of my database table.
Hope someone might be able to help.
Thanks
ANdy
Message #2 by Mark Eckeard <meckeard2000@y...> on Wed, 5 Mar 2003 12:33:18 -0800 (PST)
|
|
Is the ID coming back from the database? If so, try
this:
<%
response.write "<a href=""remove.asp?confirm=""" &
rsAuthors("id") & """>Remove</a></font></td>"
%>
--- Andy <andy@t...> wrote:
> Hello,
>
> I am trying to pass some value to another page using
> the hyperlink with asp
> but have no idea how this can be done.
>
> <%Response.write "<a
>
href=remove.asp?confirm=rsAuthors("id")>Remove</a></font></td>>"%>
>
> I have field id in one of my database table.
>
>
> Hope someone might be able to help.
>
>
> Thanks
>
>
> ANdy
>
>
>
__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/
Message #3 by "Andy" <andy@t...> on Thu, 6 Mar 2003 04:46:00 +0800
|
|
Hello Mark,
Thanks for the advice.I have try with your codes and try to print out the
value that I should get on the remove.asp by issuing the response.write
command but unfortunatelly I didnt get any value return.
original page
=============
<tr>
<td width="58%" height="11"><font face="Verdana" size="1.5"><%
response.write rsAuthors("category")%></font></td>
<td width="23%" height="11">
<p align="center"><font face="Verdana" size="2">
<%response.write "<a href=""remove.asp?confirm=""" &
rsAuthors("id")&""">Remove</a></font></td>"%>
<% rsAuthors.MoveNext%>
<% Wend %>
<%
rsAuthors.Close
Set rsAuthors = Nothing
adoConn.Close
set adoConn = Nothing
%>
</tr>
Remove.asp
==========
<%
Dim id
id = Request.QueryString("confirm")
Response.write id
%>
Thanks
Andy
----- Original Message -----
From: "Mark Eckeard" <meckeard2000@y...>
To: "ASP Web HowTo" <asp_web_howto@p...>
Sent: Thursday, March 06, 2003 4:33 AM
Subject: [asp_web_howto] Re: Hyperlink with asp database
> Is the ID coming back from the database? If so, try
> this:
>
> <%
> response.write "<a href=""remove.asp?confirm=""" &
> rsAuthors("id") & """>Remove</a></font></td>"
> %>
>
> --- Andy <andy@t...> wrote:
> > Hello,
> >
> > I am trying to pass some value to another page using
> > the hyperlink with asp
> > but have no idea how this can be done.
> >
> > <%Response.write "<a
> >
> href=remove.asp?confirm=rsAuthors("id")>Remove</a></font></td>>"%>
> >
> > I have field id in one of my database table.
> >
> >
> > Hope someone might be able to help.
> >
> >
> > Thanks
> >
> >
> > ANdy
> >
> >
> >
>
>
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Tax Center - forms, calculators, tips, more
> http://taxes.yahoo.com/
>
>
>
Message #4 by "Andy" <andy@t...> on Thu, 6 Mar 2003 05:07:50 +0800
|
|
Hello,
Ok , I try to view the source of the original page and the value from the
database is there.But why the value cannot be get on the remove.asp page?
Thanks
Andy
----- Original Message -----
From: "Mark Eckeard" <meckeard2000@y...>
To: "ASP Web HowTo" <asp_web_howto@p...>
Sent: Thursday, March 06, 2003 4:33 AM
Subject: [asp_web_howto] Re: Hyperlink with asp database
> Is the ID coming back from the database? If so, try
> this:
>
> <%
> response.write "<a href=""remove.asp?confirm=""" &
> rsAuthors("id") & """>Remove</a></font></td>"
> %>
>
> --- Andy <andy@t...> wrote:
> > Hello,
> >
> > I am trying to pass some value to another page using
> > the hyperlink with asp
> > but have no idea how this can be done.
> >
> > <%Response.write "<a
> >
> href=remove.asp?confirm=rsAuthors("id")>Remove</a></font></td>>"%>
> >
> > I have field id in one of my database table.
> >
> >
> > Hope someone might be able to help.
> >
> >
> > Thanks
> >
> >
> > ANdy
> >
> >
> >
>
>
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Tax Center - forms, calculators, tips, more
> http://taxes.yahoo.com/
>
>
>
Message #5 by Mark Eckeard <meckeard2000@y...> on Wed, 5 Mar 2003 15:54:12 -0800 (PST)
|
|
I would guess that you are not getting the value from
the database. Check you code that returns the ID and
make sure it's getting returned in the recordset.
Mark
--- Andy <andy@t...> wrote:
> Hello Mark,
>
> Thanks for the advice.I have try with your codes and
> try to print out the
> value that I should get on the remove.asp by issuing
> the response.write
> command but unfortunatelly I didnt get any value
> return.
>
> original page
> =============
> <tr>
> <td width="58%" height="11"><font face="Verdana"
> size="1.5"><%
> response.write rsAuthors("category")%></font></td>
> <td width="23%" height="11">
> <p align="center"><font face="Verdana" size="2">
> <%response.write "<a
> href=""remove.asp?confirm=""" &
> rsAuthors("id")&""">Remove</a></font></td>"%>
> <% rsAuthors.MoveNext%>
> <% Wend %>
> <%
> rsAuthors.Close
> Set rsAuthors = Nothing
> adoConn.Close
> set adoConn = Nothing
> %>
> </tr>
>
> Remove.asp
> ==========
> <%
>
> Dim id
> id = Request.QueryString("confirm")
>
> Response.write id
>
> %>
>
> Thanks
>
> Andy
>
> ----- Original Message -----
> From: "Mark Eckeard" <meckeard2000@y...>
> To: "ASP Web HowTo" <asp_web_howto@p...>
> Sent: Thursday, March 06, 2003 4:33 AM
> Subject: [asp_web_howto] Re: Hyperlink with asp
> database
>
>
> > Is the ID coming back from the database? If so,
> try
> > this:
> >
> > <%
> > response.write "<a href=""remove.asp?confirm=""" &
> > rsAuthors("id") & """>Remove</a></font></td>"
> > %>
> >
> > --- Andy <andy@t...> wrote:
> > > Hello,
> > >
> > > I am trying to pass some value to another page
> using
> > > the hyperlink with asp
> > > but have no idea how this can be done.
> > >
> > > <%Response.write "<a
> > >
> >
>
href=remove.asp?confirm=rsAuthors("id")>Remove</a></font></td>>"%>
> > >
> > > I have field id in one of my database table.
> > >
> > >
> > > Hope someone might be able to help.
> > >
> > >
> > > Thanks
> > >
> > >
> > > ANdy
> > >
> > >
> > >
> >
> >
> > __________________________________________________
> > Do you Yahoo!?
> > Yahoo! Tax Center - forms, calculators, tips, more
> > http://taxes.yahoo.com/
> >
> >
> >
>
>
__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/
Message #6 by Mark Eckeard <meckeard2000@y...> on Wed, 5 Mar 2003 15:56:50 -0800 (PST)
|
|
Andy,
Why are you using the MoveNext command? And is this
the only link that gets displayed?
Please post all the code so we can see. You can email
me off-list if it's too much code to send via email.
Mark
--- Andy <andy@t...> wrote:
> Hello,
>
> Ok , I try to view the source of the original page
> and the value from the
> database is there.But why the value cannot be get on
> the remove.asp page?
>
> Thanks
>
>
> Andy
> ----- Original Message -----
> From: "Mark Eckeard" <meckeard2000@y...>
> To: "ASP Web HowTo" <asp_web_howto@p...>
> Sent: Thursday, March 06, 2003 4:33 AM
> Subject: [asp_web_howto] Re: Hyperlink with asp
> database
>
>
> > Is the ID coming back from the database? If so,
> try
> > this:
> >
> > <%
> > response.write "<a href=""remove.asp?confirm=""" &
> > rsAuthors("id") & """>Remove</a></font></td>"
> > %>
> >
> > --- Andy <andy@t...> wrote:
> > > Hello,
> > >
> > > I am trying to pass some value to another page
> using
> > > the hyperlink with asp
> > > but have no idea how this can be done.
> > >
> > > <%Response.write "<a
> > >
> >
>
href=remove.asp?confirm=rsAuthors("id")>Remove</a></font></td>>"%>
> > >
> > > I have field id in one of my database table.
> > >
> > >
> > > Hope someone might be able to help.
> > >
> > >
> > > Thanks
> > >
> > >
> > > ANdy
> > >
> > >
> > >
> >
> >
> > __________________________________________________
> > Do you Yahoo!?
> > Yahoo! Tax Center - forms, calculators, tips, more
> > http://taxes.yahoo.com/
> >
> >
> >
>
>
__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/
Message #7 by "Drew, Ron" <RDrew@B...> on Wed, 5 Mar 2003 20:44:15 -0500
|
|
Not sure if this would work but could it be...
<tr>
<td width=3D"58%" height=3D"11"><font face=3D"Verdana"
size=3D"1.5"><%=3D
rsAuthors("category")%></font></td>
<td width=3D"23%" height=3D"11">
<p align=3D"center"><font face=3D"Verdana" size=3D"2">
<a
href=3D"remove.asp?confirm=3D<%=3DrsAuthors("id")%>">Remove</a></font></t
d>
<% rsAuthors.MoveNext%>
<% Wend %>
-----Original Message-----
From: Andy [mailto:andy@t...]
Sent: Wednesday, March 05, 2003 3:46 PM
To: ASP Web HowTo
Subject: [asp_web_howto] Re: Hyperlink with asp database
Hello Mark,
Thanks for the advice.I have try with your codes and try to print out
the value that I should get on the remove.asp by issuing the
response.write command but unfortunatelly I didnt get any value return.
original page
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
<tr>
<td width=3D"58%" height=3D"11"><font face=3D"Verdana"
size=3D"1.5"><%
response.write rsAuthors("category")%></font></td>
<td width=3D"23%" height=3D"11">
<p align=3D"center"><font face=3D"Verdana" size=3D"2">
<%response.write "<a href=3D""remove.asp?confirm=3D""" &
rsAuthors("id")&""">Remove</a></font></td>"%>
<% rsAuthors.MoveNext%>
<% Wend %>
<%
rsAuthors.Close
Set rsAuthors =3D Nothing
adoConn.Close
set adoConn =3D Nothing
%>
</tr>
Remove.asp
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
<%
Dim id
id =3D Request.QueryString("confirm")
Response.write id
%>
Thanks
Andy
----- Original Message -----
From: "Mark Eckeard" <meckeard2000@y...>
To: "ASP Web HowTo" <asp_web_howto@p...>
Sent: Thursday, March 06, 2003 4:33 AM
Subject: [asp_web_howto] Re: Hyperlink with asp database
> Is the ID coming back from the database? If so, try
> this:
>
> <%
> response.write "<a href=3D""remove.asp?confirm=3D""" &
> rsAuthors("id") & """>Remove</a></font></td>"
> %>
>
> --- Andy <andy@t...> wrote:
> > Hello,
> >
> > I am trying to pass some value to another page using
> > the hyperlink with asp
> > but have no idea how this can be done.
> >
> > <%Response.write "<a
> >
> href=3Dremove.asp?confirm=3DrsAuthors("id")>Remove</a></font></td>>"%>
> >
> > I have field id in one of my database table.
> >
> >
> > Hope someone might be able to help.
> >
> >
> > Thanks
> >
> >
> > ANdy
> >
> >
> >
>
>
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Tax Center - forms, calculators, tips, more
> http://taxes.yahoo.com/
>
> ---
> Change your mail options at http://p2p.wrox.com/manager.asp or to
> unsubscribe send a blank email to
>
>
Message #8 by "Andy" <andy@t...> on Sat, 8 Mar 2003 05:20:53 +0800
|
|
Hello,
Yes, I did get the return ID from the database.I have try it using one test
asp filel to loop the ID value and it returned.
I have to use the MoveNext command as I have to loop all the value from the
database,basically the result return will be like this :
Current Categories
Category
Options
Email Modify / Remove
Database Modify / Remove
As you might seen, when the user click the Remove , I am trying to pass the
some value to another asp page asking for the confirmation before it delete
and seems like this value cannot be get on the other page.
Please help.
Thanks.
Andy
----- Original Message -----
From: "Mark Eckeard" <meckeard2000@y...>
To: "ASP Web HowTo" <asp_web_howto@p...>
Sent: Thursday, March 06, 2003 7:54 AM
Subject: [asp_web_howto] Re: Hyperlink with asp database
> I would guess that you are not getting the value from
> the database. Check you code that returns the ID and
> make sure it's getting returned in the recordset.
>
> Mark
> --- Andy <andy@t...> wrote:
> > Hello Mark,
> >
> > Thanks for the advice.I have try with your codes and
> > try to print out the
> > value that I should get on the remove.asp by issuing
> > the response.write
> > command but unfortunatelly I didnt get any value
> > return.
> >
> > original page
> > =============
> > <tr>
> > <td width="58%" height="11"><font face="Verdana"
> > size="1.5"><%
> > response.write rsAuthors("category")%></font></td>
> > <td width="23%" height="11">
> > <p align="center"><font face="Verdana" size="2">
> > <%response.write "<a
> > href=""remove.asp?confirm=""" &
> > rsAuthors("id")&""">Remove</a></font></td>"%>
> > <% rsAuthors.MoveNext%>
> > <% Wend %>
> > <%
> > rsAuthors.Close
> > Set rsAuthors = Nothing
> > adoConn.Close
> > set adoConn = Nothing
> > %>
> > </tr>
> >
> > Remove.asp
> > ==========
> > <%
> >
> > Dim id
> > id = Request.QueryString("confirm")
> >
> > Response.write id
> >
> > %>
> >
> > Thanks
> >
> > Andy
> >
> > ----- Original Message -----
> > From: "Mark Eckeard" <meckeard2000@y...>
> > To: "ASP Web HowTo" <asp_web_howto@p...>
> > Sent: Thursday, March 06, 2003 4:33 AM
> > Subject: [asp_web_howto] Re: Hyperlink with asp
> > database
> >
> >
> > > Is the ID coming back from the database? If so,
> > try
> > > this:
> > >
> > > <%
> > > response.write "<a href=""remove.asp?confirm=""" &
> > > rsAuthors("id") & """>Remove</a></font></td>"
> > > %>
> > >
> > > --- Andy <andy@t...> wrote:
> > > > Hello,
> > > >
> > > > I am trying to pass some value to another page
> > using
> > > > the hyperlink with asp
> > > > but have no idea how this can be done.
> > > >
> > > > <%Response.write "<a
> > > >
> > >
> >
> href=remove.asp?confirm=rsAuthors("id")>Remove</a></font></td>>"%>
> > > >
> > > > I have field id in one of my database table.
> > > >
> > > >
> > > > Hope someone might be able to help.
> > > >
> > > >
> > > > Thanks
> > > >
> > > >
> > > > ANdy
> > > >
> > > >
> > > >
> > >
> > >
> > > __________________________________________________
> > > Do you Yahoo!?
> > > Yahoo! Tax Center - forms, calculators, tips, more
> > > http://taxes.yahoo.com/
> > >
> > >
> > >
> >
> >
>
>
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Tax Center - forms, calculators, tips, more
> http://taxes.yahoo.com/
>
>
>
|
|
|
View Cart
