kenneyW00
08-20-2008, 01:04 AM
Hi
I am trying to insert into a access database information from an array. the array is veriable in length (it depends on the number entered in the form).
Here is the execution loop I am using
for i = 0 to totalTickets
rTicketNum(i)=t_id*1000+i
Connection.execute(sSQL2)
next
Where t_id is a random unique number and totalTickets is a number chosen by the user.
I am trying to insert into a access database information from an array. the array is veriable in length (it depends on the number entered in the form).
Here is the execution loop I am using
for i = 0 to totalTickets
rTicketNum(i)=t_id*1000+i
Connection.execute(sSQL2)
next
Where t_id is a random unique number and totalTickets is a number chosen by the user.