Forums
This topic is locked
New to ASP and access in Dreamweaver
Posted 04 Jun 2006 11:31:04
1
has voted
04 Jun 2006 11:31:04 Todd Jones posted:
Hi all, I am new to this site and to dynamic web site creation. I am trying asp and asp.net however I am very furstrated I am hoping someone can help me out here.I created an access database wit the columns of product id, description, content and image.
How to I call up content from the database other that row 1. Say I have five differnt rows, I can not get it too pull up anything else other than the first row. Is there anywhere I can go to look up commands.
I amd trying to have a emplate page where it will display 15 differnt products when I click on the link. I am wanting the page to stay but just the content to change.
Any help would be appreciated.
Todd!<img src=../images/dmxzone/forum/icon_smile_sad.gif border=0 align=middle>
Replies
Replied 05 Jun 2006 04:58:35
05 Jun 2006 04:58:35 Javier Castro replied:
Hi Todd,
it seems that yoiu need to use the repeat region server behavious, to show more than record. To do that you can create a recordset that will say something like:
SELECT *
FROM tableContent
Then, on the server behaviours tab, select repeat region, then specify that you want 15 records at the time.
good luck.
it seems that yoiu need to use the repeat region server behavious, to show more than record. To do that you can create a recordset that will say something like:
SELECT *
FROM tableContent
Then, on the server behaviours tab, select repeat region, then specify that you want 15 records at the time.
good luck.
Replied 06 Jun 2006 08:30:23
06 Jun 2006 08:30:23 Todd Jones replied:
Hi I guess I am not explaining it correclty.
I want to use the same template but pull different content from the database, based on a hyper link. How do you go about selcting what record you want from the database to select and change the content within a page.
Any help would be appreciated.
Todd!<img src=../images/dmxzone/forum/icon_smile_sad.gif border=0 align=middle>
I want to use the same template but pull different content from the database, based on a hyper link. How do you go about selcting what record you want from the database to select and change the content within a page.
Any help would be appreciated.
Todd!<img src=../images/dmxzone/forum/icon_smile_sad.gif border=0 align=middle>
Replied 06 Jun 2006 12:38:50
06 Jun 2006 12:38:50 Patrick Woldberg replied:
You could use the Master Detail Page Set from Macromedia wizard, you find it under the menu Insert -> Application Objects.
Or use a recordset and the use an URL Parameter as id to get the product you need, you have to make sure the products table has unique id's.
--------------------------------------------------
Patrick Woldberg
Web Developer at Dynamic Zones
Administrator at DMXzone.com, FLzone.net, FWzone.net and DNzone.com
--------------------------------------------------
Or use a recordset and the use an URL Parameter as id to get the product you need, you have to make sure the products table has unique id's.
--------------------------------------------------
Patrick Woldberg
Web Developer at Dynamic Zones
Administrator at DMXzone.com, FLzone.net, FWzone.net and DNzone.com
--------------------------------------------------