|
|
Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
This is a multi-part message in MIME format.
------=_NextPart_000_0013_01C5E4FE.880F5720
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi everyone,
I've got quite a specific query that I'm trying to resolve with =
Microsoft Access and I'm hopeful someone out there can offer a solution =
to my problem.=20
I have records that I'm displaying on a web page from an Access database =
and what I would like to do is include a 'Buy Now' button at the end of =
each record, so when the particular .aspx page is accessed through a =
users browser and the data pulled from the database, it looks something =
like the following:
Product A Description A Price A 'Buy Now Button'
Product B Description B Price B 'Buy Now Button'
Product C Description C Price C 'Buy Now Button'
I'm trying to avoid having to manually add the button to the record by =
way of an OLE Object field, I fear that could be really time consuming. =
I have some code that will work behind each button but I need to find a =
way around two specific problems:
Firstly, how to display the same 'Buy Now' button (or image) at the end =
of each record, without the necessity to add it manually to the web page =
- and for obvious reasons this would be a headache scenario because new =
records will be added and old ones deleted on a regular basis. I =
therefore need an automated way to include this button each time a new =
record is added.
The second issue I have is how to change two of the components within =
that code so each Buy Now button will represent the unique product it is =
displayed next to, for example I need to work out how to change the =
'Product Name' and 'Price' within the code so its identical to the =
'Product Name' and 'Price' from that particular row of data, and =
obviously without the necessity again to do this manually each time a =
new record is added.
I know this sounds complicated but I am sure there must be a way around =
this, perhaps using Visual Basic for Applications within the Access =
Database itself, but I'm not a programmer so I'm a little unsure how to =
apply the correct VB code to accomplish this task.
If anyone has a suitable solution for this problem I really would be =
grateful.
Many thanks
Wayne
As a footnote, I'm running FrontPage 2003, Access 2003 and IIS 6.0 on a =
Windows 2003 Datacentre Server with ASP.NET 1.1 Installed
------=_NextPart_000_0013_01C5E4FE.880F5720
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.3790.0" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>Hi everyone,</FONT></DIV>
<DIV><FONT size=3D2>I've got quite a specific query that I'm trying to =
resolve=20
with Microsoft Access and I'm hopeful someone out there can offer a =
solution to=20
my problem. </FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>I have records that I'm displaying on a web page =
from an=20
Access database and what I would like to do is include a 'Buy Now' =
button at the=20
end of each record, so when the particular .aspx page is accessed =
through a=20
users browser and the data pulled from the database, it looks something =
like the=20
following:</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Product A Description =
A =20
Price A 'Buy Now Button'</FONT></DIV>
<DIV>
<DIV><FONT size=3D2>Product B =20
Description B Price B 'Buy =
Now=20
Button'</FONT></DIV>
<DIV>
<DIV><FONT size=3D2>Product C =20
Description C Price C 'Buy =
Now=20
Button'</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>I'm trying to avoid having to manually add the =
button to the=20
record by way of an OLE Object field, I fear that could be really time=20
consuming. </FONT><FONT size=3D2>I have some code that will work behind =
each=20
button but I need to find a way around two specific =
problems:</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Firstly, how to display the same 'Buy Now' button =
(or image)=20
at the end of each record, without the necessity to add it manually to =
the web=20
page - and for obvious reasons this would be a headache scenario because =
new=20
records will be added and old ones deleted on a regular basis. I =
therefore need=20
an automated way to include this button each time a new record is=20
added.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>The second issue I have is how to change two of the =
components=20
within that code so each Buy Now button will represent the unique =
product it is=20
displayed next to, for example I need to work out how to change the =
'Product=20
Name' and 'Price' within the code so its identical to the 'Product Name' =
and=20
'Price' from that particular row of data, and obviously without the =
necessity=20
again to do this manually each time a new record is added.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>I know this sounds complicated but I am sure there =
must be a=20
way around this, perhaps using Visual Basic for Applications within the =
Access=20
Database itself, but I'm not a programmer so I'm a little unsure how to =
apply=20
the correct VB code to accomplish this task.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>If anyone has a suitable solution for this problem I =
really=20
would be grateful.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Many thanks</FONT></DIV>
<DIV><FONT size=3D2>Wayne</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>As a footnote, I'm running FrontPage 2003, Access =
2003=20
and IIS 6.0 on a Windows 2003 Datacentre Server with ASP.NET 1.1=20
Installed</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2></FONT> </DIV></DIV></DIV></BODY></HTML>
------=_NextPart_000_0013_01C5E4FE.880F5720--
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_07A6_01C5E58A.09E41FC0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I could tell you how to do it with ASP & Notepad, but I have no idea =
about FrontPage & ASP.net.
Sorry;
Amy
"Wayne" <waynesmith1971(NoSpam)[ at ]hotmail.com> wrote in message =
news:egmAj6P5FHA.2364[ at ]TK2MSFTNGP12.phx.gbl...
Hi everyone,
I've got quite a specific query that I'm trying to resolve with =
Microsoft Access and I'm hopeful someone out there can offer a solution =
to my problem.=20
I have records that I'm displaying on a web page from an Access =
database and what I would like to do is include a 'Buy Now' button at =
the end of each record, so when the particular .aspx page is accessed =
through a users browser and the data pulled from the database, it looks =
something like the following:
Product A Description A Price A 'Buy Now Button'
Product B Description B Price B 'Buy Now Button'
Product C Description C Price C 'Buy Now Button'
I'm trying to avoid having to manually add the button to the record by =
way of an OLE Object field, I fear that could be really time consuming. =
I have some code that will work behind each button but I need to find a =
way around two specific problems:
Firstly, how to display the same 'Buy Now' button (or image) at the =
end of each record, without the necessity to add it manually to the web =
page - and for obvious reasons this would be a headache scenario because =
new records will be added and old ones deleted on a regular basis. I =
therefore need an automated way to include this button each time a new =
record is added.
The second issue I have is how to change two of the components within =
that code so each Buy Now button will represent the unique product it is =
displayed next to, for example I need to work out how to change the =
'Product Name' and 'Price' within the code so its identical to the =
'Product Name' and 'Price' from that particular row of data, and =
obviously without the necessity again to do this manually each time a =
new record is added.
I know this sounds complicated but I am sure there must be a way =
around this, perhaps using Visual Basic for Applications within the =
Access Database itself, but I'm not a programmer so I'm a little unsure =
how to apply the correct VB code to accomplish this task.
If anyone has a suitable solution for this problem I really would be =
grateful.
Many thanks
Wayne
As a footnote, I'm running FrontPage 2003, Access 2003 and IIS 6.0 on =
a Windows 2003 Datacentre Server with ASP.NET 1.1 Installed
------=_NextPart_000_07A6_01C5E58A.09E41FC0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2900.2769" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>I could tell you how to do it with ASP =
&=20
Notepad, but I have no idea about FrontPage & ASP.net.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Sorry;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Amy</FONT></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Wayne" <waynesmith1971(NoSpam)[ at ]hotmail.com> wrote in =
message <A=20
=
href=3D"news:egmAj6P5FHA.2364[ at ]TK2MSFTNGP12.phx.gbl">news:egmAj6P5FHA.2364=
[ at ]TK2MSFTNGP12.phx.gbl</A>...</DIV>
<DIV><FONT size=3D2>Hi everyone,</FONT></DIV>
<DIV><FONT size=3D2>I've got quite a specific query that I'm trying to =
resolve=20
with Microsoft Access and I'm hopeful someone out there can offer a =
solution=20
to my problem. </FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>I have records that I'm displaying on a web page =
from an=20
Access database and what I would like to do is include a 'Buy Now' =
button at=20
the end of each record, so when the particular .aspx page is accessed =
through=20
a users browser and the data pulled from the database, it looks =
something like=20
the following:</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Product A Description =
A =20
Price A 'Buy Now Button'</FONT></DIV>
<DIV>
<DIV><FONT size=3D2>Product B =20
Description B Price B =
'Buy Now=20
Button'</FONT></DIV>
<DIV>
<DIV><FONT size=3D2>Product C =20
Description C Price C =
'Buy Now=20
Button'</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>I'm trying to avoid having to manually add the =
button to the=20
record by way of an OLE Object field, I fear that could be really time =
consuming. </FONT><FONT size=3D2>I have some code that will work =
behind each=20
button but I need to find a way around two specific =
problems:</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Firstly, how to display the same 'Buy Now' button =
(or image)=20
at the end of each record, without the necessity to add it manually to =
the web=20
page - and for obvious reasons this would be a headache scenario =
because new=20
records will be added and old ones deleted on a regular basis. I =
therefore=20
need an automated way to include this button each time a new =
record is=20
added.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>The second issue I have is how to change two of =
the=20
components within that code so each Buy Now button will represent the =
unique=20
product it is displayed next to, for example I need to work out how to =
change=20
the 'Product Name' and 'Price' within the code so its identical to the =
'Product Name' and 'Price' from that particular row of data, and =
obviously=20
without the necessity again to do this manually each time a new record =
is=20
added.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>I know this sounds complicated but I am sure there =
must be a=20
way around this, perhaps using Visual Basic for Applications within =
the Access=20
Database itself, but I'm not a programmer so I'm a little unsure how =
to apply=20
the correct VB code to accomplish this task.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>If anyone has a suitable solution for this problem =
I really=20
would be grateful.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Many thanks</FONT></DIV>
<DIV><FONT size=3D2>Wayne</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>As a footnote, I'm running FrontPage 2003, Access =
2003=20
and IIS 6.0 on a Windows 2003 Datacentre Server with ASP.NET 1.1=20
Installed</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT =
size=3D2></FONT> </DIV></DIV></DIV></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_07A6_01C5E58A.09E41FC0--
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_0023_01C5E5D0.CAA3D520
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Would you mind explaining how to do it with asp Amy, I've looked at some =
ASP.NET web sites and it all seems a bit daunting to be honest.
Any help or step-by-step instructions you can give would be greatly =
appreciated.
Many thanks
Wayne
"Amy Blankenship" <Amy_nospam[ at ]magnoliamultimedia.com> wrote in message =
news:e9GgWxb5FHA.3296[ at ]TK2MSFTNGP09.phx.gbl...
I could tell you how to do it with ASP & Notepad, but I have no idea =
about FrontPage & ASP.net.
Sorry;
Amy
"Wayne" <waynesmith1971(NoSpam)[ at ]hotmail.com> wrote in message =
news:egmAj6P5FHA.2364[ at ]TK2MSFTNGP12.phx.gbl...
Hi everyone,
I've got quite a specific query that I'm trying to resolve with =
Microsoft Access and I'm hopeful someone out there can offer a solution =
to my problem.=20
I have records that I'm displaying on a web page from an Access =
database and what I would like to do is include a 'Buy Now' button at =
the end of each record, so when the particular .aspx page is accessed =
through a users browser and the data pulled from the database, it looks =
something like the following:
Product A Description A Price A 'Buy Now Button'
Product B Description B Price B 'Buy Now Button'
Product C Description C Price C 'Buy Now Button'
I'm trying to avoid having to manually add the button to the record =
by way of an OLE Object field, I fear that could be really time =
consuming. I have some code that will work behind each button but I need =
to find a way around two specific problems:
Firstly, how to display the same 'Buy Now' button (or image) at the =
end of each record, without the necessity to add it manually to the web =
page - and for obvious reasons this would be a headache scenario because =
new records will be added and old ones deleted on a regular basis. I =
therefore need an automated way to include this button each time a new =
record is added.
The second issue I have is how to change two of the components =
within that code so each Buy Now button will represent the unique =
product it is displayed next to, for example I need to work out how to =
change the 'Product Name' and 'Price' within the code so its identical =
to the 'Product Name' and 'Price' from that particular row of data, and =
obviously without the necessity again to do this manually each time a =
new record is added.
I know this sounds complicated but I am sure there must be a way =
around this, perhaps using Visual Basic for Applications within the =
Access Database itself, but I'm not a programmer so I'm a little unsure =
how to apply the correct VB code to accomplish this task.
If anyone has a suitable solution for this problem I really would be =
grateful.
Many thanks
Wayne
As a footnote, I'm running FrontPage 2003, Access 2003 and IIS 6.0 =
on a Windows 2003 Datacentre Server with ASP.NET 1.1 Installed
------=_NextPart_000_0023_01C5E5D0.CAA3D520
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.3790.0" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>Would you mind explaining how to do it with asp Amy, =
I've=20
looked at some ASP.NET web sites and it all seems a bit daunting to be=20
honest.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Any help or step-by-step instructions you can give =
would be=20
greatly appreciated.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Many thanks</FONT></DIV>
<DIV><FONT size=3D2>Wayne</FONT></DIV>
<DIV> </DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Amy Blankenship" <<A=20
=
href=3D"mailto:Amy_nospam[ at ]magnoliamultimedia.com">Amy_nospam[ at ]magnoliamult=
imedia.com</A>>=20
wrote in message <A=20
=
href=3D"news:e9GgWxb5FHA.3296[ at ]TK2MSFTNGP09.phx.gbl">news:e9GgWxb5FHA.3296=
[ at ]TK2MSFTNGP09.phx.gbl</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>I could tell you how to do it with =
ASP &=20
Notepad, but I have no idea about FrontPage & =
ASP.net.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Sorry;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Amy</FONT></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Wayne" <waynesmith1971(NoSpam)[ at ]hotmail.com> wrote in =
message <A=20
=
href=3D"news:egmAj6P5FHA.2364[ at ]TK2MSFTNGP12.phx.gbl">news:egmAj6P5FHA.2364=
[ at ]TK2MSFTNGP12.phx.gbl</A>...</DIV>
<DIV><FONT size=3D2>Hi everyone,</FONT></DIV>
<DIV><FONT size=3D2>I've got quite a specific query that I'm trying =
to resolve=20
with Microsoft Access and I'm hopeful someone out there can offer a =
solution=20
to my problem. </FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>I have records that I'm displaying on a web page =
from an=20
Access database and what I would like to do is include a 'Buy Now' =
button at=20
the end of each record, so when the particular .aspx page is =
accessed=20
through a users browser and the data pulled from the database, it =
looks=20
something like the following:</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Product A Description=20
A Price A 'Buy Now =
Button'</FONT></DIV>
<DIV>
<DIV><FONT size=3D2>Product B =20
Description B Price B =
'Buy Now=20
Button'</FONT></DIV>
<DIV>
<DIV><FONT size=3D2>Product C =20
Description C Price C =
'Buy Now=20
Button'</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>I'm trying to avoid having to manually add the =
button to=20
the record by way of an OLE Object field, I fear that could be =
really time=20
consuming. </FONT><FONT size=3D2>I have some code that will work =
behind each=20
button but I need to find a way around two specific =
problems:</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Firstly, how to display the same 'Buy Now' =
button (or=20
image) at the end of each record, without the necessity to add it =
manually=20
to the web page - and for obvious reasons this would be a headache =
scenario=20
because new records will be added and old ones deleted on a regular =
basis. I=20
therefore need an automated way to include this button each =
time a new=20
record is added.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>The second issue I have is how to change two of =
the=20
components within that code so each Buy Now button will represent =
the unique=20
product it is displayed next to, for example I need to work out how =
to=20
change the 'Product Name' and 'Price' within the code so its =
identical to=20
the 'Product Name' and 'Price' from that particular row of data, and =
obviously without the necessity again to do this manually each time =
a new=20
record is added.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>I know this sounds complicated but I am sure =
there must be=20
a way around this, perhaps using Visual Basic for Applications =
within the=20
Access Database itself, but I'm not a programmer so I'm a little =
unsure how=20
to apply the correct VB code to accomplish this task.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>If anyone has a suitable solution for this =
problem I=20
really would be grateful.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Many thanks</FONT></DIV>
<DIV><FONT size=3D2>Wayne</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>As a footnote, I'm running FrontPage 2003, =
Access 2003=20
and IIS 6.0 on a Windows 2003 Datacentre Server with ASP.NET =
1.1=20
Installed</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT=20
size=3D2></FONT> </DIV></DIV></DIV></BLOCKQUOTE></BLOCKQUOTE></BODY>=
</HTML>
------=_NextPart_000_0023_01C5E5D0.CAA3D520--
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_083C_01C5E5EA.64806050
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
OK, let's assume for the sake of argument, that you already have a =
recordset, rs, with the fields Product, Description, Price, and that =
Product is the Primary Key to the field. Your graphic is called =
buynow.bmp and is in the same directory as YourFile.asp, which, at this =
point, is a blank html page with your open recordset code above the open =
html tag. I'm also assuming you don't mind sending Product in your =
queryString.
What we want now is a set of table rows: one for each product. So we're =
going to loop through the recordset:
Do While Not rs.EOF
Tabs :=3D 2 ' number of tabs to indent, to make the code more =
readable
html =3D html & String(Tabs, vbTab) & "<TR>" & vbCR
Tabs :=3D 3
'cel for description
html =3D html & String(Tabs, vbTab) & "<TD>" & rs("Description") & =
"</TD>" & vbCR
'cel for Price
html =3D html & String(Tabs, vbTab) & "<TD>" & rs("Price") & "</TD>" =
& vbCR
'cel for buy now
html =3D html & String(Tabs, vbTab) & "<TD><a href =3D =
""./ShoppingCart.asp?Product=3D" & rs("Product") & """><img =
src=3D""./buynow.jpg""></a></TD>" & vbCR
rs.MoveNext
Loop
Now, between your body tags, you'll need to add
<table>
<%=3Dhtml%>
</table>.
HTH;
Amy
=20
=20
"Amy Blankenship" <Amy_nospam[ at ]magnoliamultimedia.com> wrote in message =
news:e9GgWxb5FHA.3296[ at ]TK2MSFTNGP09.phx.gbl...
I could tell you how to do it with ASP & Notepad, but I have no idea =
about FrontPage & ASP.net.
Sorry;
Amy
"Wayne" <waynesmith1971(NoSpam)[ at ]hotmail.com> wrote in message =
news:egmAj6P5FHA.2364[ at ]TK2MSFTNGP12.phx.gbl...
Hi everyone,
I've got quite a specific query that I'm trying to resolve with =
Microsoft Access and I'm hopeful someone out there can offer a solution =
to my problem.=20
I have records that I'm displaying on a web page from an Access =
database and what I would like to do is include a 'Buy Now' button at =
the end of each record, so when the particular .aspx page is accessed =
through a users browser and the data pulled from the database, it looks =
something like the following:
Product A Description A Price A 'Buy Now Button'
Product B Description B Price B 'Buy Now Button'
Product C Description C Price C 'Buy Now Button'
I'm trying to avoid having to manually add the button to the record =
by way of an OLE Object field, I fear that could be really time =
consuming. I have some code that will work behind each button but I need =
to find a way around two specific problems:
Firstly, how to display the same 'Buy Now' button (or image) at the =
end of each record, without the necessity to add it manually to the web =
page - and for obvious reasons this would be a headache scenario because =
new records will be added and old ones deleted on a regular basis. I =
therefore need an automated way to include this button each time a new =
record is added.
The second issue I have is how to change two of the components =
within that code so each Buy Now button will represent the unique =
product it is displayed next to, for example I need to work out how to =
change the 'Product Name' and 'Price' within the code so its identical =
to the 'Product Name' and 'Price' from that particular row of data, and =
obviously without the necessity again to do this manually each time a =
new record is added.
I know this sounds complicated but I am sure there must be a way =
around this, perhaps using Visual Basic for Applications within the =
Access Database itself, but I'm not a programmer so I'm a little unsure =
how to apply the correct VB code to accomplish this task.
If anyone has a suitable solution for this problem I really would be =
grateful.
Many thanks
Wayne
As a footnote, I'm running FrontPage 2003, Access 2003 and IIS 6.0 =
on a Windows 2003 Datacentre Server with ASP.NET 1.1 Installed
------=_NextPart_000_083C_01C5E5EA.64806050
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2900.2769" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>OK, let's assume for the sake of =
argument, that you=20
already have a recordset, rs, with the fields Product, Description, =
Price, and=20
that Product is the Primary Key to the field. Your graphic is =
called=20
buynow.bmp and is in the same directory as YourFile.asp, which, at this =
point,=20
is a blank html page with your open recordset code above the open html=20
tag. I'm also assuming you don't mind sending Product in your=20
queryString.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>What we want now is a set of table =
rows: one for=20
each product. So we're going to loop through the =
recordset:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Do While Not rs.EOF</FONT></DIV>
<DIV><FONT face=3DArial size=3D2> Tabs :=3D 2 ' number =
of tabs to=20
indent, to make the code more readable</FONT></DIV>
<DIV><FONT face=3DArial size=3D2> html =3D html & =
String(Tabs,=20
vbTab) & "<TR>" & vbCR</FONT></DIV>
<DIV><FONT face=3DArial size=3D2> Tabs :=3D =
3</FONT></DIV>
<DIV><FONT face=3DArial size=3D2> 'cel for=20
description</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>
<DIV><FONT face=3DArial size=3D2> html =3D html & =
String(Tabs,=20
vbTab) & "<TD>" & rs("Description") & "</TD>"=20
& vbCR</FONT></DIV>
<DIV><FONT face=3DArial size=3D2> 'cel =
for Price</FONT></DIV>
<DIV><FONT face=3DArial size=3D2><FONT face=3DArial size=3D2><FONT =
face=3DArial=20
size=3D2> html =3D html & String(Tabs, vbTab) =
&=20
"<TD>" & rs("Price") & "</TD>"=20
& vbCR</FONT></FONT></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><FONT face=3DArial =
size=3D2> 'cel for=20
buy now
<DIV><FONT face=3DArial size=3D2>
<DIV><FONT face=3DArial size=3D2> html =3D html & =
String(Tabs,=20
vbTab) & "<TD><a href =3D ""./ShoppingCart.asp?Product=3D" =
&=20
rs("Product") & """><img=20
src=3D""./buynow.jpg""></a></TD>" =
& vbCR</FONT></DIV>
<DIV> rs.MoveNext</DIV>
<DIV>Loop</DIV>
<DIV> </DIV>
<DIV>Now, between your body tags, you'll need to add</DIV>
<DIV> </DIV>
<DIV><table></DIV>
<DIV><%=3Dhtml%></DIV>
<DIV></table>.</DIV>
<DIV> </DIV>
<DIV>HTH;</DIV>
<DIV> </DIV>
<DIV>Amy</DIV>
<DIV><FONT face=3DArial size=3D2> =
</FONT></DIV></FONT></DIV></DIV>
<DIV>
<DIV><FONT face=3DArial size=3D2> =20
</FONT></DIV></FONT></DIV></FONT></FONT><FONT face=3DArial =
size=3D2></FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Amy Blankenship" <<A=20
=
href=3D"mailto:Amy_nospam[ at ]magnoliamultimedia.com">Amy_nospam[ at ]magnoliamult=
imedia.com</A>>=20
wrote in message <A=20
=
href=3D"news:e9GgWxb5FHA.3296[ at ]TK2MSFTNGP09.phx.gbl">news:e9GgWxb5FHA.3296=
[ at ]TK2MSFTNGP09.phx.gbl</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>I could tell you how to do it with =
ASP &=20
Notepad, but I have no idea about FrontPage & =
ASP.net.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Sorry;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Amy</FONT></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Wayne" <waynesmith1971(NoSpam)[ at ]hotmail.com> wrote in =
message <A=20
=
href=3D"news:egmAj6P5FHA.2364[ at ]TK2MSFTNGP12.phx.gbl">news:egmAj6P5FHA.2364=
[ at ]TK2MSFTNGP12.phx.gbl</A>...</DIV>
<DIV><FONT size=3D2>Hi everyone,</FONT></DIV>
<DIV><FONT size=3D2>I've got quite a specific query that I'm trying =
to resolve=20
with Microsoft Access and I'm hopeful someone out there can offer a =
solution=20
to my problem. </FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>I have records that I'm displaying on a web page =
from an=20
Access database and what I would like to do is include a 'Buy Now' =
button at=20
the end of each record, so when the particular .aspx page is =
accessed=20
through a users browser and the data pulled from the database, it =
looks=20
something like the following:</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Product A Description=20
A Price A 'Buy Now =
Button'</FONT></DIV>
<DIV>
<DIV><FONT size=3D2>Product B =20
Description B Price B =
'Buy Now=20
Button'</FONT></DIV>
<DIV>
<DIV><FONT size=3D2>Product C =20
Description C Price C =
'Buy Now=20
Button'</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>I'm trying to avoid having to manually add the =
button to=20
the record by way of an OLE Object field, I fear that could be =
really time=20
consuming. </FONT><FONT size=3D2>I have some code that will work =
behind each=20
button but I need to find a way around two specific =
problems:</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Firstly, how to display the same 'Buy Now' =
button (or=20
image) at the end of each record, without the necessity to add it =
manually=20
to the web page - and for obvious reasons this would be a headache =
scenario=20
because new records will be added and old ones deleted on a regular =
basis. I=20
therefore need an automated way to include this button each =
time a new=20
record is added.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>The second issue I have is how to change two of =
the=20
components within that code so each Buy Now button will represent =
the unique=20
product it is displayed next to, for example I need to work out how =
to=20
change the 'Product Name' and 'Price' within the code so its =
identical to=20
the 'Product Name' and 'Price' from that particular row of data, and =
obviously without the necessity again to do this manually each time =
a new=20
record is added.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>I know this sounds complicated but I am sure =
there must be=20
a way around this, perhaps using Visual Basic for Applications =
within the=20
Access Database itself, but I'm not a programmer so I'm a little =
unsure how=20
to apply the correct VB code to accomplish this task.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>If anyone has a suitable solution for this =
problem I=20
really would be grateful.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Many thanks</FONT></DIV>
<DIV><FONT size=3D2>Wayne</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>As a footnote, I'm running FrontPage 2003, =
Access 2003=20
and IIS 6.0 on a Windows 2003 Datacentre Server with ASP.NET =
1.1=20
Installed</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT=20
size=3D2></FONT> </DIV></DIV></DIV></BLOCKQUOTE></BLOCKQUOTE></BODY>=
</HTML>
------=_NextPart_000_083C_01C5E5EA.64806050--
|
|
|