View Single Post
Old 10-18-2012, 08:42 PM   PM User | #6
Old Pedant
Supreme Master coder!

 
Old Pedant's Avatar
 
Join Date: Feb 2009
Posts: 23,556
Thanks: 62
Thanked 4,056 Times in 4,025 Posts
Old Pedant is a name known to allOld Pedant is a name known to allOld Pedant is a name known to allOld Pedant is a name known to allOld Pedant is a name known to allOld Pedant is a name known to all
Quote:
NMGroups is a number field
If that is true, then it can only hold one number. So that would mean your INSERT should not work, either.

It must be a text field of some kind or it could never hold more than one number.

*********

DEBUG DEBUG DEBUG

Code:
...
NMGroups = Request.Form("NMGroups")
strSQL = "UPDATE NewsletterMembers set NMGroups = '" & NMGroups & "' WHERE NMID =" & NMID

Response.Write "<hr/>DEBUG SQL: " & strSQL & "<hr/>" & vbNewLine

...
If you put in the debug code shown there and run the page, what does the debug output to the screen?
__________________
An optimist sees the glass as half full.
A pessimist sees the glass as half empty.
A realist drinks it no matter how much there is.
Old Pedant is offline   Reply With Quote