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 <rcol...@cox.net> 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:338945 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm