itzumar
Posts: 88
|
Posted: 06/07/2013, 6:33 PM |
|
dears all!
please guide me how to add this code
mysql_query("set sql_big_selects=1");
to avoid following error in code chrage studio?
ERROR 1104: The SELECT would examine too many records and probably take a very long time. Check your WHERE and use SET OPTION SQL_BIG_SELECTS=1 if the SELECT is ok
_________________
Umar |
|
|
bannedone
Posts: 273
|
Posted: 06/07/2013, 10:14 PM |
|
Try in the before execute select event
add this custom code
$Component->ds->SQL=$Component->ds->SQL." set sql_big_selects=1";
_________________
John Real
CodeCharge Studio Support, Training, Consulting, Development, Web based solutions
http://realsites.biz
http://ccselite.com
Other Banned IDs on this Forum. jjrjr1, jjrjr2 |
|
|
itzumar
Posts: 88
|
Posted: 06/08/2013, 8:24 AM |
|
error occur? any other advice?
_________________
Umar |
|
|
MichaelMcDonald
Posts: 640
|
Posted: 06/08/2013, 10:14 AM |
|
Does the statement have to be in capitals ?
SET SQL_BIG_SELECTS=1
_________________
Central Coast, NSW, Australia.
|
|
|
|