have the select statement without any parameters to ensure it is correct and returning all rows, then try feeding in fixed values as your parmeters, which you know should return some rows.
once this is working, replace the fixed values with your variables.