Dam, its so obvious now!!! Thanks Remie!
Sam :) ----- Original Message ----- From: "Remie Bolte" <[EMAIL PROTECTED]> To: "ActiveServerPages" <[EMAIL PROTECTED]> Sent: Tuesday, November 05, 2002 11:56 AM Subject: Re: arrays > 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.unsub%% > --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
