Problem with Mysql Quires in django

hi
I want to use this mysql Query
" SELECT count(*) as class_roll_no FROM student_profile where
class_roll_no !='00 ' ";
in my view file

Is it possible?

I try this code
view.py file is :

from django.shortcuts import render_to_response
from mysite.student.models import Profile
from django.db.models import Count

def fulldetail(request):
fulldetail = Profile.objects.all().order_by('class_roll_no')
total_count = Profile.objects.filter( class_roll_no !='00')
total = total_count.count()
return render_to_response("userprofile/profile/fulldetail.html",
{"fulldetail" : fulldetail, "total":total} )

Is this correct way to use this?
if not please help or give any tutorials how to use mysql quires with
some conditions.

template file code is:

Total = {{ total }}
<table >
<tr><th>PHOTO<th>NAME<th>ROLL NO<th>BRANCH</tr></thead>

{% if fulldetail %}
{% for part in fulldetail %}
{% if part.firstname %}
<tr><td>{% if part.photo %} <img src="{{ part.photo.url }}"
height="50" />{% endif %}<td>{{ part.firstname }}
{{ part.middlename }} {{ part.lastname }}</
a><td>{{ part.class_roll_no}}</a> <td>{{ part.branch }}</tr>
{% endif %}
{% endfor %}
{% else %}
<p> Data is Not available.</p>
{% endif %}
</td></tr>
</table>

I only count number of entry with condition.

Thanks

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