Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Update Multiple Records from Multiple Query Results

View all replies to this thread

Update Multiple Records from Multiple Query Results

Thread began 4/07/2011 3:21 pm by tom92909 | Last modified 4/11/2011 8:51 am by tom92909 | 1726 views | 4 replies

4/07/2011 3:21 pmtom92909Beta Tester

Update Multiple Records from Multiple Query Results

Greetings folks! I have a delimia I've been working on today that I think I'd like to get some feedback on please. I have a client that wants me to produce a financial report for his business and export it to an Excel output from MySQL. That usually wouldn't be a problem. However, my problem is that to obtain all of this information I have to gather it from (5) different locations and then do some calculations.

My Dreamweaver table with (5) queries with repeating regions.

So I have (5) Queries and then I'd like to store these results in one table. Ultimately from that table I'll export the report to Excel (but that's not my issue).

This is my actual output from the Dreamweaver script above.

The issue is I'm having no luck taking my results output and either inserting or updating the table I have ready for the final content.
The image below should give you a better idea of what I'm trying to accomplish.

Thanks in advance!

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.