Look at it from the database's point of view? What would be causing to not like your query?
9/10* times I've seen this error. it's because you've got a stray single quote outside your cfqueryparam tag. * 7/10 stats made up on the spot. Mike Kear wrote: > I'm getting an error message during an insert when I use > CFQUERYPARAM, that goes away if i remove all the CFQUERYPARAMs. > The exact message is: > > [quote] > [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near '@P5'. > [/quote] > > Since there's no '@P5' in the insert query anywhere, I'm assuming it > means something like parameter 5 is that right? so it's telling me > that the 5th field in the insert is wrong (or somewhere close to it). > > If so I'm puzzled because there doesnt appear to be anything wrong > with parameter 5, or the parameters either side or the ones either > side of that. > > Can anyone tell me what the @P5 is really telling me? > > (this is a big insert with about 40 fields being inserted and tracking > down which field is giving the problem is proving problematic) > -- Haikal Saadh Applications Programmer ICT Resources, TALSS QUT Kelvin Grove --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
