I am constructing a page for use on one of the sites I manage at Wild Apricot.  The page will contain an image map with numerous areas.  Each area represents a resource that is either available, or in use by a member.  The resources reserved are identified in a member data field.  I would like to use AJAX techniques to lookup member data from the onMouseOver event.  A database API allowing ODBC, XML, or another standard access would be useful here.

My (horrible) workaround, for the moment, will be to export the membership data and reformat the useful data into a JSON file.  That file will be pre-loaded in JavaScript object(s) for use in the onMouseOver code.

As the resource data will change somewhat each day, any dynamic access to the data would be better than my planned approach.  A hidden page, for instance, with membership data in tabular or XML format could be used.

Please provide the API or a workaround at your earliest convenience.