def MainPage(request): #contacts = Contact.objects.all().order_by("-id")[:10] contacts = [] cursor = connection.cursor() cursor.callproc('OnlineDating_Contact_User_Get') raw_Contacts = cursor.fetchall() cursor.close(); if(raw_Contacts is not None): for raw_contact in raw_Contacts: contact = Contact() contact.name = raw_contact[0] contact.email = raw_contact[1] contact.id = raw_contact[2] contact.contact_uid = raw_contact[3] contact.phone = raw_contact[4] contact.hobbies = raw_contact[5] contact.interestedin = raw_contact[6] contact.currentstatus = raw_contact[7] contact.maritalstatus = raw_contact[8] contact.contact_of = raw_contact[9] contact.last_updated = raw_contact[10] contact.image = raw_contact[11] contacts.append(contact) onlineUsers = _getOnlineUsers() return render(request,'DatingApp/MainPage.html',{'user':request.user,'contacts':contacts,'onlineUsers':onlineUsers})