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

On Friday, September 4, 2020 at 1:07:26 PM UTC-6 Michael Jensen wrote:

> 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!
>

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/f2fec1df-1d33-495b-82b7-31b151d11933n%40googlegroups.com.

Reply via email to