Código:
gracias amigos :D <% Dim cnn, rs, SQL set cnn=Server.CreateObject("ADODB.Connection") set rs=Server.CreateObject("ADODB.Recordset") cnn.open "circulacion", "sa", "" set rs = cnn.execute("SELECT * FROM costos_maxirest WHERE turno = 1 & and local = 1") %> <% FInicio = "31/12/2006" dia=DateDiff("d", FInicio ,date()) %> <FORM METHOD="POST" ACTION="cargado.asp"> <% for i = 1 to 31 %> <table width="70%" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td><div align="center" class="Estilo10"><%=((Date() - dia) + i)%></div></td> <td><span class="Estilo10"> <input name="bme<% = i %>" type="text" value="<% response.Write(rs.fields("bme").value) %>"/> </span></td> <td><div align="center" class="Estilo10"> <input name="fecha<% = i %>" type="hidden" value="<%=((Date() - dia) + i)%>" /></td> <td><div align="center" class="Estilo10"> <input name="turno<% = i %>" type="hidden" value="1" /> </div></td> <td><div align="center" class="Estilo10"> <input name="local<% = i %>" type="hidden" value="1" /> </div></td> </tr> </table> <%next%> <INPUT TYPE="hidden" value="<% = i %>" name="cantidad"> <INPUT TYPE="hidden" value="<% = i %>" name="cantidad2"> <INPUT TYPE="hidden" value="<% = i %>" name="cantidad3"> <INPUT TYPE="hidden" value="<% = i %>" name="cantidad4"> <br> <INPUT TYPE="SUBMIT" value="Insertar"> </p> </p> </FORM>