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 PROTECTED]

Reply via email to