Cita:
aki va el codigo completoScript error detected at line 35.
Source line: Response.Write trim(rs("itemm"))
Source line: Response.Write trim(rs("itemm"))
<%
dim cantidad,total,sSQL,rs,conn,obra,itemm
cantidad = request.Form("cantidad")
total = request.Form("total")
obra = request.Form("obra")
itemm = request.Form("itemm")
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "xxxxxx"
sSQL="SELECT itemm,obra,sum(cantidad) as cantidad1,SUM(total) as total1 FROM fichaobra where obra = '" & obra & "' GROUP BY itemm,obra order by itemm,obra"
set rs = conn.execute(sSQL)
%>
<table border="0"align="center">
<tr>
<tr>
<td colspan="6" width="100%" align="center" class="head2">MATERIALES POR OBRA</td>
</tr>
<td width="100%" align="center" class="head2"><B>Producto</B></td>
<td width="100%" align="center" class="head2"><B>Obra</B></td>
<td width="100%" align="center" class="head2"><B>Cantidad</B></td>
<td width="100%" align="center" class="head2"><B>Total</B></td>
</tr>
<tr>
aki es donde me tira el mensaje de error
<td align="center" class="head4"><%=trim(rs("itemm"))%></td>
<td align="center" class="head4"><%=TRIM(rs("obra"))%></td>
<td align="center" class="head4"><%=TRIM(rs.fields("cantidad1"))%></td>
<td align="center" class="head4"><%=TRIM(rs.fields("total1"))%></td>
</tr>
<%
RS.Close
Set RS = Nothing
Conn.Close
Set Conn = Nothing
%>