> > I tried this, its not working.
>
> Sorry, but "not working" does not constitute useful information.
>
> My car isn't working. Can you fix it? ;-)

model.py
 from django.db import models
from django.forms import ModelForm

class Input(models.Model):
    input1 = models.FloatField()
    input2 = models.FloatField()

class Output(models.Model):
        out = models.ForeignKey(Input)
        output = models.FloatField()

class InputForm(ModelForm):
    class Meta :
        model = Input

class OutputForm(ModelForm):
    class Meta :
        model = Output

view.py
from django.http import HttpResponseRedirect
from django.shortcuts import render_to_response, get_object_or_404
from mysite.add_db.models import *
from django.template import RequestContext
from django.core.urlresolvers import reverse

def add_db(request):
    if request.method == 'POST':
        form = InputForm(request.POST)
        if form.is_valid():
            cd = form.cleaned_data
            input1 = cd['input1']
            input2 = cd['input2']
            p = form.save()
            form_output = OutputForm()
            output = input1 + input2
            form_output_final = p.output_set.create(output=output)
            return render_to_response('add_db/output.html', {'form': form,
'input1':input1, 'input2':input2, 'output':output},
context_instance=RequestContext(request))
    else:
        form = InputForm()
    return render_to_response('add_db/add.html', {'form': form},
context_instance=RequestContext(request))

def result(request):
    input_list = Input.objects.all().order_by('-id')
    output_list = Output.objects.all()
    return render_to_response('add_db/result.html', {'input_list':
input_list, 'output_list': output_list})

Templates result.html
<h1> All Data </h1>
{% if input_list %}
    <ul>
    {% for input in input_list %}
    {% for output in output_list %}
         {% if input.id == output.id %}
         <li>{{ input.id}} : {{ input.input1 }} + {{ input.input2 }} =
{{output.output}} </li>
         {% endif  %}
        {% endfor %}
        {% endfor %}
     </ul>
{% else %}
    <p>No data are available.</p>
{% endif %}

now i try this code

{% for input in input_list %}
    {% for output in output_list %}
         {% if input.id == output.id %}

my problem is solved
but is this correct way to get values from two tables and use in
templates?

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To post to this group, send email to django-us...@googlegroups.com.
To unsubscribe from this group, send email to 
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en.

Reply via email to