I've managed to make SELECT work in my application. My preference would have been to use a paramaterized view, but my SQL statement was too long. I am still using views, since my data comes from multiple tables.

Thanks.