dunechi1d
Posts: 23
|
| Posted: 05/14/2009, 11:40 AM |
|
I need to add the STRAIGHT_JOIN MySQL command after the SELECT statement of a particular datasource. (Without the STRAIGHT_JOIN a search to one of the joined tables in the datasource just hangs but with this addition it works)
I couldn't find how to add this using the GUI SQL datasource builder so instead of the GUI I wrote my own SQL statement.
The problem is that at some point CodeCharge issues a 'SELECT Count(*)' of the SQL statement disregarding the STRAIGHT_JOIN (presumably the count(*) is performed for the navigation calculations). There is no Event I know of where I can effect the SQL statement of the count(*) and thus the SQL still hangs.
Any help will be appreciated!
Danny
|
 |
 |
datadoit
|
| Posted: 05/15/2009, 4:37 AM |
|
See the help file and look for CountSQL.
|
|
|
|
dunechi1d
Posts: 23
|
| Posted: 05/15/2009, 7:15 AM |
|
Thanks so much datadoit !
I opened a support ticket 3 days ago with this question but it's been ignored so far...
Danny
|
|
|
|
|
