Can anyone please tell me how can i filter record set.I have dropdownlist .
I am selecting releasenumber,productgroupid,osgroupid and Componentid .
but Componentid is by default 0.it is displaying builds by executing below stored procedure .
my problme is it is displaying lot of unwanted builds. i need to filter it.
the stored procedure sp_selectbuilds is getting matched data from one table.
rightnow it is getting data with componentid =0. but i want to get data with COmponentID not equal To 0
How can i filter to get data with the componentID NOT equal to 0. where can i filter in asp page or stored procedure.
I have code in ASP page like below
Driverpage.asp:
From the Database below stored procedure is executing
I am selecting releasenumber,productgroupid,osgroupid and Componentid .
but Componentid is by default 0.it is displaying builds by executing below stored procedure .
my problme is it is displaying lot of unwanted builds. i need to filter it.
the stored procedure sp_selectbuilds is getting matched data from one table.
rightnow it is getting data with componentid =0. but i want to get data with COmponentID not equal To 0
How can i filter to get data with the componentID NOT equal to 0. where can i filter in asp page or stored procedure.
I have code in ASP page like below
Driverpage.asp:
Code:
Set rs = objDriver.GetDriverList(intComponentID, intReleaseNumberID, intProductGroupID, intOSGroupID)
If Not(rs.BOF Or rs.EOF) Then
'show all driver builds
else
'Display Not availablle
end if
From the Database below stored procedure is executing
Code:
Create procedure sp_GetDriverList
(
@intComponentID int,
@intReleaseNumberID int,
@intProductGroupID int,
@intOSGroupID
)
AS
EXEC sp_selectbuilds intComponentID,intReleaseNumberID,intProductGroupID,intOSGroupID