close ad
 
Important WebAssist Announcement
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Repeat Selection within a repeat selection

Thread begun 3/25/2011 1:40 am by acaciasd344844 | Last modified 3/28/2011 9:52 am by Jason Byrnes | 1595 views | 3 replies |

acaciasd344844

Repeat Selection within a repeat selection

Hi,

I am not sure how to go about this or even if dataassist will help, so here goes...

I have a hand built page which is basically an invoice, 1 record. Within the invoice their are multiple products and services, multiple records.

I have been requested to allow my customers to select as many invoices as they need to print out and be able to print them all from the one print page. So that would be one page, with multiple invoices containing multiple products and services.

So from my experience with dataassist I remember it doesn't like repeat selections within repeat selections.

Do you guys know of a possible work around or even a solution.


Thanks


John Henderson

Sign in to reply to this post

acaciasd344844

Repeat Selection

Gosh this dataassist is brilliant, It has allowed me to repeat the invoices and has the repeated products and services within the invoice repeat selection.

Only thing is the products are not being displayed. The products are retrieved from a separate recordset to the invoices. So some how It needs to pickup the relevant invoice id from the invoice recordset.


just thought I would keep you up to date with my progress


john

Sign in to reply to this post

acaciasd344844

Repeat Selection

I have a feeling the answer is in my sqlcode here.

SELECT *, DATE_FORMAT(datecreated,'%d %M %Y') as printdate
FROM invoice
LEFT JOIN customers ON customers.customerid = invoice.invoiceid
LEFT JOIN products ON products.invoiceid = invoice.invoiceid
LEFT JOIN preferences ON customers.prefid = preferences.prefid
WHERE invoice.print = '1'

This actually produces five records in total, there are only 3 invoices so the five products are linked to the 3 invoices. But to get the correct number of invoices i need to use the Group By function for Invoices, but then I lose the correct number of products and services.

john

Sign in to reply to this post

Jason ByrnesWebAssist

your going to need to use 2 separate record sets.

one to return the invoices and another to return the products.


the products record set will need to be inside the first repeat slection loop and filter using the value returned from the invoices recordset.


If you are comfortable hand coding PHP code and creating recordsets, this should not be to difficult to accomplish, if you are not comfortable hand coding PHP, I would suggest signing up for a premier ticket where you could work one on one with an engineer to create the code.

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