This was a really good idea, and solved the problem. I validated for an integer, and the error went away. TNX.
On 11/8/2010 7:49 AM, Michael Grant wrote: > The best way would be to validate the data before getting your database > involved. > > > On Mon, Nov 8, 2010 at 10:07 AM, Rick Colman<[email protected]> wrote: > >> What is the best way to gracefully trap this sort of error ... >> >> Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC >> Socket][Microsoft][ODBC Microsoft Access Driver] Too few parameters. >> Expected 1. >> The error occurred on line 3. >> >> TNX for any suggestions. >> >> Rick. >> >> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338947 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
