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

 querry help needed

Print topic Send  topic

Author Message
itzumar

Posts: 88
Posted: 01/06/2014, 10:29 AM

Database Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay


how to write this querry in code chrage studio to executemain querry can any well help?????

SET SQL_BIG_SELECTS=1
_________________
Umar
View profile  Send private message
eratech


Posts: 513
Posted: 01/06/2014, 4:15 PM

Umar - that looks like a Database error (MySQL probably), not Codecharge.

Unless you change your query WHERE to have fewer rows then it will probably still happen.

If you are doing JOINs you might be getting bigger datasets than you think - therefore you get the MAX_JOIN_SIZE error. For example, google "cross-product" joins which often cause problems.

Check out this similiar question on stackoverflow with several solutions:

http://stackoverflow.com/questions/950465/mysql-sql-big-selects

Eric
_________________
CCS 3/4/5 ASP Classic, VB.NET, PHP
Melbourne, Victoria, 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.