RETURNING THE MAX ID FROM A TABLE IN WEB PAGE 1

[pyttviper]

THE PAGE IS ASP AND USES A CONNECTIONLESS DSN (INCLUDE.FILE)


Set rsNew=Cn.Execute ("SELECT MAX(loco_data.ID) AS Max FROM loco_data&quot


<td width=&quot;50%&quot;><strong><%=rsNew(&quot;Max&quot%></strong></td>

THE FIELD ON THE PAGE IS BLANK BUT THE OTHER FILEDS WORK FINE

 

[tlbroadbent]

Perhaps SQL balks because your alias (Max) is a reserved word. Change &quot;AS Max&quot; to &quot;AS Max1&quot; and make the corresponding change in your ASP page. Let us know if that works. Terry

X-) &quot;Life would be easier if I had the source code.&quot; -Anonymous

 

[pyttviper]

it was so obvious that i didn't see it but you are right
the problem was the the statements originally were hitting an access database but now i am moving it to SQL server and rewriting all of the statements. thanks for the help.