close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 or 2018 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

can DataAssist 2 make products display in 2 rows of 3?

Thread began 6/30/2010 1:18 pm by skyll237680 | Last modified 7/02/2010 6:33 pm by CraigR | 2275 views | 10 replies |

skyll237680

can DataAssist 2 make products display in 2 rows of 3?

I am trying to figure out if DataAssist 2 has a server behavior that can display my products in 2 rows of 3. Each product has one image with prod number & link text (which links to a detail page) each is contained in a single dynamically generated table, one table containing each product for each record in the database, but DW just repeats the product tables vertically 6 to a page, which is not what I want. I need 2 rows of 3, 6 per page.

The following is the code generated by DWCS3 which puts the products in a horizontal line of 6 to a page, which I am wondering if there is a DataAssist server behavior that can be applied to force it to display the products, 6 to a page, but in 2 rows of 3 each.

<table border="0" align="center" id="repeatingTable">
<?php do { ?>
<tr>
<td>
<p align="center"><?php echo $row_rsgallery['ItemID']; ?>&nbsp; </p>
<p align="center"><a href="gallery_detail.php?recordID=<?php echo $row_rsgallery['ItemID']; ?>"><img src="images/113x170_thumbs/<?php echo $row_rsgallery['ItemThumb']; ?>" alt="exotic wooden creations online fine art gallery" name="galleryThumb" id="galleryThumb" /></a> </p>
<p align="center"><?php echo $row_rsgallery['ItemSKU']; ?> </p> </td>
</tr>
<?php } while ($row_rsgallery = mysql_fetch_assoc($rsgallery)); ?>
</table>
<br />
<table border="0">
<tr>
<td><?php if ($pageNum_rsgallery > 0) { // Show if not first page ?>
<a href="<?php printf("%s?pageNum_rsgallery=%d%s", $currentPage, 0, $queryString_rsgallery); ?>">First</a>
<?php } // Show if not first page ?> </td>
<td><?php if ($pageNum_rsgallery > 0) { // Show if not first page ?>
<a href="<?php printf("%s?pageNum_rsgallery=%d%s", $currentPage, max(0, $pageNum_rsgallery - 1), $queryString_rsgallery); ?>">Previous</a>
<?php } // Show if not first page ?> </td>
<td><?php if ($pageNum_rsgallery < $totalPages_rsgallery) { // Show if not last page ?>
<a href="<?php printf("%s?pageNum_rsgallery=%d%s", $currentPage, min($totalPages_rsgallery, $pageNum_rsgallery + 1), $queryString_rsgallery); ?>">Next</a>
<?php } // Show if not last page ?> </td>
<td><?php if ($pageNum_rsgallery < $totalPages_rsgallery) { // Show if not last page ?>
<a href="<?php printf("%s?pageNum_rsgallery=%d%s", $currentPage, $totalPages_rsgallery, $queryString_rsgallery); ?>">Last</a>
<?php } // Show if not last page ?> </td>
</tr>
</table>
Records <?php echo ($startRow_rsgallery + 1) ?> to <?php echo min($startRow_rsgallery + $maxRows_rsgallery, $totalRows_rsgallery) ?> of <?php echo $totalRows_rsgallery ?> </td>

thanks so much, I've been trying to solve this for days now. I purchased the DataAssist 2 upgrade in hopes that it will do this. I have found WA documentation here ( da_ft_08.htm ) which seems to indicate this is possible, but not real clear on how to go about it. I would be grateful to anyone who could steer me in the right direction :)

Sign in to reply to this post

CraigRBeta Tester

DataAssist 2 allows you to create what is called a 'repeating table' of x rows and y columns

go to Insert-->Webassist-->Dataassist-->Repeating Table

Sign in to reply to this post

skyll237680

can DataAssist do this?

I think I'm not explaining clear...what I want to do is "repeat selection for horizontal looping". Not sure if I can apply it to an already created dynamic product display. But I want to know if it's possible to select a little table that I have already created that dynamically displays my products 6 to a page as long as there are records in the database, but here's what I want to do:

I want to make it display all records in 2 rows of 3 little tables instead of 6 in a vertical line as it is currently because DW only allows display to be one long line vertically or horizontally, but no looping of 3 to a row. here's a link to the page and how it displays currently: gallery_main.php

Can a DataAssist server behavior be applied to my dynamic table already created to force it to loop 3 to a row in 2 rows? If so, how?

thanks a million!

Sign in to reply to this post

CraigRBeta Tester

i think i understand you.

Here is an example of a page section i just created using the repeating table method i described.

the repeating table is linked to a database and will display up to 12 items, (3x4) , then i use pagination if there are more rows in the database

the shot only shows 5 items, but the table is 3 across as you can see.

if this isn't what you mean, please reply.

Sign in to reply to this post

skyll237680

apply to an already existing dynamically repeating table?

yes, that is how I want it, but my question is: can the DataAssist server behavior be applied to my "already existing" dynamically repeating table--code that has already been created by DW using the "Master Detail Page Set data object" in DWCS3 to build a main page and detail page.

thanks!

Sign in to reply to this post

CraigRBeta Tester

Well, the short answer is, i don't know, - not without a lot of digging about.

Someone from Webassist may be able to offer more insight.

Honestly, I dont really like the master/detail that dw sets up, and if you have dataassist, you would probably better create the master page as you have outlined, and create the detail page separately, simply by filtering the recordset with appropriate url parameter, its not too difficult.

Sign in to reply to this post

Eric Mittman

If you have your data being displayed rite now in a standard DW repeat region then you should try adding in the repeat selection server behavior for DataAssist. You would want to apply it to the <td></td> portion of the row, then repeat it for how many you would like to see across.

I don't think this is the optimal situation though, I think it would be easier to just create your own display for the records on the page with the repeat table server behavior. It will use the same recordset so the page should look and work about the same except you will have multiple entries for each row. Always make a backup to your existing working page before you try to alter or update it.

Sign in to reply to this post

skyll237680

is there a tutorial somewhere to create product and detail pages?

Thank you both for your suggestions.

After messing with it a little, I don't think it's going to work to apply the DataAssist server behavior to the code I already have that DW generated...so since you both suggest I recreate both of these pages from scratch using DataAssist, is there some tutorial that could guide?

As you know, I need one page for the 2 rows of 6 product thumbnails with some text, and another page to display product details when one of the thumbnails is clicked. In the past I've used DataAssist to create a backend admin section with the insert, update, delete, etc, pages, but how do you use it to create these two pages--a product page and a detail page?

Thanks SO much for your input!

Sign in to reply to this post

skyll237680

also...if it is possible :) :) :)

p.s. hoping that maybe someone could point me to the appropriate steps/tutorial or documentation to use DataAssist to create the 2 pages--product pg and detail pg-- before we head off into this long 3 day weekend so I don't have to wait until next tuesday for a solution... :)

Sign in to reply to this post

Eric Mittman

You can use the same DataAssist wizard to create the master detail page that you need on the front end. When you generate the pages with the wizard just make sure that you have a results page (master) and a details page. When you are choosing the style for the pages you can use the non admin type of pages.

This will give you a results page that just lists the items, you will still need to re-arrange the display of information on the page. If you have a working master/details page combo it would be best to just redo the display on your existing master page. Make sure to backup your current page, then you can remove the display that is currently in place and add in the repeating table server behavior. You can then add in the bindings for the data from the bindings panel. To link to the details page you will need to make the links like they were on the page originally. You will need to link to the details page with the id for the record you are working with.

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...