Question
Query using an array
Hi, I am attempting to return figures based on a file being
passed to my ASP page, this file is a csv, which I split and enter
the details into an array. This works, I have checked, it is when I
am attempting to query the database using the array I am having
problems, I have shown the code I attempted, but with no joy.
The database connection is working I have tried and tested it.
Any help will be appreciated, thanks.
<%
for i = Lbound(DZArray) to UBound(DZArray)
if DZArray(i) <> "" then '... Error check insure that no vbNull value comes through from the array
Set rsSearch = con.execute("SELECT * FROM MYEPopByNewAgeGroups WHERE MYEPopByNewAgeGroups.DataZone = '" & DZArray(i) & "'")
IF not rs.EOF then '... Error Check insure that a value is returned from the select statement
while not rsSearch.eof
%>
<tr>
<td><%= rsSearch("DataZone")%></td>
<td><%= rsSearch("Under 5")%></td>
<td><%= rsSearch("5-15")%></td>
<td><%= rsSearch("16-24")%></td>
</tr>
<%
rsSearch.movenext
wend
end if
%>
The database connection is working I have tried and tested it.
Any help will be appreciated, thanks.
<%
for i = Lbound(DZArray) to UBound(DZArray)
if DZArray(i) <> "" then '... Error check insure that no vbNull value comes through from the array
Set rsSearch = con.execute("SELECT * FROM MYEPopByNewAgeGroups WHERE MYEPopByNewAgeGroups.DataZone = '" & DZArray(i) & "'")
IF not rs.EOF then '... Error Check insure that a value is returned from the select statement
while not rsSearch.eof
%>
<tr>
<td><%= rsSearch("DataZone")%></td>
<td><%= rsSearch("Under 5")%></td>
<td><%= rsSearch("5-15")%></td>
<td><%= rsSearch("16-24")%></td>
</tr>
<%
rsSearch.movenext
wend
end if
%>
AdChoices