Need help for sql stored proc

[Gurmeet Kaur]

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

[Sudha Mohan]

hi friends tell me future of django jobs and salaries with 2+ experience

> --
> 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...@googlegroups.com.
> To post to this group, send email to django...@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.

[Matthew Pava]

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

--

[Gurmeet Kaur]

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.

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/5e22807f4c0e49fd80f4ea2a7273c965%40ISS1.ISS.LOCAL.