On 9/26/06, brad <[EMAIL PROTECTED]> wrote:
>
> Hello. I am having a little trouble retreiving data from my models so
> that I can use the data in my templates to create a html select. The
> template creates the html select, but the select is not populated with
> any options, like I want it to. Thanks in advanced for any and all
> ideas to get this template to work. Here's my model:
>
> class Game(models.Model):
> game_name = models.CharField(maxlength=200)
>
> class Admin:
> pass
>
> def __str__(self):
> return self.game_name
Hi Brad,
I think you may be being confused by the class/table property/column
object/relational mapping thing. To start with, the game_name property
would be better called "name", since we already know it belongs to the
Game model class:
class Game(models.Model):
name = models.CharField(maxlength=200)
class Admin:
pass
def __str__(self):
return self.name
When rendering templates, we need to pass them the data they are going
to render. In this case, we want to render a list of Game objects. The
view function must retrieve the game objects and then include that
list in the template's context variables. Cutting and pasting from
http://www.djangoproject.com/documentation/tutorial3/ with a little
renaming and rearranging, gives us:
from django.shortcuts import render_to_response
from yourproj.yourapp.models import Game
def index(request):
games = Game.objects.all().order_by('name')
return render_to_response('games/index.html', {'games': games})
This will render a template named 'games/index.html', putting a list
of games into the template's context, as a variable named 'games'. We
can then loop over this list in the template:
<p>
<select name="staticSELECT">
{% for game in games %}
<option value="{{ game.id }}">{{ game.name }}</option>
{% endfor %}
</select>
</p>
(Notice that I substituted the game.id for the forloop.counter. This
makes it much easier to retrieve the selected game later, not to
mention making the page more resilient to changes in the backing
database)
Hope all that helps,
Alan.
--
Alan Green
[EMAIL PROTECTED] - http://bright-green.com
--~--~---------~--~----~------------~-------~--~----~
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 [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/django-users
-~----------~----~----~----~------~----~------~--~---
