hyperlinking to a SQL stored procedure (Full Version)

All Forums >> [Web Development] >> ASP, PHP, and Database

Message

---

dougancil2009 -> hyperlinking to a SQL stored procedure (4/8/2009 16:20:41) Can you hyperlink to a SQL stored procedure? if so does anyone know how to go about doing that?

---

TexasWebDevelopers -> RE: hyperlinking to a SQL stored procedure (4/8/2009 18:25:34) A stored procedure is a subroutine stored in the database data dictionary. Why in the world would you want to write a hyperlink to it? It would be like trying to write a hyperlink to a VB script.... Stored procedures are like SQL statements (and can return result sets from the db) and can contain Loops and If statements, etc. What are you really trying to do--trigger an event?

---

dougancil -> RE: hyperlinking to a SQL stored procedure (4/9/2009 11:08:13) I personally have no idea why anyone would want to do this, but I was told to investigate if it could be done. I'm not typically the person who writes the code for projects like this and my boss asked me if it was "achievable." What I believe that he wants to do is to retrieve data from a stored procedure and pass that to another page to be displayed. There is a query written already that is supposed to retrieve the data and rather than liking directly to the database, I think the best way would be to pass the query values to the destination page where the page runs the stored procedure and then displays the results. Can that be done?

---

TexasWebDevelopers -> RE: hyperlinking to a SQL stored procedure (4/9/2009 13:57:15) Here's the way to look at it (uber simple version for your boss): The database holds the data. The stored procedure is a sql statement that retrieves the data. The results page displays the data. The stored procedure does not contain data. The stored procedure does not display data. And you are correct..the query values are passed either directly into the sql statement to be processed server-side and create a recordset of data from the database. Or passed directly to the stored procedure which creates a recordset of data from the database. At the end of the process the recordset of data can be called back to a page and displayed. Again, if you simply think of the stored procedure as a sql statement on steroids then you'll get the picture.

---

Page: [1]

Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI

0.078125