Modificare il file:
\Buoni-spesa-OLD\transizioni_view.asp
<!--#include file="include/dbcommon.asp"--> <!--#include file="include/transizioni_variables.asp"--> <!--#include file="libs/smarty.asp"--> <% ' check if logged in if SESSION("UserID")="" or not CheckSecurity(SESSION("_" & strTableName & "_OwnerID"),"Search") then SESSION("MyURL")=request.ServerVariables("SCRIPT_NAME")&"?"&request.ServerVariables("QUERY_STRING") response.Redirect "login.asp?message=expired" response.End end if filename="" message="" 'connect database dbConnection="" db_connect() DoEvent "BeforeProcessView dbConnection" Set rs = server.CreateObject("ADODB.Recordset") Set rsLookup = server.CreateObject("ADODB.Recordset") set keys = CreateObject("Scripting.Dictionary") keys.Add "N_Buono",postvalue("editid1") ' get current values and show edit controls strWhereClause = KeyWhere(keys,"") strSQL=gSQLWhereAdd(strWhereClause) strSQLbak = strSQL DoEvent "BeforeQueryView strSQL,strWhereClause" if strSQLbak = strSQL then strSQL=gSQLWhereAdd(strWhereClause) end if LogInfo(strSQL) rs.Open strSQL,dbConnection,1,2 if not rs.EOF then smarty.Add "show_key1",my_htmlspecialchars(GetData(rs,"N_Buono", "")) keylink="" keylink=keylink & "&key1=" & my_htmlspecialchars(server.urlencode(dbvalue(rs("N_Buono")))) Set fso = CreateObject("Scripting.FileSystemObject") '---------------------------------------------------------------- ' N_Buono - value="" if len(rs("N_Buono"))<>"" then strdata = make_db_value("N_Buono",rs("N_Buono"),"","") LookupSQL="SELECT " LookupSQL=LookupSQL & "[N_Buono]" LookupSQL=LookupSQL & " FROM [buono] WHERE [N_Buono] = " & strdata LogInfo(LookupSQL) rsLookup.Open LookupSQL,dbConnection lookupvalue=rs("N_Buono") if not rsLookup.eof then _ lookupvalue=rsLookup(0) value=ProcessLargeText(GetDataInt(lookupvalue,rs,"N_Buono", ""),"field=N%5FBuono" & keylink,"",MODE_VIEW) rsLookup.Close else value="" end if smarty.Add "show_N_Buono",value '---------------------------------------------------------------- ' importo - Number value="" value = ProcessLargeText(GetData(rs,"importo", "Number"),"","",MODE_VIEW) smarty.Add "show_importo",value '---------------------------------------------------------------- ' data_emissione - Short Date value="" value = ProcessLargeText(GetData(rs,"data_emissione", "Short Date"),"","",MODE_VIEW) smarty.Add "show_data_emissione",value end if templatefile = "transizioni_view.htm" DoEvent "BeforeShowView smarty,templatefile,rs" smarty_display(templatefile) rs.Close %>
[
Íàçàä
]