Using MAX function

[kathyf]

We are trying to Select the highest number from our line number field using the MAX function. The syntax we are using is the following:


SELECT MAX(lineno) FROM faq


Here is the error message we keep getting:

ADODB.Fields error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.

/_ScriptLibrary/Recordset.ASP, line 1202

All suggestions welcome.

 

[palbano]

Dear kathyf,

I strongly suggest you take your SQL statement:

> SELECT MAX(lineno) FROM faq

And execute it in your database environment to see what the problem is.

"But, that's just my opinion... I could be wrong".
-pete