Getting started with Ajax - how do I query the db without 'submitting' the page?

Hi Nick -

Let me also recommend jQuery.

Fantastic stuff once you get the hang of it, and even the simple stuff is cool.

Ok... here's what I did...

There are probably better ways to do it, but I cheated, in that I did it my way, and got some good results.

Using divs to define my display areas here's what I did:

I have 2 select statements -

1) Selecting from 1 populates the other select.

2) The JS function is triggered when a selection is made.

3) The Ajax statement goes out to a web page, that new page does a query and creates a new div with the same name as "txtResult", for my example.

4) The Ajax then pulls back the new page and displays it.

It's pretty easy after a few tries.

Hope this helps.

Doug

function dynamic_Select(poolID){
$.ajax({
type: "GET",
url: '/forms/selectSchedules.cfm',
data: "id=" + poolID,
dataType: "text/html",
success: function(html){
    $("#txtResult").html(html);    
    }
});
}

    <div style=" padding-left:100px;">   
        Select Pool:
        <select name="pool" onchange="dynamic_Select(this.value)" />
        <option value="#" selected="selected">-Select-</option>
        <cfoutput query="pools">
        <option value="#poolID#">#poolName#</option>
        </cfoutput>
        </select>

        <span id="txtResult" style=" padding-left:100px;">
            Select Schedule:
            <select name="schedules" id="schedules" onchange="getInfo()">
            <option></option>
            </select>
        </span>
    </div>

http://www.prototypejs.org/

and/or

http://jquery.com/

is a good start (and probably end). Hope this helps.