Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Multiple Table View with DA

Multiple Table View with DA

Thread began 12/31/2009 2:32 am by tim383164 | Last modified 1/04/2010 5:15 pm by tim383164 | 1566 views | 3 replies

1/02/2010 2:27 amjo4koalas392067

Hi

I had the same problem and found it easier to create the query and test it outside of the recordset/dreamweaver. I am new to MySQL, but I have found SQLyog (www.webyog.com) a really useful tool for this and there is a 30 day free trial, which I am using (but may end up actually getting the program as it saves so much time and typing). Their QueryBuilder is a very similar format to Microsoft Access if you have ever used that.

Once I have it working in SQLyog, I copy and paste the query into my recordset. Oh, but don't forget to remove the ";" from the end of the query in SQLyog as it really mucks things up if you keep it in there (took me ages to figure out why this was happening).

Hope this is of some help.

Jo

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.