I'm gettina goofy error and I can't figure out why. If anyone has an
idea I'd be hapy to hear it.
Here is the error (Error Type: Microsoft VBScript runtime (0x800A01A8))
Here's the code
<[EMAIL PROTECTED]"VBSCRIPT"%>
<!--#include file="Connections/researchdb.asp" -->
<table width="75%" border="1">
<tr>
<td>
<p><%=(Recordset1.Fields.Item("Last").Value)%>,
<%=(Recordset1.Fields.Item("First").Value)%></p>
<p><%=(Recordset1.Fields.Item("Program").Value)%></p>
<p><%=(Recordset1.Fields.Item("RI").Value)%></p>
<p><%=(Recordset1.Fields.Item("RO").Value)%></p>
</td>
</tr>
</table>
<%
Dim Recordset1__MMColParam
Recordset1__MMColParam = "1"
If (Request.QueryString("program") <> "") Then
Recordset1__MMColParam = Request.QueryString("program")
End If
%>
<%
Dim Recordset1
Dim Recordset1_numRows
Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_researchdb_STRING
Recordset1.Source = "SELECT * FROM Research WHERE RI = '" +
Replace(Recordset1__MMColParam, "'", "''") + "' ORDER BY Last ASC"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()
Recordset1_numRows = 0
%>
<%
Recordset1.Close()
Set Recordset1 = Nothing
%>
------------------------ Yahoo! Groups Sponsor --------------------~-->
Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/saFolB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/