Re: Getting "ProgrammingError" when saving my queryset into a session variable

2008-06-30 Thread Karen Tracey
On Mon, Jun 30, 2008 at 11:54 AM, Greg <[EMAIL PROTECTED]> wrote:

>
> Hello,
> I have the following code:
>
> ///
>
> def tracking(request):
>a = Order.objects.filter(order_status=2)
>request.session['tracking'] = list(a)
>
> ///
>
> Whenever i access this function I get the following error:
>
> ProgrammingError at /tracking/
> operator does not exist: character varying = integer at character 676
> HINT: No operator matches the given name and argument type(s). You
> might need to add explicit type casts.
>
> The line 'request.session['tracking'] = list(a)' is causing the error
>
> ///
>
> Any suggestions?  Thanks
>

What kind of field is order_status?  It sounds like the database (postgres?)
is complaining because you are trying to select rows based on comparison of
a varchar field to an integer (2).

Karen

--~--~-~--~~~---~--~~
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?hl=en
-~--~~~~--~~--~--~---



Getting "ProgrammingError" when saving my queryset into a session variable

2008-06-30 Thread Greg

Hello,
I have the following code:

///

def tracking(request):
a = Order.objects.filter(order_status=2)
request.session['tracking'] = list(a)

///

Whenever i access this function I get the following error:

ProgrammingError at /tracking/
operator does not exist: character varying = integer at character 676
HINT: No operator matches the given name and argument type(s). You
might need to add explicit type casts.

The line 'request.session['tracking'] = list(a)' is causing the error

///

Any suggestions?  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 [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en
-~--~~~~--~~--~--~---