View Single Post
  #22 (permalink)  
Old June 9th, 2004, 04:38 PM
Imar's Avatar
Imar Imar is offline
Wrox Author
Points: 72,073, Level: 100
Points: 72,073, Level: 100 Points: 72,073, Level: 100 Points: 72,073, Level: 100
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

Nothing else? No error number?

What happens when you write out the SQL statement? I assume your code looks different from what you posted last time??

update "ORNewsletterTest set Mailsent=1 where NewsletterId In (" & NewsletterId & ")"

This won't work, as this isn't valid string or sql statement. Try fixing it, like this for example:

Dim SQL
SQL = "UPDATE ORNewsletterTest SET Mailsent=1 WHERE NewsletterId IN (" & NewsletterId & ")"
Response.Write(SQL)
Response.End

If you put that code in, what do you get?

Imar

---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Reply With Quote