[dba-VB] RSS Feed database

If you go to your QA window and type in

EXEC upWebNewsSource_SelectOne 1

or a valid ID, what is the resultset?



On 8/24/05, Scott Marcus <marcus at tsstech.com> wrote:
> 
> I'm just shooting int the dark... How about parenths around the @ID int
> 
> Scott Marcus
> IT Programmer
> TSS Technologies Inc.
> www.tss.com <http://www.tss.com>
> 
> 
> -----Original Message-----
> From: dba-vb-bounces at databaseadvisors.com
> [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of John W. Colby
> Sent: Wednesday, August 24, 2005 11:15 AM
> To: dba-vb at databaseadvisors.com
> Subject: [dba-VB] RSS Feed database
> 
> Do I have no takers helping me get this thing working? The end result
> will
> be a system for logging an RSS feed into data tables for analysis or
> use.
> Could be niiiice. ;-)
> 
> I have made good progress, I have a database set up in SQL Server
> specifically for this project. I have the tables built per the script
> included in the C# zip. There are two records in the WebNewsSource
> table.
> I am logging in to the database. The issue at this point is that the SP
> that is supposed to return the rows in the database apparently doesn't.
> 
> The SP looks like:
> 
> ------------------------------------------------------------------------
> ----
> -----
> -- Stored procedure that will select an existing row from the table
> 'WebNewsSource'
> -- based on the Primary Key.
> -- Gets: @ID int
> ------------------------------------------------------------------------
> ----
> -----
> CREATE PROCEDURE [dbo].[upWebNewsSource_SelectOne]
> @ID int
> AS
> SET NOCOUNT ON
> -- SELECT an existing row from the table.
> SELECT
> [ID],
> [Source],
> [RSSURL],
> [RSSSelect],
> [RSSTitle],
> [RSSLink],
> [RSSDescription]
> FROM [dbo].[WebNewsSource]
> WHERE
> [ID] = @ID
> 
> 
> GO
> 
> How do I go about just running the SP passing in an ID and viewing the
> results?
> 
> John W. Colby
> www.ColbyConsulting.com <http://www.ColbyConsulting.com>
> 
> Contribute your unused CPU cycles to a good cause:
> http://folding.stanford.edu/
> 
> 
> _______________________________________________
> dba-VB mailing list
> dba-VB at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-vb
> http://www.databaseadvisors.com
> 
> _______________________________________________
> dba-VB mailing list
> dba-VB at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-vb
> http://www.databaseadvisors.com
> 
> 


-- 
-Francisco
http://pcthis.blogspot.com |PC news with out the jargon!
http://sqlthis.blogspot.com | Tsql and More...