CodingForums.com - View Single Post

keithboesker · 10-17-2012, 11:04 PM

This is an array and it is a very useful way to get checkboxes info from your users an put it one database column.

Update statement

Code:

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

checkboxes are all name NMGroups with value of 1,2,3,4 etc

I just need the array of numbers to update to one table called NMGroups in my database. Right now it works in my insert statement but when I us the update statement it only grabs the first number in the array. How do I grad all numbers like 1,2,3,4 and save it.

10-17-2012, 11:04 PM	PM User \| #3
keithboesker New Coder Join Date: Dec 2011 Posts: 20 Thanks: 0 Thanked 0 Times in 0 Posts	This is an array and it is a very useful way to get checkboxes info from your users an put it one database column. Update statement Code: NMGroups = Request.Form("NMGroups") strSQL = "UPDATE NewsletterMembers set NMGroups = '" & NMGroups & "' WHERE NMID =" & NMID checkboxes are all name NMGroups with value of 1,2,3,4 etc I just need the array of numbers to update to one table called NMGroups in my database. Right now it works in my insert statement but when I us the update statement it only grabs the first number in the array. How do I grad all numbers like 1,2,3,4 and save it.