MS Access Error Messages

[sevex]

I'm getting the following error when I open my template:

ODBC Error Code = 07001 (Wrong number of parameters)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 6.

This doesn't tell me a whole lot... is there any way to get ColdFusion to display more informative MS Access error messages?

 

[calista]

I don't know if you can get any better error messages, but post the code that is generating the error, and I'm sure someone here can help you. Calista :-X
Jedi Knight,
Champion of the Force

 

[sevex]

well, the code is quite long... so no one here is gonna wanna look through it for the same reason I don't wanna look through it. and as it's probably gonna end up being me putting the wrong fieldname somewhere, no one but me would have much of a chance of catching it.

 

[sevex]

argh! I found my mistakes, all very stupid mistakes. Thanks anyway.

 

[calista]

Join the crowd! Don't be too hard on yourself. We all that those Doh! moments. Calista :-X
Jedi Knight,
Champion of the Force

 

[sevex]

oh don't worry, i'm getting used to it. better to find your stupid mistakes than NOT find em... or even worse, have someone else point em out