Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

need help on debugging technique

Status
Not open for further replies.

leadman

Programmer
Joined
Jun 11, 2001
Messages
177
Location
US
I'm trying to zero in on where errors are being thown. Sometimes the error page gives the precise document position but often the problem is in an included template and hard to find. This is one of those times :) . The error page is as follows:

========BEGIN SAMPLE ERROR PAGE=========
ODBC Error Code = 07001 (Wrong number of parameters)

[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

Hint: The cause of this error is usually that your query contains a reference to a field which does not exist. You should verify that the fields included in your query exist and that you have specified their names correctly.

The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (99:6) to (99:70).
========END SAMPLE ERROR PAGE=========


The actual page the query is on is included and the document position reference seems meaningless here. Furthermore, there are many cfquery elements on the included template. Is there a way to better zero in on where the problem is?
 
If you open the included file, there is no <CFQUERY> tag around line 99? - tleish
 
ah yes :) - well.. didnt see that.....
okay i found the cause - it was that one of the fields was defined as a number when it should have been text - not exactly what the error message said
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top