I can't say. The query looks correct. Have you tried running that query in PHPMyAdmin? Does it work on the page or is it just Dreamweaver's test function causing issues?
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
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.