RAGAZZI DOVE CAZ#*?!?!? sta l'errore MANNAGGIA:
<%
orderid= "108"
Set Conn = Server.CreateObject("ADODB.Connection")
Set Mostra = Server.CreateObject("ADODB.Recordset")
SQL33 = "SELECT * FROM orderitems WHERE orderid=" & orderid
Conn.Open "tabac"
Mostra.Open SQL33, conn,3,3
Set anagart = Server.CreateObject("ADODB.Recordset")
anagrafica_articolo = "SELECT products.name, products.codart, products.description, orderitems.productid, orderitems.qty AS quantita, orderitems.priceperunit AS prezzocadauno FROM orders INNER JOIN (orderitems INNER JOIN products ON orderitems.productid =products.productid) ON orders.orderidcont = orderitems.orderid WHERE (((orders.orderidcont)="& orderid &"))"
anagart.Open anagrafica_articolo,conn,3,3
Set totali = Server.CreateObject("ADODB.Recordset")
tot = "SELECT sum(qty * priceperunit) as totaleassoluto FROM orderitems WHERE orderid="& orderid
totali.Open tot, conn,3,3
Set daticliente = Server.CreateObject("ADODB.Recordset")
cliente = "SELECT * FROM orders WHERE orderidcont="& orderid
daticliente.Open cliente, conn,3,3
%>
<%= totali(totaleassoluto)%>
<%
do while not anagart.EOF
%>
<%
prezzo_unitario = anagart("prezzocadauno")
quantita = anagart("quantita")
anagart.MoveNext
loop
%>
<%
anagart.close
Set anagart = nothing
%>
<%Conn.Close()%>
Rispondi quotando
