Temporary table

[niksa88]

Hi

I need help with my temporary table in dreamweaver. The user have all privileges and the version of MySql is 5.1.41

I open new recordset and put this in SQL

CREATE temporary table ttt

SELECT *
FROM temp_new
ORDER BY s desc limit 5 ;

SELECT * from ttt  

ORDER BY b  limit 2      

I get :   MySql error# : 1064, You have an error in your SQL Syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near  SELECT * from ttt  

ORDER BY b  limit 2      

I put that code in my MySql program and he didnt send any error he make the operation is just fine but when I put in dreamweaver he send error.

Thanks

[David_Powers]

niksa88 wrote:

I put that code in my MySql program and he didnt send any error he make the operation is just fine but when I put in dreamweaver he send error.

Internally, Dreamweaver uses JavaScript to manipulate SQL queries before submitting them to MySQL. Unfortunately, the script was written in the days before MySQL supported subqueries. As a result, it sometimes reports false errors with complex SQL queries. This bug has been reported to Adobe. Hopefully, it will be fixed in the next version.