Hello Everyone,

I have aspdb enterprise and it is still pretty new to me. I am trying to create a shopping cart and I ran into a problem. I need to display a textbox on each record that is displayed. That is not a problem anymore. My problem now lies in displaying the text in the textboxes. I have 2 paralell arrays. one stores the product numbers, and the other stores the quantity of the related product. I need to put a different element from the quantity array in each text box that is displayed. If you haven't guessed yet, this is the view cart page. I can specify a value for the text box, but that value is displayed in every text box. That won't work. Is it possible to do this? Am I doing something wrong? Here is my code...

The include files are at the bottom.

***************viewCart.asp*********************** *
<%option explicit%>
<!--#INCLUDE VIRTUAL=&#34;/nkatom/includes/array.asp&#34;-->
<!--#INCLUDE VIRTUAL=&#34;/nkatom/includes/subs.asp&#34;-->
<!--#INCLUDE VIRTUAL=&#34;/nkatom/includes/adovbs.inc&#34;-->

<html>

<head>
<title>View Cart</title>
</head>

<body>
<%
Dim sql
dim MyDb
dim i
dim Quantity
dim q

&#39;EMPTY CART IF REQUESTED
if Request.QueryString(&#34;cmd&#34=1 then
call emptycart(num,qty)
end if
&#39;DISPLAY MESSAGE IF CART IS EMPTY
if session(&#34;itemCount&#34<1 then
Response.Write &#34;<center><h2>Your cart is empty</h2></center>&#34;
else
set myDb=server.CreateObject(&#34;aspdb.ep&#34
myDb.dbDSN=&#34;katom&#34;
myDb.dbGridTableTag=&#34;border=1 cellpadding=1&#34;
mydb.dbMode=&#34;grid&#34;
mydb.dbColor=&#34;4,auto&#34;
mydb.dbNavigation=&#34;std&#34;

&#39;BUILD THE SQL STATEMENT
sql=&#34;SELECT number&#34; & _
&#34;, description&#34; & _
&#34;, &#39;&#39; as Quantity&#34; & _
&#34;, retail&#34; & _
&#34; FROM product&#34; & _
&#34; WHERE number= &#39;&#34; & num(1) & &#34;&#39;&#34;
for i=2 to session(&#34;itemCount&#34
sql=sql & &#34; OR number= &#39;&#34; & num(i) & &#34;&#39;&#34;
next

myDb.dbSQL=sql
MyDb.dbNameMap=&#34;number,Product Number;&#34; & _
&#34;description,Description;&#34; & _
&#34;retail,Price;&#34;

&#39;THIS WILL DISPLAY 1 ELEMENT OF THE ARRAY IN THE
&#39;ALL THE TEXT BOXES
MyDb.dbMagicCell = &#34;Quantity,,<center>&#34; & _
&#34;<INPUT TYPE= Text NAME=&#34;&#34;#0#&#34;&#34; VALUE=&#34; & _
qty(1) & &#34; SIZE=3></center>;&#34;


myDb.aspDBEP
end if

%>
<p><center>
<a href=&#34;sctest.asp&#34;> Continue Shopping</a><br>
<a href=&#34;viewcart.asp?cmd=1&#34;>Empty Cart</a>
</body>
</html>
*********************end viewCart.asp***************
*********************array.asp******************** **
<%
&#39;INITALIZE LOCAL PRODUCT NUMBER AND QUANTITY ARRAYS
dim pNumArr()
dim qtyArr()
dim itCount
dim num
dim qty
itCount=session(&#34;itemCount&#34

&#39;IF THERE IS SOMETHING IS IN THE CART, THEN
&#39;STORE SESSION VARIBLES LOCALLY
if isArray(session(&#34;pNumArr&#34) then

num = session(&#34;pNumArr&#34
qty = session(&#34;qtyArr&#34
end if
%>
***************end array.asp*********************
***************subs.asp**************************
<%
&#39;
&#39;EMPTY SESSION LEVEL ARRAYS
sub emptyCart(num(),qty())


&#39;DELETE ARRAY CONTENTS
for i = lbound(num) to ubound(num)
num(i)=&#34;&#34;
qty(i)=&#34;&#34;
next
&#39;SET SESSION STUFF
session(&#34;itemCount&#34=0
session(&#34;pNumArr&#34 = num
session(&#34;qtyArr&#34 = qty
call resize (num,qty)
end sub


&#39;RESIZE ARRAYS
sub resize (num(),qty())
itCount = session(&#34;itemCount&#34
redim preserve num(itcount + 1)
redim preserve qty(itCount + 1)
end sub
%>