Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- def rdpaper(request, slag):
- import pymssql
- con = pymssql.connect(user="d", password="d", host="d", database="d");
- cur = con.cursor();
- borrow = settings.RGROUP_ID;
- # cur.execute("SELECT * FROM View_Papers WHERE ResearchGroupID =%s and year =%i order by Year DESC, Publication " % borrow, slag);
- cur.execute("SELECT * FROM View_Papers WHERE (Year = %s and ResearchGroupID =%s) ", (slag, borrow));
- dog = cur.fetchall();
- bongo = "";
- title = "";
- cat = "";
- list2 = [];
- for x in dog:
- if x[1] != bongo:
- if bongo != "":
- list1 = [cat, title, num7, num8, num9, num10, num11, num12, num13]
- list2.append(list1)
- cat = ""
- title = x[6]
- num7 = x[7]
- num8 = x[8]
- num9 = x[9]
- num10 = x[10]
- num11 = x[11]
- num12 = x[12]
- num13 = x[13]
- cat += x[3]
- if x[5] != None:
- cat += ", "
- cat += x[5]
- cat += ". "
- bongo = x[1]
- else:
- cat += x[3]
- if x[5] != None:
- cat += ", "
- cat += x[5]
- list1 = [cat, title, num7, num8, num9, num10, num11, num12, num13]
- list2.append(list1)
- return render_to_response('publications/rdpapers.html', {'dog': list2, 'faculty_name':settings.FACULTY_NAME, 'rgroup_id':settings.RGROUP_ID,
- 'slag':slag,})
Add Comment
Please, Sign In to add comment