Talk:Database Query plugin

I've got the Database Query plugin installed, but its not clear how to add a query to the list. I've tried putting a file in the dataquery directory. I also tried editing an existing query. That appears to work, but this doesn't add a query, only replaces one. How do you do this?

Also, what SQL statements are allowed in DQ? Can I make corrections to erroneous rating numbers (numbers less than 20 when the rating scale is set to 1 - 5)? There are several thousand entries with ratings less than 10.

Thanks David

Answer from Erland:

• It's a bug in the current release, if you temporary switch to the Classic skin in SBS Setting/Interface you will see a "Create new query" link at the bottom of the Database Query page
• It has only been built for SELECT statements but it might also work for UPDATE/INSERT but I haven't tried this.