Thanks Mike! That did it.
On Thu, 3 Feb 2005 16:23:18 -0500, Michael T. Tangorre <[EMAIL PROTECTED]> wrote: > > From: Greg Luce [mailto:[EMAIL PROTECTED] > > > CREATE PROCEDURE [SearchCases] > > @Search varchar( 20), > > @ReferralType varchar(5), > > @CaseType int, > > @NumberType varchar(4) > > You cfprocparam tags use CHAR for the SQL Type. Switch it to VARCHAR.. maybe > your values are getting truncated. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192990 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54