View Single Post
  #30 (permalink)  
Old June 10th, 2004, 09:17 AM
morpheus morpheus is offline
Friend of Wrox
 
Join Date: Aug 2003
Location: Halifax, Nova Scotia, Canada.
Posts: 166
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I added the loop like this

    If Len("NewsletterId") > 0 And LoopCounter > 0 Then
          NewsletterId = NewsletterId & ", "
    End If
    NewsletterId = NewsletterId & RS("NewsletterId")

But now it returns this vaule

Update ORNewsletterTest set Mailsent=1 where NewsletterId in (12345)

[EDIT]I used this instead

NewsletterId = Right(NewsletterId, (Len(NewsletterId) -2))

and it works great [EDIT]

-----------------------------------------------------------
"Don't follow someone who's not going anywhere" John Mason
Reply With Quote