CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> PHP

 where to add this code?

Print topic Send  topic

Author Message
itzumar

Posts: 78
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
View profile  Send private message
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";

8-)

_________________
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
View profile  Send private message
itzumar

Posts: 78
Posted: 06/08/2013, 8:24 AM

error occur? any other advice?
_________________
Umar
View profile  Send private message
MichaelMcDonald

Posts: 639
Posted: 06/08/2013, 10:14 AM

Does the statement have to be in capitals ?

SET SQL_BIG_SELECTS=1
_________________
Central Coast, NSW, Australia.

View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by UltraApps.com  and YesSoftware, Inc.