Forums

ASP

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

Reply to this topic