hyperlinking to a SQL stored procedure

	Home Register Search Help Login

Recent Posts
Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

Sponsors
Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.
Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.
Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

hyperlinking to a SQL stored procedure

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP, PHP, and Database >> hyperlinking to a SQL stored procedure

Page: [1]


dougancil2009 Posts: 1 Joined: 4/8/2009 Status: offline	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 Posts: 722 Joined: 2/22/2002 From: Dallas, TX Status: offline	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? _____________________________ Follow us on TWITTER (in reply to dougancil2009)


dougancil Posts: 1 Joined: 6/3/2008 Status: offline	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? (in reply to dougancil2009)


TexasWebDevelopers Posts: 722 Joined: 2/22/2002 From: Dallas, TX Status: offline	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. _____________________________ Follow us on TWITTER (in reply to dougancil)

Page: [1]

All Forums >> Web Development >> ASP, PHP, and Database >> hyperlinking to a SQL stored procedure

Page: [1]

Jump to: 1

New Messages	No New Messages
Hot Topic w/ New Messages	Hot Topic w/o New Messages
Locked w/ New Messages	Locked w/o New Messages

Post New Thread

Reply to Message

Post New Poll

Submit Vote

Delete My Own Post

Delete My Own Thread

Rate Posts