0
I have a django project that is connected to SQL server database and when i
tried to click button to retrieve data from the database the system crash .
i am trying to convert the below syntax in ORM into raw sql:
dbEntry = Person_.objects.get(pk =pk)
Note : *I am not using ORM*
once i tried to perform the task the system crash and display:
getEvents() got unexpected keyword argument "id"
urls.py
path("events/<int:id>/",getEvents,name = "getEvents"),
views.py
def getEvents(request,pid):
q1 = cuesor.execute("Select Person_.ID FROM Person_ WHERE ID = pid")
print("q1=",q1)
qresult = q1.fetchone()
print("qresult",qresult)
return render(request,"connect.html",{"qresult":qresult})
list.html
<form method = "GET" action = "{% url 'getEvents' obj.0 %}"# obj is the
iterator --- 0 is the first field in the table == ID
<button class = "btn btn-primary">get details</button></form>
display.html
{% for row in qresult %}
<p> {{ row.0 }} </p>{% endfor %}
--
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 view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/12fcc5c9-960d-4690-b479-bcbddb04ea99%40googlegroups.com.
