Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › SQL Query issue

SQL Query issue

Thread began 8/01/2013 11:57 am by Rune Brynestad | Last modified 8/02/2013 2:57 pm by Rune Brynestad | 1752 views | 10 replies

8/02/2013 12:44 pmRune Brynestad

Ok, but when I'm going to filter using a URL variable I need to put the WHERE clause before GROUP BY like this

SELECT * FROM (SELECT * FROM tbleName ORDER BY Date_of_change DESC) as orderedTble
WHERE Access_level LIKE %colname%
GROUP BY Name

That does not automatically give me the correct result, because the Access_level is selected before GROUP BY.
I first need to run the query

SELECT * FROM (SELECT * FROM tbleName ORDER BY Date_of_change DESC) as orderedTble GROUP BY Name

Then filter by Access_level using a URL variable

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.