reverting back to order_by

1 files changed, 2 insertions, 4 deletions

diff --git a/tbc/views.py b/tbc/views.py
index 21f059c..47637ad 100755
--- a/tbc/views.py
+++ b/tbc/views.py
@@ -451,8 +451,7 @@ def BookDetails(request, book_id=None):
         else:
             context['user'] = request.user
     book = Book.objects.get(id=book_id)
-    query = 'SELECT * from tbc_chapters where book_id = (SELECT id from tbc_book where id='+book_id+') ORDER BY LENGTH(name), name;'
-    chapters = Chapters.objects.raw(query)
+    chapters = Chapters.objects.filter(book=book).order_by('name')
     images = ScreenShots.objects.filter(book=book)
     context['chapters'] = chapters
     context['images'] = images
@@ -465,8 +464,7 @@ def BookReview(request, book_id=None):
     if is_reviewer(request.user):
         if book_id:
             book = Book.objects.get(id=book_id)
-            query = 'SELECT * from tbc_chapters where book_id = (SELECT id from tbc_book where id='+book_id+') ORDER BY LENGTH(name), name;'
-            chapters = Chapters.objects.raw(query)
+            chapters = Chapters.objects.filter(book=book).order_by('name')
             images = ScreenShots.objects.filter(book=book)
             context['chapters'] = chapters
             context['images'] = images