Splitting String and inserting into database 1

[craigward]

Hi,

I have passed a string of uniqueid's from a database into a variable (contactids) this could be 1 id or hundreds. i also have a variable called (mailerid), there will only ever be one of these. i need to break the (contactid) string down into individual values, and insert them into the database each with a copy of the (mailerid). I can insert data fine if it was 1 contactid and one mailerid i would be fine... when there are an unknown quantity of contactids i am lost..... Any help would be appreciated.

Thanks

Table to insert data

wce_Mailer_Link - this is my link table to the contacts and mailers they have been sent.

contactid (varchar(25))
mailerid (varchar(25))

 

[PHV]

Have a look at the Split and UBound functions.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[craigward]

Thanks for that. An array and for loop sorted it out.

Thanks again.