Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server ASP
|
SQL Server ASP Discussions about ASP programming with Microsoft's SQL Server. For more ASP forums, see the ASP forum category.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server ASP section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 8th, 2004, 01:12 AM
Registered User
 
Join Date: Jun 2004
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Navigate and display record in store procedure

hi,

i am looking for navigate and display record in stored procedure.
to navigate record i have uased below cursor

DECLARE my_cursor CURSOR
FOR select filename from fileinfo where caclientsloginid=11
WHILE @@FETCH_STATUS = 0
BEGIN
FETCH NEXT From my_cursor
END

now i want to display each record fetch by the cursor. tell me how to display each record. regards, irfan


 
Old June 8th, 2004, 01:29 AM
Friend of Wrox
 
Join Date: May 2004
Posts: 642
Thanks: 0
Thanked 43 Times in 42 Posts
Default

You can directly return a recordset from the Stored procedure

select filename from fileinfo where caclientsloginid=11

and display this as you do in normal asp program.


Om Prakash
 
Old June 8th, 2004, 01:45 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

Are you looking for display of records on web page or just you want the stored proc to display the records from the query?

Cheers!

_________________________
-Vijay G
Strive for Perfection





Similar Threads
Thread Thread Starter Forum Replies Last Post
Store Procedure For Attendance prasanta2expert SQL Server 2000 4 July 5th, 2012 03:10 AM
Store procedure help... RinoDM SQL Server 2000 7 August 11th, 2008 07:09 PM
Store procedure help ??? RinoDM SQL Server 2000 8 May 1st, 2008 03:03 PM
Store Procedure sureshyuga SQL Server 2000 0 May 18th, 2007 01:49 AM
How do I Call store procedure kau_shuk VS.NET 2002/2003 1 September 7th, 2006 08:09 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.