Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP 3 Classic ASP Active Server Pages 3.0 > Classic ASP Databases
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old June 4th, 2003, 10:25 AM
Authorized User
 
Join Date: Jun 2003
Location: , , .
Posts: 28
Thanks: 0
Thanked 0 Times in 0 Posts
Default Problem retrieving resultset from asp ...

I'm trying to execute a stored procedure which involves a temp table. I'm getting no errors in the code, but no resultset either.
The whole process worked fine with SQL Server 7.0, but not 2000. Anyone run into this?

thanks.
Melissa Mussitsch
ANSYS - IT
Reply With Quote
  #2 (permalink)  
Old June 5th, 2003, 08:58 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Sydney, NSW, Australia.
Posts: 111
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Do you have SET NOCOUNT ON inside your sproc (prior to doing the insert into the temp table)? Otherwise the "xx records affected" message is being returned, and placed into the recordset object. You can SET NOCOUNT ON after you have done anything that returns "xx records affected".
Reply With Quote
  #3 (permalink)  
Old June 17th, 2003, 07:25 AM
Authorized User
 
Join Date: Jun 2003
Location: , , .
Posts: 28
Thanks: 0
Thanked 0 Times in 0 Posts
Default



That was exactly what I needed to do!

Thanks!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
retrieving images from database in asp.net pages sweetyrathore ASP.NET 1.x and 2.0 Application Design 3 March 25th, 2012 04:29 AM
Retrieving Roles using C# / ADSI in ASP.Net app Prashant.k.m ASP.NET 1.0 and 1.1 Professional 0 October 4th, 2005 04:28 AM
retrieving images from Access DB into asp page programmer_scs Classic ASP Databases 1 November 30th, 2004 09:19 AM
problem retrieving from database rajuru Beginning PHP 2 October 8th, 2004 12:34 PM
Retrieving the Author of a file in ASP.Net mahulda ASP.NET 1.0 and 1.1 Basics 1 July 18th, 2004 10:13 AM



All times are GMT -4. The time now is 01:05 PM.


Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.