Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_databases thread: update table from checkbox


Message #1 by mr_mcdo@y... on Wed, 3 Jul 2002 15:15:28
Hi
here the case, im doing a insert with the answer from the checkbox, no 
probleme, but went i doing a update into another table, there no change in 
the table, there no message error, nothing.

Anybody .....

///////////////////////////////////////////////////////////////////////
	SelectionArray = Split(request("choix"),",")

	SelectionUBound = UBound(SelectionArray)
	Redim tab (SelectionUBound)
	for i = 0 to SelectionUBound
		tab(i) = SelectionArray(i)
	Next

	for i = 0 to SelectionUBound

			sql = "INSERT INTO tbl_Passerel1 (RefOrdi,RefLogi) 
VALUES ('" & session("NoOrdi") & "','" & tab(i) & "')"
		    objConn.execute sql
			response.write tab(i)
			sql = "UPDATE tbl_Logiciel SET Utiliser = Utiliser 
+ 1 WHERE Logiciel = '" & tab(i) & "'"
			objConn.execute sql

	next

////////////////////////////////////////////////////////////////////////

Mario

  Return to Index