FrontPage Dataview and Stored Procedures

[Steve]

We are currently using the Dataview Web Part in
SharePoint to display a grid. We are having troubles
passing a parameter to a stored procedure and display the
result set. We are forced to build a big select
statement and tossing in the variable on the Select.

Any thoughts

 

[Jon Spivey]

Hi Steve,
you shouldn't need a select statement if you're using a stored procedure.
Say your SP looks like this
CREATE PROCEDURE spTest
@something varchar(50)
AS
select * from table where somefield = @something

Then you can call the sp with a custom query such as
exec spTest 'SomeValue'

 

[Teemu]

Hey Jon,
Could you give some extra advice:
I have done that stored procedure, what is similar than your example.
And i also check that exec call, it's ok.
But now i get only two cell in my dataview web part:
|Status: success | PassTrough_dataSet

I can't figured out where i go wrong.

Teemu