Hi George, You're looking at this from the wrong point of view.
The Google Maps API doesn't know anything about your SQL queries. It's a browser-based JavaScript API. It doesn't see your SQL code, only what is actually sent down to the browser. To troubleshoot this problem, forget about SQL and forget about your server languages/frameworks/databases entirely. Look at it only from the point of view of the browser. All that counts is the HTML, CSS, and JavaScript code sent to the browser, along with any other data such as XML or JSON sent down for an Ajax request. You can use client tools such as the Network tab in most browser debuggers - Firebug or the built-in tools in Chrome, for example. This will show you what the browser actually receives. Your SQL query must be generating some XML or JSON or some such? That's what you need to look at. Or post a link to your map and someone will probably be happy to take a look at it. Once you find the problem in the browser, then you can take a step back and see what you can do differently in your server code (SQL or other) to avoid generating the bad code/data. -Mike On Sun, Mar 20, 2011 at 4:49 AM, George Maina <[email protected]>wrote: > Has anyone had a problem like the one above, > im having the same issue with both v2 and v3 of google maps, > when i try to load maps with markers from a b with certain querys, > i get a blank screen, for instance, the query, > > $sql="select * from my_table where longt !=0 and lat != 0 and > creater_id = \"$user_id\" " ; > > works but the quey > > //$sql="select * from revewables where longt !=0 and lat != 0 " ; > > fails and i get a blank screen, > > both querys are correct, as since when i run them with text resaults, > they do not fail, > > also, as soon as i add a sub query, of whatever kind, the maps both > for v2 and v3 just dont work. > > Anybody having a solution to this? > > -- > You received this message because you are subscribed to the Google Groups > "Google Maps JavaScript API v3" group. > To post to this group, send email to > [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/google-maps-js-api-v3?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Google Maps JavaScript API v3" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-maps-js-api-v3?hl=en.
