crosley
Posts: 2
|
| Posted: 06/30/2008, 1:21 PM |
|
I am using Code Charge Studio 4.0 on LAMP; and getting the following 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 '; LIMIT 0,11' at line 8"
This may have something to do with my configuration; not really sure.
The query I am using is a Union Query, and I have changed the limit statement and stil get the error.
I would appreciate any help that is available.
Thanks,
Link
crosley@princeton.edu
|
 |
 |
datadoit
|
| Posted: 06/30/2008, 2:09 PM |
|
Have a look here: http://docs.codecharge.com/studio40/html/Components/Pro...ptimizeSQL.html
You may have an issue with your SQL having two LIMIT commands in it.
|
|
|
 |
crosley
Posts: 2
|
| Posted: 07/02/2008, 11:09 AM |
|
Sorry but that did not do it...
|
 |
 |
datadoit
|
| Posted: 07/02/2008, 2:18 PM |
|
Post your SQL please.
|
|
|
 |
|