SQL = "SELECT * FROM T1News where ..."
SQL_Rs.open SQL,SQL_Cn,3
IF NOT(SQL_Rs.EOF) THEN
arrResultsx = SQL_Rs.getrows
ctrx = ubound(arrResultsx,2)
END IF
SQL_Rs.close
ctrx2=0
SQL = "SELECT * FROM T1News where ..."
SQL_Rs.open SQL,SQL_Cn,3
IF NOT(SQL_Rs.EOF) THEN
arrResultsx2 = SQL_Rs.getrows
ctrx2 = ubound(arrResultsx2,2)
END IF
SQL_Rs.close
ctrx = ctrx + 1
' ctr = ctrx+ctrx2
' ReDim arrResultsx(ctr)
' %><%=arrResultsx(x,ctr)%><Br><%
if ctrx2 > 0 then ' if anything in 2nd array, then proceed
for i = 0 to ctrx2
for x = 0 to 30
' redim preserve arrResultsx(x,ctrx)
arrResultsx(x,ctrx) = arrResultsx2(x,i) ' also tried arrResultsx(ctrx)=arrResultsx2(i)
ctrx = ctrx + 1
next
next
end if
ASKER
Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.
TRUSTED BY