close ad
 
Important WebAssist Announcement
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Manage relation table with a repeated table

Thread began 9/21/2011 9:41 am by Base5 Designs | Last modified 9/22/2011 5:19 am by Base5 Designs | 1079 views | 3 replies

Base5 Designs

hi there still can't get this to work.

the steps i took are as follows

my main table holds information on the various pages for my site (sections_sec) and the primary key is : id_sec

my images table contains uploaded images for the site (images_img) and the primary key is: id_img

my relational table is called (pageimages_pim)
the field for storing the section id (id_sec) is: idsec_pim
the field for storing the image id (id_img) is: idimg_pim
in addition i also want to store an additional field from my sections table (slug_sec) into: slugsec_pim

so i created the main update form for my sections table (using the data assist wizard)

this page works fine and updates ok.

i create a recordset called images

add an image field
<img src = "path-to-image/<?php echo($row_images['image_img']);?>" />
add a checkbox called image
<input name="image" type="checkbox" id="image" value="<?php echo $row_images['id_img']; ?>" />

i then add to the page arepeating table.

for some reason i cant select the image and checkbox and add the repeating table, as the repeating table overwrites the code.
so i create the repeating table in a separate area of the page, and then copy the image and check box into the repeating table.

I then add the manage relational table.

selecting as the main join: idsec_pim
setting its value to: <?php echo((isset($_POST["WADAUpdateRecordID"]))?$_POST["WADAUpdateRecordID"]:"") ?>

Foreign key join: idimg_pim
setting its value from the drop down: 'image' in repeat selection (images, 5)

I also want to store an additional field in my relational table so on the next step:
in the slugsec_pim field i set its value to:
<?php echo((isset($_POST["slug_sec"]))?$_POST["slug_sec"]:"") ?>

which is from the WADAUpdateForm binding

i then save the page upload it and it does not work.

i have in fact only ever been able to get the manage relational table to work using a standard repeat region,
although i dont want to use a sandard repeat region in this case as there will be a lot of images to choose from and having them horizontally tiled across the page is really the only convienient way to display them.

please find attached in the zip:
the update page
url and log-in info for the admin section so you can see the page online
he dreamweaver .ste file for the site

The page itself is called using the dynamic plugins from the framework extention
I have url rewriting in place on myserver that is why all the
$_SERVER['DOCUMENT_ROOT'] . calls in the include statements are there.

Thanks for your time

Attached Files
Update wih mr and repeating table.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...