Sunday, December 4, 2011

SQLYOG | Wrong results are returned for FOUND_ROWS().


I am getting wrong results are returned for FOUND_ROWS(). I found easy fix from sqlyog forum.. they have given some steps to fix this problem..

"The problem with FOUND_ROWS() is that it is conflicting with the Query Profiler as Profiler will SELECT .. FROM INFORMATION_SCHEMA ... To use FOUND_ROWS() you will have to turn Query Profiler OFF. If you don't FOUND_ROWS() will return a rowcount for the ´profiling´ table in Information_Schema and not a rowcount for the table where user executed his query. We are considering how we could at least warn about this, of course."

I have attached screent shot where to change to fix this issue...

Google maps api: https security error coming in IE

my web page having google direction map using javascript api and I have got https error whenever try to loading graph into my web page in IE.. I have fixed that problem by small code change...

With HTTS ERROR:
<script type="text/javascript" src="https//maps.googleapis.com/maps/api/js?v=3&sensor=false"></script>



FIXED BY: I have removed "https" from the source URL
<script type="text/javascript" src="//maps.googleapis.com/maps/api/js?v=3&sensor=false"></script>