Forums
This topic is locked
Update query trouble
Posted 17 Nov 2005 06:37:07
1
has voted
17 Nov 2005 06:37:07 Enrique Ogalde posted:
Hi expert. Sorry for my poor english. I try to explain my trouble with a query.I want update Access DB with two campos (fields?): cant and nomb
The first is a numeric, an the other is text
iCount = Request("Count"
For iLoop = 0 to iCount
strCanti = Request(iLoop & ".Canti"
strID = Request(iLoop & ".ID"
strSQL = "UPDATE t_fot SET cant= ///some code/// WHERE nomb=" & strID
But I don't know how write code where put ///somecode....
Can help me please? Thanks in advance and sorry again for my really bad english.
From Argentina, Enrique
This code is for a site firefighter (I do!) www.bomberostrelew.com.ar/pag/galer.asp
Replies
Replied 21 Nov 2005 05:09:44
21 Nov 2005 05:09:44 Louis L replied:
strSQL = "UPDATE t_fot SET cant= '" & strCanti & "' WHERE nomb=" & strID