Problem with SELECT Query in ASP+

[uknutz]

I am having a problem bringing back a recordset from SQL Server 2000 using ASP+. I am able to insert into the database but when I try to select from the DB, the results I receive in my recordset are listed as "System.__ComObject" If anyone knows how to fix this error, please let me know. Below is some of my code:<BR><BR><BR>&#039***********Doesn&#039t Work*********************<BR>&#039* Database Connection<BR>conCalendar = server.createobject("adodb.connection")<BR>conCalendar.open("dsnCalendar","alpha","atfam")<BR> <BR>&#039* Stores records in Recordset object from SQL query<BR>dim rsEvents<BR>dim stEvents as string<BR>stEvents = "SELECT Event, iMonth, iDay, iYear FROM Events;"<BR>rsEvents = server.createobject("adodb.recordset")<BR>rsEvents = conCalendar.execute(stEvents)<BR>&#039**********Everything in rsEvents returns "System.__ComObject" <BR><BR><BR>&#039***************Works fine***************<BR>dim stSQL, stEvent as string<BR>dim iMonth, iDay, iYear as integer<BR>stEvent = txtAppointment.text<BR>iMonth = objCalendar.SelectedDate.Month<BR>iDay = objCalendar.SelectedDate.Day<BR>iYear = objCalendar.SelectedDate.Year<BR>stSQL = "INSERT INTO Events(Event, iMonth, iDay, iYear) " & _<BR>"VALUES(&#039" & stEvent & "&#039," & iMonth & "," & _<BR>iDay & "," & iYear & ");"<BR>conCalendar.execute(stSQL)<BR>conCalendar = nothing<BR>txtAppointment.text=""<BR><BR>Any help is appreciated. Thanks.Just a stab in the dark without testing, but change this:<BR><BR>stEvents = "SELECT Event, iMonth, iDay, iYear FROM Events;" <BR><BR>To this:<BR><BR>stEvents = "SELECT Event, iMonth, iDay, iYear FROM Events"<BR><BR>The ";" on the end may be causing the SELECT to fail.<BR><BR>Doug Seven