Problem with INSERT and UPDATE

[chassid]

All,

I am trying to UPDATE and INSERT a table but this is the message that I keep getting:

Microsoft VBScript compilation error '800a0401'

Expected end of statement

/newact/members/diract/getpassword.asp, line 82

UPDATE members SET email = '" & strEmail & "' WHERE
---------------^
member_id = '" & strID & "'

I get the strID by doing this code after my select statement:
strID = objRS.Fields("member_id&quot

Any help will be greatly appreciated!
Daniel Do you know the Chabad Lubavitch Sheliach in your area?
He is waiting for you!

 

[lobstah]

Is member_id numeric?

If so, then it should be:

member_id = " & strID

Or, are you sure that there is a value in strID?

Try writing it out before doing the update - ie:

Response.Write &quot;<br>strID = &quot; & strID & &quot;<br>&quot;