close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Product Options Administrative Tutorial?

Thread began 11/03/2011 9:49 am by Justin@AdventDesign | Last modified 11/04/2011 10:13 am by Justin@AdventDesign | 1264 views | 12 replies

Jason ByrnesWebAssist

on the product insert / update pages, you would need to use the Data Assist manage relational table behavior.

you would create a recordset to return the available options.

add a checkbox to the page. Set the value of the cehckbox to use the optionID column from the option recordset, set the label for the check box to use the option name.

Now add a repeat region around the check box so it will loop through the option recordset to show all options.

*1- If this is the update page we need to create a binding in Dreamweaver before proceeding. Open the results page for the products table in the web browser, click on the update button for any product to open the update page, notice the address in the browser has a querystring variable, it will look something like this:
update?productID=3

Copy the name of the Querysting variable, in my example above it is "productID", then go to the bindings panel in Dreamweaver, click the plus button and select URL Variable, and paste the name that was copied from the browser. This will create a new databinding for the Query String variable used to load the product into the update page*

*-2 For the insert page, we need to find the name of the session that will be created when the product is inserted, go to the Server behaviors panel and double click the insert record behavior. In the session variable section, make note of the Save As setting, this is the name of the session that will be created.

cancel out of the insert record behavior, and go to the bindings tab, expand the session collection and make sure a session binding with the name from the save as setting in the insert record behavior exists*

Next add the Manage Relational Table behavior.

On the first step, set the relational table to be the productsoptions table

On the Second Step, the "Main table Join" column is the productD column, set the data type to numeric.
- On the Insert page, click the lightning bolt next to Key value and select the Session variable that is created by the insert record behavior (refer to *-2 above)

- On the update page click the lightning bolt next to Key value and select the URL Variable used to populate the update page (refer to *-1 above)

On the Third step, set the foreign key column to the OptionID, for Options From Field, select the Repeating checkbox. on the forth step, you can review the settings and click finish

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