Re: Need help for sql stored proc

Thank you Matthew for sharing this link with me but my situation is:

I have some textboxes whose value I want to pass to sql query and want to do a select *. Right now, I am doing that with the help of queryset but the issue I am facing with this approach is that I need to do multiple ifs and else because user is not restricted to pass values in all textboxes.

If I use cursor.callproc(), will I be able to get the data and show it on the page? If yes then how can I do that?

Please suggest.

On Wed, Oct 17, 2018 at 12:10 PM Matthew Pava <Matthew.Pava@iss.com> wrote:

https://docs.djangoproject.com/en/2.1/topics/db/sql/#calling-stored-procedures

 

 

From: django-users@googlegroups.com [mailto:django-users@googlegroups.com] On Behalf Of Gurmeet Kaur
Sent: Wednesday, October 17, 2018 11:06 AM
To: django-users@googlegroups.com
Subject: Need help for sql stored proc

 

Hi all, 

 

I have a ms sql stored proc and want to use it. How can I do that? Do I need to write the class just like a view in models.py?

 

Please suggest.

 

Thanks, 

Gurmeet Kaur

--
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+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAEbKJVg%3DRfXuokWh9SPakJLUq3qCVrmk-DBaFSXi3xu651fZ-g%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

--
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+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/5e22807f4c0e49fd80f4ea2a7273c965%40ISS1.ISS.LOCAL.
For more options, visit https://groups.google.com/d/optout.

--
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+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAEbKJVi_GxCLB5rq%3DdWvp1QdcdFnN%3DY_cdsjz0Jb%2BdVGQoJexw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.