Weird caching issue with database query

[Michael Jensen]

I have a page that shows a grid of items and dates associated with that. I am using a JOIN query to get the data, but it appears to be cached or delayed somehow. When I query the database directly I can see the data has been updated, but on my page when I refresh it still doesn't show data there. Any ideas what it could be?

This is the structure of my views.py for that page:

    cursor = connection.cursor()

    sql =   '''*** complicated sql join query here with a search term...***'''

    try:

        cursor.execute(sql.format(search_term))

        the_items = dictfetchall(cursor)

I'm using Postgres and Django.

I tried python manage.py clear_cache but that didn't make any difference.

Thoughts? Thanks in advance!

[Michael Jensen]

Looks like it was my sql query, figured it out!