Thanks Adam, So you agree that the error message is telling me it thinks there's a problem with the 5th parameter as far as it can determine it.
(I know that for a database, identifying the exact cause of the problem is an inexact science, but I'm just trying to identify what that error message is saying) Thanks for your suggestion Scott, but since I'm the one submitting the form on an application I've written, I know where the problem's coming from - it's ME! And I know what's being input. Your suggestion would be the one to use if it was users input causing the problem, and for that I'm grateful. I didnt add that little detail earlier, that it was an app under development giving the error. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 9/15/06, Adam Chapman <[EMAIL PROTECTED]> wrote: > > Hi Mike, > > It's a tedious task but I would start by removing the cfqueryparam one > field > At a time and see which one is causing the problem.. its likely going to > be around the 5th input parameter. > > Once you have found the offending parameter, check the cfsqltype of the > cfqueryparam and check the datatype of the value you are trying to > insert. > > I have a feeling it will be a datatype issue. > > Cheers, > Adam > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~----------~----~----~----~------~----~------~--~---
