Get ready for BLACK FRIDAY shopping starting in

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.
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>
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 -&gt; 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
--------------------------------------------------

Reply to this topic