Paul
|
| Posted: 04/25/2002, 1:14 PM |
|
I am going through the CCS tutorial and I can't do a Live view of the Default
page, namely the emps grid. When I do, I get an error message:
Database error: Invalid SQL: SELECT COUNT(*) FROM (SELECT * FROM emps) cnt
MySQL Error: 1064 (You have an error in your SQL syntax near 'SELECT * FROM emps) cnt' at line 1)
Session halted.
This SQL has 2 select statements in it and of course is a syntax error in MySQL.
I removed the search form and the navigation bar thinking that might have
something to do with it but the error persists.
Why is it doing this? Why is it doing a count in the first place? TIA
|
|
|
 |
CodeCharge Support
|
| Posted: 04/26/2002, 12:34 AM |
|
Please
1. Right click on your connection and select "Edit"
2. Specify "MySQL" in "Design" Tab / "Database" property, and in "Server" Tab / "PHP Database Library" property
3. Republish the project
|
|
|
|
CK
|
| Posted: 04/30/2002, 4:44 PM |
|
I have the same problem but your suggestion cannot resolve.
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[TCX][MyODBC]You have an error in your SQL syntax near 'SELECT * FROM ejournal) cnt' at line 1
/Test/Classes.asp, line 1412
I use asp+templates and ODBC connection.
|
|
|
|
BA
|
| Posted: 04/30/2002, 10:22 PM |
|
I have got the same problem!
|
|
|
|
CK
|
| Posted: 04/30/2002, 11:42 PM |
|
It seems it happens when using Grid and Record Wizard to generate the pages and code.
The code automatically add cnt at the end of the SQL statement.
?? Bug
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[TCX][MyODBC]You have an error in your SQL syntax near 'SELECT * FROM ejournal ORDER BY ID) cnt' at line 1
/Test/Classes.asp, line 1412
|
|
|
|
Nicole
|
| Posted: 05/02/2002, 5:11 AM |
|
Use MySQL db for design time connection to avoid nested sql generation.
|
|
|
|
TK
|
| Posted: 09/11/2002, 12:35 AM |
|
This is a very good questions with quite a few people waiting for a response from support. Where are you guys?
|
|
|
|
Jeremy
|
| Posted: 09/11/2002, 7:56 AM |
|
I've found that posting a support question here doesn't get nearly as prompt of a response as posting it in the support system. I would post it there if you need it resolved asap....
Jeremy
|
|
|
|
Nicole
|
| Posted: 09/14/2002, 5:03 AM |
|
Hello,
this problem was reported in one of CCS Beta versions.
The latest one (that is CCS1.0.7) is free of it. Just upgrade. The download link is:
http://www.codecharge.com/download/files/CCStudio1_0.exe
|
|
|
|
