[dba-VB] RSS Feed database

I'm just shooting int the dark... How about parenths around the @ID int

Scott Marcus
IT Programmer
TSS Technologies Inc.
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 

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