One select box to query two separate Fusion Tables.

[Daniel Bentley]

Hi all,

I've created this page here from two different table sources

http://openpreston.appspot.com/counciltest.html

source: http://pastebin.com/uqWX3VyW

And as you can see, the values queried from both tables are the same "Ashton, Brookfield..."

Is there a way to use one select box to show results for "Ashton" from both tables rather than change the values in each box?

Many thanks.

[asgallant]

You can merge those two functions together into one rather easily:

function changeMapl (val) {
    // since you pass 'this.value' in the function call, you can get rid of those doc.getElement calls
    var searchString = val.replace(/'/g, "\\'");
    layerl0.setOptions({
        query: {
            select: "'geometry'",
            from: 3550449,
            where: "'STwardname' = '" + searchString + "'"
        }
    });
    
    layerl1.setOptions({
        query: {
            select: "'Postcode'",
            from: 3560603,
            where: "'Ward' = '" + searchString + "'"
        }
    });

[Daniel Bentley]

Thanks, what do I change to the select box code?

[asgallant]

Just change the function name (ie, from changeMapl0 -> changeMapl).

[Daniel Bentley]

ah ha! thank you very much for your help.

[asgallant]

You're welcome.