There is no limit but the input params must be sent in the exact order they are set in storedprocedure. In other words the naming of the cfprocparam does not coincide with the naming within the sp.
- Ron -----Original Message----- From: Scott Brady [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 05, 2002 12:45 PM To: CF-Talk Subject: Re: SQL Server SPs and cfprocparam Actually, the problem seems to lie somewhere else. I provided simplified code before. In my SP call in CF, I have 3 input cfprocparams. If I take any of the cfprocparams out, the code runs ok. There's not a limit to the number of input params, is there? Scott ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists