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

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Data Assist Search pages from Dynamic links

Thread began 2/20/2012 3:57 pm by toni272059 | Last modified 2/21/2012 5:57 pm by toni272059 | 518 views | 2 replies

toni272059

Data Assist Search pages from Dynamic links

I am trying to setup a sequence of search and search results pages that are dynamically populated and build off each other. I have been successful with steps 1 and 3, but #2 is being stubborn!

1. products.php -- Products page includes one photo and text link for each product category.
2. Click on a Product Category photo or text link and page is redirected to products_group.php that includes all items in that product category only.
3. Click on single item to be redirected to product_detail.php

I have successfully created the basic DataAssist Wizard Search and Search Results pages and have been referring to that code to try and work out how to make these pages work. I am also referring to the bluesky solution recipe files for category and genre groups.

The products.php and products_group.php pages are setup with RepeatRegion and RepeatSelection holders populated dynamically using Recordsets and Bindings

The products.php Recordset uses just a productcategories database table with CategoryPhoto and CategoryName (primary key is CategoryID). The repeating table cell is setup as <td name="S_ProductCategoryID" id="S_ProductCategoryID">

Currently the products.php page shows the correct content, image and caption for each product category. However if I click on any item the products_group page is populated with product category 1 only, regardless of which image or link I select.

The products_group page Recordset is set to the full products database table. The image has binding to ProductImage and the text link has binding to ProductName. The page URL identifies the correct CategoryID or ProductCategoryID (their content is the same)
e.g. product_group.php?S_ProductCategoryID=1&WADbSearch1=1
e.g. product_group.php?S_ProductCategoryID=2&WADbSearch1=1
e.g. product_group.php?S_ProductCategoryID=3&WADbSearch1=1
etc. But is in fact only showing group 1 each time.

I have checked the DataAssist Search Parameters. Currently there is one column selected ProductCategoryID with column type Text, Comparison =, type: value, Value: S_ProductCategoryID.
Trigger: isset($_GET["Search_x"]) && $_GET["Search_x"]
The trigger I copied from the DataAssist created search_results page which successfully filters by Category

I copied the same Recordset SQL from basic search_results to product_group
SELECT ProductID, ProductSKU, ProductName, ProductPrice, ProductWeight, ProductCartDesc, ProductShortDesc, ProductImageLarge, ProductThumb, ProductImage, ProductCategoryID, ProductUpdateDate, ProductStock, ProductLive, ProductUnlimited, ProductLocation
FROM products
ORDER BY ProductSKU ASC

I have spent days on this going around in circles. Help!
Attached: the successful search and results php pages, the products and products_group php pages. Also some screen grabs showing the populated products.php page, the incorrect content on products_group.php page, the correct content on search_results.php

Attached Files
Archive.zip

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...