Hello,
what you want to achieve is called "natural order sorting" which is not
built into any common SQL implementation I know. You have to do it manually
from code, or, if you have to do pagination, add a sorting column that is
numeric (and indexed).
Best,
Gergely
On 28 Sep 2015 08:42, "gintare" <g.statk...@gmail.com> wrote:
> Is it possible to order the query result strings in such a way that th128
> string would be first comparing to th99.
> The query results contains 128 items in format: "th"+number. For instance,
> th1, th2, ...th80, ..th99, th100, th128.
> Than i order results, they go in the following order, th1, th10,th100,
> th101,th102,... th11,th110, ... th2, th20, th21,th22,.. th9,..th99.
> Thus i am not able to get the largest result, which is th128. I am getting
> th99 instead.
>
> def temp(request):
> query = request.GET.get( 'q','')
> #a=Aref5.objects.filter(Rname__contains='book').count() #finds128
>
> a=Aref5.objects.filter(Rname__contains='book').order_by('-Rname')[0:1].get()
> #gets aref5 object
> print(a.Rname) #prints th99 instead of th128, which logically is larger
> return render_to_response('Ath.html', {"query": query})
>
> --
> 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 post to this group, send email to django-users@googlegroups.com.
> Visit this group at http://groups.google.com/group/django-users.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/django-users/69e26bab-210e-4137-adf3-498855d0eae6%40googlegroups.com
> <https://groups.google.com/d/msgid/django-users/69e26bab-210e-4137-adf3-498855d0eae6%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
> For more options, visit https://groups.google.com/d/optout.
>
--
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 post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/CACczBU%2Bi0tVFhMypH7VuPKe9c%2B_-tk8ofdwyMgyAA1h3V4vtAw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
