More query help

  • Well I have a Listings page (Listing-Details.aspx) and on that page is a function that pulls select information about what the user wants to buy.

    Here is the current queries / stored procedures.

    Stored Procedure: GetBuyingIDFromLoginID

    USE [OHT]

    GO

    /****** Object: StoredProcedure [dbo].[GetBuyingIDFromLoginID] Script Date: 05/18/2009 11:08:48 ******/

    SET ANSI_NULLS ON

    GO

    SET QUOTED_IDENTIFIER ON

    GO

    ALTER PROCEDURE [dbo].[GetBuyingIDFromLoginID]

    @prmLoginId varchar(100)

    AS

    BEGIN

    select buyingItem_id,city,[State],within_miles from buying_item where member_id=

    (select member_id from Member where login_id = @prmLoginId)

    END

    which just selects the stuff

    Stored Procedure:

    USE [OHT]

    GO

    /****** Object: StoredProcedure [dbo].[GetLookingFor] Script Date: 05/18/2009 11:09:30 ******/

    SET ANSI_NULLS ON

    GO

    SET QUOTED_IDENTIFIER ON

    GO

    ALTER PROCEDURE [dbo].[GetLookingFor]

    @prmBuyItemID int

    AS

    BEGIN

    select hf.* from buyingitem_feature bf inner join

    house_feature hf on bf.feature_id = hf.feature_id

    where bf.buyingItem_id=@prmBuyItemID

    END

    which inner join's info

    but what the previous programmer didnt do was make it Listing ID specific. Example: lets say there is a listing_id 11111 and someone goes to that listing page, what I want the query to do is pull information for the listing 11111 and display it onto the page so it has to get the Listing_Id and put that into the query somehow as a WHERE statement or something and this is where I am lost.

    (the code for displaying it on the page is complete, just need some help with the query)

    Thanks

  • Maybe you could just add it as another parameter in one of your stored procedures?

    USE [OHT]

    GO

    /****** Object: StoredProcedure [dbo].[GetLookingFor] Script Date: 05/18/2009 11:09:30 ******/

    SET ANSI_NULLS ON

    GO

    SET QUOTED_IDENTIFIER ON

    GO

    ALTER PROCEDURE [dbo].[GetLookingFor]

    @prmBuyItemID int,

    @listingID int

    AS

    BEGIN

    select hf.* from buyingitem_feature bf inner join

    house_feature hf on bf.feature_id = hf.feature_id

    where bf.buyingItem_id=@prmBuyItemID

    and bf/hg.listing_id = @listingID

    END

    Greg
    _________________________________________________________________________________________________
    The glass is at one half capacity: nothing more, nothing less.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply