Hi, good morning

Im doing the Multiple Update/Delete of Records tuturial find in here DMXzone, i need a bit of help, i did some alterations in the code to make is possible to work to me, and im not being capable to make the Update command work without error. The problem is, the tuturial updates a number field and other that is a text field so the Update from the tuturial is:

For iLoop = 0 to iCount
strLink = Request(iLoop & ".Link"
strID = Request(iLoop & ".ID"
strSQL = "UPDATE dbo.YourTable SET sCatName = '" & strLink & "'" &_
" WHERE SCAT = " & strID

in this code above, sCatName is a text and Scat is a number variable, in my page the sCatName (now called Estoque) is a number variable and im not being able to make the alterations in the code to make it runs ok

My Update code :

For iLoop = 0 to iCount
strLink = Request.Form("qtidade"
strID = Request(iLoop & ".ID"
strSQL = "UPDATE Estoque SET Estoque =<font color=red> '" & strLink & "'" </font id=red>&_
" WHERE ProductDetailID = " & strID

What alterations need to be made to the code works??

See the error message:

Microsoft OLE DB Provider for ODBC Drivers error '80040e07'

[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.

/updatestock.asp, line 27


Tx
Fábio