Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- def conker(parser):
- 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 = '2006' ) " % borrow );
- cur.execute("SELECT * FROM View_Papers ");
- 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/rdpapersnow.html', {'dog': list2, })
Add Comment
Please, Sign In to add comment