adorni
Posts: 120
|
| Posted: 05/17/2008, 8:46 AM |
|
When i execute my default page, this error show me:
"Database Error: 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 'usuarios LIMIT 0,1' at line 1"
All works fine with database. If i delete de "{error}" from login form in default page, i donīt see any error, but the user and pass error donīt see too :)
Please, help me.
Thanks
Manuel
|
 |
 |
materix
Posts: 161
|
| Posted: 05/17/2008, 12:22 PM |
|
In the connection window under "Server" there is a field called "Use LIMIT/TOP".
Does it help if you uncheck this field?
|
|
|
|
adorni
Posts: 120
|
| Posted: 05/17/2008, 4:20 PM |
|
Hi.
Now change for this similar error:
Database Error: 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 'usuarios' at line 1
Thanks for your response and i waiting for the next :)
Manuel
|
|
|
|
materix
Posts: 161
|
| Posted: 05/17/2008, 6:02 PM |
|
Is it a Grid that you are trying to display?
In that case try to insert this code in BeforeExecuteSelect in the grid:
echo "SQL: ".$Container->DataSource->SQL;
Then try to execute the page and tell us what it says.
|
|
|
|
adorni
Posts: 120
|
| Posted: 05/18/2008, 7:50 AM |
|
No, i trying to display a "Login" page make with "Autentification Builder"
Thanks
|
|
|
|
|
