Multi-Value Query

I have a search form that takes 5 inputs from textboxes or Drop Down Lists.





I built a query that works just fine in Analyizer, but the second i try to turn it into a sproc that takes parameters I can only get it to work with one parameter so far....





Here is the query that works just fine





Select ftr_location.loc_name, ftr_file.loc_id, ftr_file.file_date, ftr_file.file_type_id, ftr_file.acct_no,


ftr_file.cust_fname, ftr_file.cust_lname, ftr_status.status_name, ftr_file.destruction_date





FROM dbo.ftr_file





Inner Join ftr_location On ftr_location.loc_id = ftr_file.loc_id


Inner Join ftr_Status On ftr_status.status_id = ftr_file.status_id


Inner Join ftr_doc_types on ftr_doc_types.file_type_id = ftr_file.file_type_id





WHERE ftr_file.Loc_id = 18 and ftr_file.file_date= '12/4/2004'





GO








The sproc version that I cant get to work is:








CREATE PROCEDURE dbo.usp_ftr_searchfile_s





(


@ResultLocation int = null,


@ResultFileDate datetime = null


)





AS





DECLARE @SQLString VARCHAR(4000)





SET @SQLString = 'Select ftr_location.loc_name, ftr_file.loc_id, ftr_file.file_date, ftr_file.file_type_id, ftr_file.acct_no,'+


'ftr_file.cust_fname, ftr_file.cust_lname, ftr_status.status_name, ftr_file.destruction_date' +





' FROM dbo.ftr_file' +





' Inner Join ftr_location On ftr_location.loc_id = ftr_file.loc_id' +


' Inner Join ftr_Status On ftr_status.status_id = ftr_file.status_id' +


' Inner Join ftr_doc_types on ftr_doc_types.file_type_id = ftr_file.file_type_id' +


' WHERE 1=1 '





If @ResultLocation Is Not Null


Set @SQLString = @SQLString + 'And ftr_file.loc_id=' + cast @ResultLocation


If @ResultLocation Is Not Null


Set @SQLString = @SQLString + 'And ftr_file.file_date=' + cast @ResultFileDate








EXEC (@SQLString)


GO








Any feedback would be most helpful, as I can get it to work with one parameter but not when I add teh second in the mix.