Error retrieving data from mysql on Localhost

[robynz]

hello

I just downloaded the trial. I have a (brand new) local bitnami wordpress stack I want to trial it with.

I can connect to the database but I can't retrieve any data. When I press retrieve columns I get this error message:

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 'LIMIT 1' at line 1

any suggestions?

thanks

[HighAley]

Hello.

Please clarify which version do you use, Flash or JS?
What SQL query do you use?
Are you sure that there is no a ny error in your query?
Please, send us this query.

Thank you.

[robynz]

Im using the Windows trial of designer for PHP

no query involved - I cant get that far. This error occurs when I try to access the database after I connect.. The connection message says it connected ok but when I try to retrieve any information this error message comes up

thanks for your help

[Alex K.]

Hello,

We are found the issue. Will be fixed in the next build.
On current build if you uses "limit" in the query, try to use the uppercase symbols:
SELECT * FROM Table1 LIMIT 1

Thank you.