Alex, Thanks for your response. It's still not working. when I use year_Offered = @Year_Offered than it works fine... weird thing is even if I am not passing 2004-2005 some how error still says Syntax error converting the varchar value '2004-2005' to a column of data type int. first row it is trying pull is 2004-2005 but I don't see why that would be problem. I used exact statement you had below and still do not work. Getting same error... Any other ideas? Let me know.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how to get a fax number that sends and receives faxes using your current email address http://www.houseoffusion.com/banners/view.cfm?bannerid=64 Message: http://www.houseoffusion.com/lists.cfm/link=i:6:2221 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/6 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
