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 django-users+unsubscr...@googlegroups.com.
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