DRW Customizing

[Jim Mac]

I would like to create a database results section that uses a list of rental properties, called from the database, that are hyperlinks. I want to put these hyperlinks on the left side of my page and have them call up the specific data, including a picture, for the right side.

I am pretty sure I can make each part, but i dont know how to tie them together.
Also what is the best way to handle the pictures, in the database or in a folder?
If in a folder how do i join it to the data?

Thanks so much for your help.

 

[Kathleen Anderson [MVP - FP]]

For your second question, you would store the images in your web and include
links to them in your database: How to display a picture by using an Access
database in FrontPage 2003
http://support.microsoft.com/default.aspx?scid=kb;en-us;825515&Product=fp2003

 

[Thomas A. Rowe]

Sound like you trying to work with 3 individual tables...

The table with the properties, should contain all of the info for the property, the category,
details and the filename of the property image. Then you only need to have one results region.

You would use either the category or property ID to display each individual property.

Here is a very basic example of doing the above:
http://www.palm-desert-rental-condos.com/
Click on Our Condos

Here is a more complex example:
http://www.ourcondo.com
Click on Our Condos or Our Condos List or Photo/Name of the Featured Condo.

FYI: The above sites use hand code ASP/VBScript, however the first example should be easy to
accomplish using the FP Database components.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

Thanks Kathleen, Worked great! How many database results regions are too many? I was sucessful

adding 2 results regions that are tied to each other and they work great, however, when I add a
third it acts funny. I have 3 results sections, Hyperlink1(category), Hyperlink2(rental property),
final data w/picture. Everything works great until I select the hyperlink in hyperlink2. It
correctly populates the data for final data, but the list of hyperlinks for hyperlinks 2 says no
records returned. Any way to avoid this?

 

[Jim Mac]

Thanks thomas,
Im confused, I need 1 category drw that is a hiperlink. This populates properties drw which is also a hyperling. The second drw then sucessfully calls the data in the third drw. This all works, the only problem is that i cant keep the data from the second drw from dissapearing when it calls up the data for the third drw. I need to have three drw's because i have 6 categories with 100 properties per category.
Thanks

 

[Thomas A. Rowe]

Can you publish this to the web and then provide a URL?

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

Thanks thomas,
Im confused, I need 1 category drw that is a hiperlink. This populates properties drw which is

also a hyperling. The second drw then sucessfully calls the data in the third drw. This all works,
the only problem is that i cant keep the data from the second drw from dissapearing when it calls up
the data for the third drw. I need to have three drw's because i have 6 categories with 100
properties per category.

 

[Jim Mac]

Yes Thanks
http://www.dumacproductions.com/soniatrealty/jim_copy(2).asp

 

[Thomas A. Rowe]

Drop me an email.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================