Rob, I think I remember what caused me to have this error. Try removing the variable attribute of the cfprocparam tags. If the variable names do not explicitely match the variables defined in your stored proc, CF will throw an error.
Variable names were depriciated in CFMX and were basically ignored. However, in the latest CF7 update they added them back in and it created all kinds of problems for my older code. Dean On 6/17/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Thanks Neil, > > It certainly is very odd, I have no idea what its doing, like you say with > that explicite string definition it should be fine. > > I've sent a mail to my SQL guy to see whether he has any suggestions as to > what might be causing the issue. > > Thanks mate, > > Rob > -- __________________________________________ Dean Lawrence, CIO/Partner Internet Data Technology 888.GET.IDT1 ext. 701 * fax: 888.438.4381 http://www.idatatech.com/ Corporate Internet Development and Marketing Specialists ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281443 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
