something like
for I = 0 to ubound(arrPlacementTypeID)
INSERT INTO tblPlacementLookup (PlacementTypeID, CompanyID,
LocationID,PracticeAreaID) VALUES
(arrPlacementTypeID(I),'2',arrLocationID(I),arrPracticeAreaID(I))
next
?!?
regards
remie bolte
----- Original Message -----
From: "Sam Thompson" <[EMAIL PROTECTED]>
To: "ActiveServerPages" <[EMAIL PROTECTED]>
Sent: Tuesday, November 05, 2002 12:44 PM
Subject: arrays
> Guys,
>
> Ive got these 3 arrays and I need to loop thru them all at once (or
combine
> them?) and insert the current values into a database, then move to the
next
> set of values and do the same again etc etc.
>
> This is what i have so far:
>
> arrPlacementTypeID = Split(PlacementTypeID, ", ")
> arrLocationID = Split(LocationID, ", ")
> arrPracticeAreaID = Split(PracticeAreaID, ", ")
>
> ...this is the output of the above:
>
> arrPlacementTypeID: 1231111111
> arrLocationID: 1111111111
> arrPracticeAreaID: 3445222222
>
> ..this is what i want to end up with:
>
> INSERT INTO tblPlacementLookup (PlacementTypeID, CompanyID, LocationID,
> PracticeAreaID) VALUES (1,2,1,2)
>
> ..I want to create and execute the above INSERT then move to the next set
of
> numbers in the array and do the same again.
>
> Any ideas?!
>
> Thanks
>
> Sam
>
>
> ---
> You are currently subscribed to activeserverpages as: [EMAIL PROTECTED]
> To unsubscribe send a blank email to
%%email.unsub%%
---
You are currently subscribed to activeserverpages as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
