Im a newbie and dont know how to separate the below SQLpc string into 2 separate statements.

I have about 5 of these statements in an ASP page for a poll im trying to get working.

Im using MySQL 4.0.18 which apparently doesnt support nested queries. I get a 1064 ERROR.

Can anyone help?

Dim SelMax, ConnPoll, SQLpc, RSpc
Set ConnPoll = Server.CreateObject("ADODB.Connection")
ConnPoll.Open "driver= ###path to my DB###"
SQLpc = "SELECT * FROM pollcount WHERE ID = (SELECT MAX(ID) FROM pollcount)"
Set RSpc = ConnPoll.Execute(SQLpc)