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

rating

Repeating tables from Create Data Assist pages not working

Thread began 7/08/2015 5:53 pm by Brendan | Last modified 7/22/2015 4:06 pm by Ray Borduin | 324 views | 3 replies |

Brendan

Repeating tables from Create Data Assist pages not working

I just created a DataAssist results page where the repeating table isn't showing all records. I have entered 3 transactions, and have also added a SUM in the recordset to display the total amount raised, which is working.

here is a link to the live page - https://run4fundscolorado.com/sponsor/sponsor-results.php?DetailSchool=Antelope+Ridge+Elementary&Search=Search

Page is zipped and attached if needed.

Thank you for your help.

Attached Files
sponsor-results.zip
Sign in to reply to this post

Ray BorduinWebAssist

When using SUM() it automatically combines all rows into one.

The solution is to use a nested SELECT statement. I think it is more efficient to do that in the form of a cross join like:

SELECT sumtable.afrTotal, orderdetails.DetailID, orderdetails.DetailSchool, orderdetails.DetailStudentF, orderdetails.DetailStudentL, orderdetails.DetailPrice FROM orderdetails CROSS JOIN (SELECT SUM(DetailPrice) AS frTotal FROM orderdetails ) AS sumtable ORDER BY DetailStudentL ASC

Sign in to reply to this post

Brendan

Ray,

I just noticed that the SUM function is adding the price for all records, not just those meeting the search criteria in the url.

?DetailSchool=Antelope+Ridge+Elementary&Search=Search

Is it possible to use SUM in this way, or do I need to add a second recordset that contains WHERE DetailSchool = 'Antelope Ridge Elementary'

Sign in to reply to this post

Ray BorduinWebAssist

Since you are only showing one Sum on the page, it is probably easiest to just do it in another recordset and filter it with the url parameter like you suggest.

Sign in to reply to this post

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