|
|
|
|
|
| | |
| |
Active Server Pages asp search engine active server page asp application components tutorial CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Problem with Array and DB |
|
From: |
Aaaron |
|
Date: |
6/25/2001 1:32:29 PM |
|
IP: |
64.208.230.101 |
I am attempting to retrive records from a db where the where clause is stored in a array. I can retrive the first record but then it bomb on the second row. Can any one help? Here is the page with the erroe displayed:
http://www.serviceevaluations.com/schedule/results.asp
Here is my asp page:
<!--#include file="ServiceEval2.inc" -->
<!--#include file="../PCase.inc"-->
<% myString = "6271, 62770, 6269/"
MyArray = Split(MyString, ",")
%>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div align="center">
<p><font face="Comic Sans MS">Results of Notification ID <%= request.form("NotificationID") %> </font></p>
<table width="650" border="1" cellspacing="0" cellpadding="1">
<tr bgcolor="#CCCCCC">
<td>
<div align="center"><font face="Comic Sans MS">Evaluator ID</font></div>
</td>
<td>
<div align="center"><font face="Comic Sans MS">Evlauator Last Name</font></div>
</td>
<td>
<div align="center"><font face="Comic Sans MS">Evlauator Email </font></div>
</td>
</tr><%
For intCounter = 0 to 3
set rsItem2 = Server.CreateObject("ADODB.Recordset")
sql2 = "SELECT * FROM TBL_Evalu |
Follow Up - Re: Problem with Array and DB - David Beal 7/2/2001 4:29:50 PM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
