Bahar Jalali

Bahar Jalali

  • NA
  • 185
  • 304.9k

error in update command

May 31 2012 5:13 PM
hi
i have a source code that check some email address and deactive emails that are invalid.
it's my update command

Dim com As New SqlCommand("Update Newsletter_Emails Set Active='False' Where (Email IN (" & Error_Email & "))", con)

also i have tested some option like ... Where (Email IN " & Error_Email & ")", con) 
and ... Where Email IN '" & Error_Email & "'", con) 

but any way it has some error :
Unclosed quotation mark after the character string ''))'.
Incorrect syntax near ''))'.

any suggestion?
thanks in advance

Answers (9)