Hi All,

I am doing some very cool stuff with the Google Maps API and want to clean up a data query condition. I have an HTML form which displays delivery sites on a Google Map using a bunch of Javascript. The delivery sites come from an XML source file which is created via WebFocus. I have a button on the map page (parent) that will recreate the XML file with a set of delivery sites based on a new date. Then the XML file is reloaded to display the new sites on the Google map. Here's the rub.

1) When the child query is executed to get the new data a popup window is displayed. I would like the query to run without any action on the screen.
2) Since the resultant data set could be empty (no lines) I would like to be able to let the user know that we are going to display new data - they will still see the old.

Now I can run the child query and close the window immediately from the parent form and you get a screen flash. Not horrible but certainly inelegant. I'd like to clean this up. But worse is: How can I know that the query returned records to then reload the data?

Ive tried writing the number of lines returned in the query into a hidden field on the query form and then have it write that back to the parent form into another hidden field. But javascript doesn't wait around when you call a function to execute the query. It just moves on to the next statement and the hidden field on the parent does not get populated with a value.

Anyone have any ideas?

By the way, I've done a lot of head banging to get this Google Map API stuff working with out using the IB wrappers. I'll be happy to share code if anyone is interested. This stuff is just too neat not to share ideas and tips.

Thanks,

Norb

What is the query returning that it can be held and used with a hidden form object?

Anytime you want to run a request and not have the request over right the screen, or open another browser, you will have to use an ajax call. If you are using google maps, then you are most likely using the google javascript api. If so, doesn't google supply you with examples?

With ajax, you can test the result to see if there are any values or whatever, so you should be able to display the appropriate messages to your users.

Can you post some code Norb, to make it a bit more clear?