codice:
<TITLE>FLOWER ver 1.0</TITLE>
<STYLE></STYLE><html>
<link href="styles.css" rel="stylesheet" type="text/css">
<STYLE type=text/css>DIV.menuLinks {
BORDER-RIGHT: #cccccc 1px solid; PADDING-RIGHT: 3px; BORDER-TOP: #cccccc 1px solid; PADDING-LEFT: 3px; FONT-SIZE: 11px; BACKGROUND: #eeeeee; PADDING-BOTTOM: 3px; BORDER-LEFT: #cccccc 1px solid; WIDTH: 130px; CURSOR: default; PADDING-TOP: 3px; FONT-FAMILY: Verdana
}
</STYLE>
<SCRIPT language=javascript>
<!--
function MenuTxDx() {
var sx = event.clientX + document.body.scrollLeft;
var tp = event.clientY + document.body.scrollTop;
menu.style.display = '';
pos.style.left = sx;
pos.style.top = tp;
return false;
}
function link(url) {
location.href = url;
}
//-->
</SCRIPT>
<head>
<%
Dim cod
cod=Request.Querystring("cod")
Dim SQL,Rec
SQL="SELECT * FROM caricoart WHERE id="&cod
Set rec = Server.CreateObject("ADODB.Recordset")
Set Rec=Conn.Execute(SQL)
%>
</HEAD>
<center>
<form method="post" action="edit-process.asp?cod=<%=cod%>">
<table border="0" cellpadding="1" width="100%" bgcolor="#000000" cellspacing="1" height="82">
<tr>
<td width="173" height="20" bgcolor="#CCCCCC"> <TABLE id=AutoNumber37 style="BORDER-COLLAPSE: collapse"
borderColor=#111111 height=15 cellSpacing=0 cellPadding=0
width=175 border=0>
<TBODY>
<TR>
<TD width=160 height=15><font size="1" face="Verdana, Arial, Helvetica, sans-serif">OPERAZIONE
DI CARICO</font></TD>
<TD width=15 bgColor=#fb7115 height=15><FONT
face=Verdana, Arial, Helvetica, sans-serif color=#ffffff
size=1>>></FONT></TD>
</TR>
</TBODY>
</TABLE></td>
<td height="20" colspan="5" bgcolor="#CCCCCC"><font size="1" face="Verdana, Arial, Helvetica, sans-serif"></font><font size="1" face="Verdana, Arial, Helvetica, sans-serif"></font><font size="1" face="Verdana, Arial, Helvetica, sans-serif"></font><font size="1" face="Verdana, Arial, Helvetica, sans-serif"></font><font size="1" face="Verdana, Arial, Helvetica, sans-serif"></font></td>
</tr>
<tr>
<td bgcolor="#dedebb"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Data
Documento </font></td>
<td width="100" height="19" bgcolor="#dedebb"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
</font><font size="1" face="Verdana, Arial, Helvetica, sans-serif"></font><font size="1" face="Verdana, Arial, Helvetica, sans-serif"></font><font size="1" face="Verdana, Arial, Helvetica, sans-serif"></font><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<input name="datadocumento" type="text" id="datadocumento" onChange="javascript:this.value=this.value.toUpperCase();" value="<%=rec("datadocumento")%>" size="10" >
</font></td>
<td width="108" bgcolor="#dedebb">N. Documento</td>
<td width="100" bgcolor="#dedebb"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<input name="ndocumento" type="text" id="ndocumento" onChange="javascript:this.value=this.value.toUpperCase();" value="<%=rec("ndocumento")%>" size="10" >
</font></td>
<td width="105" bgcolor="#dedebb"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Tipo
Documento </font></td>
<td width="395" bgcolor="#dedebb"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<input name="tipodocumento" type="text" id="tipodocumento" onChange="javascript:this.value=this.value.toUpperCase();" value="<%=rec("tipodocumento")%>" size="10" >
</font></td>
</tr>
<tr>
<td bgcolor="#dedebb"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Fornitore</font></td>
<td height="19" colspan="5" bgcolor="#dedebb"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<input name="fornitore" type="text" id="fornitore" onChange="javascript:this.value=this.value.toUpperCase();" value="<%=rec("fornitore")%>" size="10" >
</font></td>
</tr>
<tr bgcolor="#CCCCCC">
<td> <TABLE id=AutoNumber37 style="BORDER-COLLAPSE: collapse"
borderColor=#111111 height=15 cellSpacing=0 cellPadding=0
width=175 border=0>
<TBODY>
<TR>
<TD width=160 height=15><font size="1" face="Verdana, Arial, Helvetica, sans-serif">CARICO
ARTICOLI </font></TD>
<TD width=15 bgColor=#fb7115 height=15><FONT
face=Verdana, Arial, Helvetica, sans-serif color=#ffffff
size=1>>></FONT></TD>
</TR>
</TBODY>
</TABLE></td>
<td height="19" colspan="5"></td>
</tr>
</table>
<table border="0" cellpadding="1" width="100%" bgcolor="#000000" cellspacing="1" height="60">
<tr bgcolor="#CCCCCC">
<td width="54" height="20" bgcolor="#CCCCCC">CODICE </td>
<td width="201" bgcolor="#CCCCCC">CATEGORIA</td>
<td width="202" bgcolor="#CCCCCC">MARCA</td>
<td width="54" height="20">MODELLO</td>
<td width="65" height="20" colspan="-1">DESCRIZIONE</td>
<td width="30" height="20" colspan="-1">QTA'</td>
<td width="104">IMPORTO (IVA ESCL)</td>
<td width="134">RIFERIMENTO</td>
<td width="135">NOTE</td>
</tr>
<tr>
<td height="18" nowrap bgcolor="#dedebb"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<input name="cod1" type="text" id="indirizzo2" onChange="javascript:this.value=this.value.toUpperCase();" value="<%=rec("cod1")%>" size="10" >
</font></td>
<td height="18" nowrap bgcolor="#dedebb"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<input name="cat1" type="text" id="cat1" onChange="javascript:this.value=this.value.toUpperCase();" value="<%=rec("cat1")%>" size="10" >
</font></td>
<td height="18" nowrap bgcolor="#dedebb"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<input name="marca1" type="text" id="marca1" onChange="javascript:this.value=this.value.toUpperCase();" value="<%=rec("marca1")%>" size="10" >
</font></td>
<td height="18" nowrap bgcolor="#dedebb"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<input name="modello1" type="text" id="modello1" onChange="javascript:this.value=this.value.toUpperCase();" value="<%=rec("modello1")%>" size="10" >
</font></td>
<td height="18" nowrap bgcolor="#dedebb"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<input name="descr1" type="text" id="descr12" onChange="javascript:this.value=this.value.toUpperCase();" value="<%=rec("descr1")%>" size="20" >
</font></td>
<td height="18" nowrap bgcolor="#dedebb"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<input name="qta1" type="text" id="qta1" onChange="javascript:this.value=this.value.toUpperCase();" value="<%=rec("qta1")%>" size="10" >
</font></td>
<td height="18" nowrap bgcolor="#dedebb"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<input name="importo1" type="text" id="importo1" onChange="javascript:this.value=this.value.toUpperCase();" value="<%=rec("importo1")%>" size="20" >
</font></td>
<td height="18" nowrap bgcolor="#dedebb"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<input name="rif1" type="text" id="telcasa2" onChange="javascript:this.value=this.value.toUpperCase();" value="<%=rec("rif1")%>" size="10" >
</font></td>
<td height="18" nowrap bgcolor="#dedebb"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<input name="note1" type="text" id="telufficio2" onChange="javascript:this.value=this.value.toUpperCase();" value="<%=rec("note1")%>" size="10" >
</font></td>
</tr>
<tr>
<td height="18" colspan="9" bgcolor="#dedebb"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
<input name="Submit2" type="submit" "#" STYLE="cursor: hand" id="Submit2" value="Salva le modifiche apportate">
</font></td>
</tr>
</table>
</form>
</p>
</p>
</center>
<%
Conn.close
%>
<DIV id=pos style="POSITION: absolute; z-index: 999">
<body link="#003366" vlink="#003366" alink="#ff3333" oncontextmenu="return MenuTxDx()" onclick="menu.style.display='None'">
<div align="center">
<DIV id=menu style="DISPLAY: none">
<DIV class=menuLinks
onmouseover="this.style.color='#FFFFFF';this.style.background='#003366'"
onclick="link('elenco.asp')"
onmouseout="this.style.color='#000000';this.style.background='#EEEEEE'">Elenco</DIV>
<DIV class=menuLinks
onmouseover="this.style.color='#FFFFFF';this.style.background='#003366'"
onclick="link('add.asp')"
onmouseout="this.style.color='#000000';this.style.background='#EEEEEE'">Aggiungi</DIV>
<DIV class=menuLinks
onmouseover="this.style.color='#FFFFFF';this.style.background='#003366'"
style="BORDER-BOTTOM: #cccccc 1px solid"
onclick="link('javascript:window.close()')"
onmouseout="this.style.color='#000000';this.style.background='#EEEEEE'">Uscita</DIV>
</DIV>
Edit_process.asp
codice:
<%
cod=request.querystring("cod")
cod = replace(cod, "'", "''")
datadocumento=request.querystring("datadocumento")
datadocumento = replace(datadocumento, "'", "''")
ndocumento=Request.Form("ndocumento")
ndocumento = replace(ndocumento, "'", "''")
tipodocumento=request.form("tipodocumento")
tipodocumento = replace(tipodocumento, "'", "''")
fornitore=request.form("fornitore")
fornitore = replace(fornitore, "'", "''")
cod1=request.form("cod1")
cod1 = replace(cod1, "'", "''")
descr1=request.form("descr1")
descr1 = replace(descr1, "'", "''")
marca1=request.form("marca1")
marca1 = replace(marca1, "'", "''")
cat1=request.form("cat1")
cat1 = replace(cat1, "'", "''")
qta1=request.form("qta1")
qta1 = replace(qta1, "'", "''")
importo1=request.form("importo1")
importo1 = replace(importo1, "'", "''")
rif1=request.form("rif1")
rif1 = replace(rif1, "'", "''")
note1=request.form("note1")
note1 = replace(note1, "'", "''")
modello1=request.form("modello1")
modello1 = replace(modello1, "'", "''")
SQL = "UPDATE caricoart set datadocumento='"&datadocumento&"',ndocumento='"&ndocumento&"',tipodocumento='"&tipodocumento&"',fornitore='"&fornitore&"',cod1='"&cod1&"',descr1='"&descr1&"',marca1='"&marca1&"',cat1='"&cat1&"',qta1='"&qta1&"',importo1='"&importo1&"',rif1='"&rif1&"',note1='"¬e1&"',modello1='"&modello1&"' WHERE id="&cod
Conn.Execute(SQL)
Response.Redirect "EditMessaggio.asp"
%>
<%
Conn.close
%>
Rispondi quotando