First of all, there's a lot of ADO/asp here but I hope someone has some insight.I've got a stored procedure that creates 5 temp tables. I need to take the data from these tables and use the ADO SHAPE to format them on an asp page.If I do something like this: ojbConn.OpenDim strShapeSQL strShapeSQL = "SHAPE {SELECT * FROM #temp1}" & _ " APPEND({SELECT * FROM #temp2} AS Class " & _ " RELATE field1 TO field1, " & _ etc... Set objProfessorRS = Server.CreateObject("ADODB.Recordset") objProfessorRS.Open strShapeSQL, objConn...display logic here for all 5 recordsets...ojbConn.CloseWill I be able to reference my temp tables this way since I opened a connection, pulled the data, then closed the connection? Because this is a multiuser app, I have to ensure that everyone gets their own data.If no one knows, I'll try over on 4Guys.Thanks 
referencing temporary tables using ADO SHAPE
Posted - 2001-09-28 : 09:20:22