I'm also using SQL 2005.  I am developing a website with a search feature 
like one used on REMAX.com.  My challenge is getting the search to work.  I 
am trying to pass three variables from dropdown lists: CountryID, StateID, 
and PriceID.  These need to go to the Listings page and query the DB to pull 
the matching records.

I am willing to share my code to solve the problem, but I really want to 
figure out how to do it.  I am trying to teach myself all this, but this has 
been a major stumbling block for me.  So I am hoping to find an 
understandable soul who can help hold my hand through this process.  I have 
taught myself .NET to this point and some other SQL items during this 
process, so I can learn.

Thanks so much

Your request is not very clear; can you please indicate exactly what it is 
that you would like to be shown?

From what you have written, you could be asking with help writing the query 
to return the results, the .NET code to call the query, or even a 
combination of the above plus the necessary code to fill the drop down 
lists.

If you can provide more detail, I am sure we can help.




"u2clone"  wrote in message 
news:E2F32539-72C4-4BBC-9A9E-2D89D69AAFC1@microsoft.com...

> I'm also using SQL 2005.  I am developing a website with a search feature
> like one used on REMAX.com.  My challenge is getting the search to work. 
> I
> am trying to pass three variables from dropdown lists: CountryID, StateID,
> and PriceID.  These need to go to the Listings page and query the DB to 
> pull
> the matching records.
>
> I am willing to share my code to solve the problem, but I really want to
> figure out how to do it.  I am trying to teach myself all this, but this 
> has
> been a major stumbling block for me.  So I am hoping to find an
> understandable soul who can help hold my hand through this process.  I 
> have
> taught myself .NET to this point and some other SQL items during this
> process, so I can learn.
>
> Thanks so much