Results 1 to 4 of 4
Thread: Separating a subquery
Mar 14, 2005, 04:48 #1
- Join Date
- Feb 2005
- 0 Post(s)
- 0 Thread(s)
Separating a subquery
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)