|
|
|
|
|
| | |
| |
Active Server Pages asp source code database MS SQL MS Access .mdb adovbs.inc cookies calendar codes sql commands scripts asp programming tutorials iis web server components 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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
