Django Using Ajax With Forms, Views

I have a form that is used to add an item where 2 dropdowns are populated using different database than the database where the form will be submitted. I would like to add AJAX to t

Solution 1:

I got it to work. Seems liked on the js file I was sending the 2nd parameter after the parameter list. Here is the new code:

functionget_data(){
newAjax.Request('/abc/abc/add', { 
method: 'POST',
parameters: $H({'type':$('id_data').getValue(), 
                'csrftoken':$( "csrftoken" ).getValue()
                 }),
onSuccess: function(transport) {
var e = $('id_data1')
if(transport.responseText)
      e.update(transport.responseText)
}

}); // end new Ajax.Request
}

Here is my view:

if request.is_ajax():
    cur = connections['data'].cursor()
    SQL = 'SELECT uuid, name FROM abc_abc where parent_id  = %s'
    auto_type = request.POST.get('type','')
    conv = iri_to_uri(auto_type)
    conv2 = (conv,)
    cur.execute(SQL,conv2)
    colors = dictfetchall(cur)
    return render_to_response('abc/add.html', {
            'colors' : colors,
            }, context_instance=RequestContext(request))

Here is the html obejct:

<tableborder="0"cellpadding="0"cellspacing="0"><tr>{{ form.abc.errors }}</tr><tr><th><label>ABC:</label></th><td><selectname="abc"id="id_abc"><optionvalue=""selected="selected">---------</option>
 {% for c in colors %}
<optionvalue="{{ c.uuid }}">{{ c.name }}</option>
    {% endfor %}
</select></td><td></td></tr></table><br>