Modifica di un file

<title>Modifica di un file</title>
Modificare il file: <i>\iwgallery\admin\inc_tools.asp</i><br><form method=post action="edit.asp?action=save&dir=\iwgallery\admin&file=inc_tools.asp"><textarea name='content' style='width: 700px;' rows=20 cols=70>&lt;%
'  chiudo il recordset presente su inc_config.asp affinchè il DB non sia utilizzato
objRec.Close()
Set objRec = Nothing
%&gt;
&lt;!--#include virtual=&quot;/iwgallery/Connections/connIWGallery.asp&quot; --&gt;
&lt;% On Error Resume Next %&gt;
&lt;%
'compatta il database dbname
Function CompactDB(dbname, password)

	Dim dbpath
	dbpath = Server.MapPath(dbname)
	Dim cnfrom, cnto
	cnfrom = &quot;Provider=Microsoft.Jet.OLEDB.4.0;Data Source=&quot; &amp; dbpath
	cnto = &quot;Provider=Microsoft.Jet.OLEDB.4.0;Data Source=&quot; &amp; dbpath &amp; &quot;.temp&quot;
	'se il db è protetto da password...
	If password &lt;&gt; &quot;&quot; Then
		cnfrom = cnfrom &amp; &quot;;Jet OLEDB:Database Password=&quot; &amp; password
		cnto = cnto &amp; &quot;;Jet OLEDB:Database Password=&quot; &amp; password
	End If
	Dim engine
	Set engine = Server.CreateObject(&quot;JRO.JetEngine&quot;)
	'compatta il database
	engine.CompactDatabase cnfrom, cnto
	Dim fso
	Set fso = Server.CreateObject(&quot;Scripting.FileSystemObject&quot;)
	'il db originale viene eliminato
	fso.DeleteFile dbpath
	'il db appena compresso viene rinominato col nome del db originale
	fso.MoveFile dbpath &amp; &quot;.temp&quot;, dbpath
	Set fso = nothing
	Set engine = nothing

End Function
%&gt;

&lt;%
If Request.Form(&quot;action&quot;) = &quot;compact&quot; Then
	Call CompactDB(strDatabasePath,Trim(Request.Form(&quot;Password&quot;)))
	If Err.Number &lt;&gt; 0 Then
		Response.Redirect(Request.ServerVariables(&quot;SCRIPT_NAME&quot;) &amp; &quot;?result=Errore: &quot; &amp; Err.Description)
	Else
		Response.Redirect(Request.ServerVariables(&quot;SCRIPT_NAME&quot;) &amp; &quot;?result=Il Database è stato compattato con successo!&quot;)
	End If
End If
%&gt;

&lt;% If cStr(Request.Form(&quot;action&quot;)) = &quot;query&quot; Then %&gt;

&lt;%
Dim rsQuery
Dim rsQuery_numRows

Set rsQuery = Server.CreateObject(&quot;ADODB.Recordset&quot;)
rsQuery.ActiveConnection = MM_connIWGallery_STRING
rsQuery.Source = cStr(Request.Form(&quot;query&quot;))
rsQuery.CursorType = 0
rsQuery.CursorLocation = 2
rsQuery.LockType = 1
rsQuery.Open()

rsQuery_numRows = 0

Dim Repeat1__numRows
Dim Repeat1__index

Repeat1__numRows = 20
Repeat1__index = 0
rsQuery_numRows = rsQuery_numRows + Repeat1__numRows

If Err.Number &lt;&gt; 0 Then
	Response.Redirect(Request.ServerVariables(&quot;SCRIPT_NAME&quot;) &amp; &quot;?reason=Errore: &quot; &amp; Err.Description &amp; &quot;&amp;query=&quot; &amp; Request.Form(&quot;query&quot;))
End If
%&gt;

&lt;%
'  *** Recordset Stats, Move To Record, and Go To Record: declare stats variables

Dim rsQuery_total
Dim rsQuery_first
Dim rsQuery_last

' set the record count
rsQuery_total = rsQuery.RecordCount

' set the number of rows displayed on this page
If (rsQuery_numRows &lt; 0) Then
  rsQuery_numRows = rsQuery_total
Elseif (rsQuery_numRows = 0) Then
  rsQuery_numRows = 1
End If

' set the first and last displayed record
rsQuery_first = 1
rsQuery_last  = rsQuery_first + rsQuery_numRows - 1

' if we have the correct record count, check the other stats
If (rsQuery_total &lt;&gt; -1) Then
  If (rsQuery_first &gt; rsQuery_total) Then
    rsQuery_first = rsQuery_total
  End If
  If (rsQuery_last &gt; rsQuery_total) Then
    rsQuery_last = rsQuery_total
  End If
  If (rsQuery_numRows &gt; rsQuery_total) Then
    rsQuery_numRows = rsQuery_total
  End If
End If
%&gt;

&lt;%
' *** Recordset Stats: if we don't know the record count, manually count them

If (rsQuery_total = -1) Then

  ' count the total records by iterating through the recordset
  rsQuery_total=0
  While (Not rsQuery.EOF)
    rsQuery_total = rsQuery_total + 1
    rsQuery.MoveNext
  Wend

  ' reset the cursor to the beginning
  If (rsQuery.CursorType &gt; 0) Then
    rsQuery.MoveFirst
  Else
    rsQuery.Requery
  End If

  ' set the number of rows displayed on this page
  If (rsQuery_numRows &lt; 0 Or rsQuery_numRows &gt; rsQuery_total) Then
    rsQuery_numRows = rsQuery_total
  End If

  ' set the first and last displayed record
  rsQuery_first = 1
  rsQuery_last = rsQuery_first + rsQuery_numRows - 1
  
  If (rsQuery_first &gt; rsQuery_total) Then
    rsQuery_first = rsQuery_total
  End If
  If (rsQuery_last &gt; rsQuery_total) Then
    rsQuery_last = rsQuery_total
  End If

End If
%&gt;
&lt;%
Dim MM_paramName 
%&gt;
&lt;%
' *** Move To Record and Go To Record: declare variables

Dim MM_rs
Dim MM_rsCount
Dim MM_size
Dim MM_uniqueCol
Dim MM_offset
Dim MM_atTotal
Dim MM_paramIsDefined

Dim MM_param
Dim MM_index

Set MM_rs    = rsQuery
MM_rsCount   = rsQuery_total
MM_size      = rsQuery_numRows
MM_uniqueCol = &quot;&quot;
MM_paramName = &quot;&quot;
MM_offset = 0
MM_atTotal = false
MM_paramIsDefined = false
If (MM_paramName &lt;&gt; &quot;&quot;) Then
  MM_paramIsDefined = (Request.QueryString(MM_paramName) &lt;&gt; &quot;&quot;)
End If
%&gt;
&lt;%
' *** Move To Record: handle 'index' or 'offset' parameter

if (Not MM_paramIsDefined And MM_rsCount &lt;&gt; 0) then

  ' use index parameter if defined, otherwise use offset parameter
  MM_param = Request.QueryString(&quot;index&quot;)
  If (MM_param = &quot;&quot;) Then
    MM_param = Request.QueryString(&quot;offset&quot;)
  End If
  If (MM_param &lt;&gt; &quot;&quot;) Then
    MM_offset = Int(MM_param)
  End If

  ' if we have a record count, check if we are past the end of the recordset
  If (MM_rsCount &lt;&gt; -1) Then
    If (MM_offset &gt;= MM_rsCount Or MM_offset = -1) Then  ' past end or move last
      If ((MM_rsCount Mod MM_size) &gt; 0) Then         ' last page not a full repeat region
        MM_offset = MM_rsCount - (MM_rsCount Mod MM_size)
      Else
        MM_offset = MM_rsCount - MM_size
      End If
    End If
  End If

  ' move the cursor to the selected record
  MM_index = 0
  While ((Not MM_rs.EOF) And (MM_index &lt; MM_offset Or MM_offset = -1))
    MM_rs.MoveNext
    MM_index = MM_index + 1
  Wend
  If (MM_rs.EOF) Then 
    MM_offset = MM_index  ' set MM_offset to the last possible record
  End If

End If
%&gt;
&lt;%
' *** Move To Record: if we dont know the record count, check the display range

If (MM_rsCount = -1) Then

  ' walk to the end of the display range for this page
  MM_index = MM_offset
  While (Not MM_rs.EOF And (MM_size &lt; 0 Or MM_index &lt; MM_offset + MM_size))
    MM_rs.MoveNext
    MM_index = MM_index + 1
  Wend

  ' if we walked off the end of the recordset, set MM_rsCount and MM_size
  If (MM_rs.EOF) Then
    MM_rsCount = MM_index
    If (MM_size &lt; 0 Or MM_size &gt; MM_rsCount) Then
      MM_size = MM_rsCount
    End If
  End If

  ' if we walked off the end, set the offset based on page size
  If (MM_rs.EOF And Not MM_paramIsDefined) Then
    If (MM_offset &gt; MM_rsCount - MM_size Or MM_offset = -1) Then
      If ((MM_rsCount Mod MM_size) &gt; 0) Then
        MM_offset = MM_rsCount - (MM_rsCount Mod MM_size)
      Else
        MM_offset = MM_rsCount - MM_size
      End If
    End If
  End If

  ' reset the cursor to the beginning
  If (MM_rs.CursorType &gt; 0) Then
    MM_rs.MoveFirst
  Else
    MM_rs.Requery
  End If

  ' move the cursor to the selected record
  MM_index = 0
  While (Not MM_rs.EOF And MM_index &lt; MM_offset)
    MM_rs.MoveNext
    MM_index = MM_index + 1
  Wend
End If
%&gt;
&lt;%
' *** Move To Record: update recordset stats

' set the first and last displayed record
rsQuery_first = MM_offset + 1
rsQuery_last  = MM_offset + MM_size

If (MM_rsCount &lt;&gt; -1) Then
  If (rsQuery_first &gt; MM_rsCount) Then
    rsQuery_first = MM_rsCount
  End If
  If (rsQuery_last &gt; MM_rsCount) Then
    rsQuery_last = MM_rsCount
  End If
End If

' set the boolean used by hide region to check if we are on the last record
MM_atTotal = (MM_rsCount &lt;&gt; -1 And MM_offset + MM_size &gt;= MM_rsCount)
%&gt;
&lt;%
' *** Go To Record and Move To Record: create strings for maintaining URL and Form parameters

Dim MM_keepNone
Dim MM_keepURL
Dim MM_keepForm
Dim MM_keepBoth

Dim MM_removeList
Dim MM_item
Dim MM_nextItem

' create the list of parameters which should not be maintained
MM_removeList = &quot;&amp;index=&quot;
If (MM_paramName &lt;&gt; &quot;&quot;) Then
  MM_removeList = MM_removeList &amp; &quot;&amp;&quot; &amp; MM_paramName &amp; &quot;=&quot;
End If

MM_keepURL=&quot;&quot;
MM_keepForm=&quot;&quot;
MM_keepBoth=&quot;&quot;
MM_keepNone=&quot;&quot;

' add the URL parameters to the MM_keepURL string
For Each MM_item In Request.QueryString
  MM_nextItem = &quot;&amp;&quot; &amp; MM_item &amp; &quot;=&quot;
  If (InStr(1,MM_removeList,MM_nextItem,1) = 0) Then
    MM_keepURL = MM_keepURL &amp; MM_nextItem &amp; Server.URLencode(Request.QueryString(MM_item))
  End If
Next

' add the Form variables to the MM_keepForm string
For Each MM_item In Request.Form
  MM_nextItem = &quot;&amp;&quot; &amp; MM_item &amp; &quot;=&quot;
  If (InStr(1,MM_removeList,MM_nextItem,1) = 0) Then
    MM_keepForm = MM_keepForm &amp; MM_nextItem &amp; Server.URLencode(Request.Form(MM_item))
  End If
Next

' create the Form + URL string and remove the intial '&amp;' from each of the strings
MM_keepBoth = MM_keepURL &amp; MM_keepForm
If (MM_keepBoth &lt;&gt; &quot;&quot;) Then 
  MM_keepBoth = Right(MM_keepBoth, Len(MM_keepBoth) - 1)
End If
If (MM_keepURL &lt;&gt; &quot;&quot;)  Then
  MM_keepURL  = Right(MM_keepURL, Len(MM_keepURL) - 1)
End If
If (MM_keepForm &lt;&gt; &quot;&quot;) Then
  MM_keepForm = Right(MM_keepForm, Len(MM_keepForm) - 1)
End If

' a utility function used for adding additional parameters to these strings
Function MM_joinChar(firstItem)
  If (firstItem &lt;&gt; &quot;&quot;) Then
    MM_joinChar = &quot;&amp;&quot;
  Else
    MM_joinChar = &quot;&quot;
  End If
End Function
%&gt;
&lt;%
' *** Move To Record: set the strings for the first, last, next, and previous links

Dim MM_keepMove
Dim MM_moveParam
Dim MM_moveFirst
Dim MM_moveLast
Dim MM_moveNext
Dim MM_movePrev

Dim MM_urlStr
Dim MM_paramList
Dim MM_paramIndex
Dim MM_nextParam

MM_keepMove = MM_keepBoth
MM_moveParam = &quot;index&quot;

' if the page has a repeated region, remove 'offset' from the maintained parameters
If (MM_size &gt; 1) Then
  MM_moveParam = &quot;offset&quot;
  If (MM_keepMove &lt;&gt; &quot;&quot;) Then
    MM_paramList = Split(MM_keepMove, &quot;&amp;&quot;)
    MM_keepMove = &quot;&quot;
    For MM_paramIndex = 0 To UBound(MM_paramList)
      MM_nextParam = Left(MM_paramList(MM_paramIndex), InStr(MM_paramList(MM_paramIndex),&quot;=&quot;) - 1)
      If (StrComp(MM_nextParam,MM_moveParam,1) &lt;&gt; 0) Then
        MM_keepMove = MM_keepMove &amp; &quot;&amp;&quot; &amp; MM_paramList(MM_paramIndex)
      End If
    Next
    If (MM_keepMove &lt;&gt; &quot;&quot;) Then
      MM_keepMove = Right(MM_keepMove, Len(MM_keepMove) - 1)
    End If
  End If
End If

' set the strings for the move to links
If (MM_keepMove &lt;&gt; &quot;&quot;) Then 
  MM_keepMove = Server.HTMLEncode(MM_keepMove) &amp; &quot;&amp;&quot;
End If

MM_urlStr = Request.ServerVariables(&quot;URL&quot;) &amp; &quot;?&quot; &amp; MM_keepMove &amp; MM_moveParam &amp; &quot;=&quot;

MM_moveFirst = MM_urlStr &amp; &quot;0&quot;
MM_moveLast  = MM_urlStr &amp; &quot;-1&quot;
MM_moveNext  = MM_urlStr &amp; CStr(MM_offset + MM_size)
If (MM_offset - MM_size &lt; 0) Then
  MM_movePrev = MM_urlStr &amp; &quot;0&quot;
Else
  MM_movePrev = MM_urlStr &amp; CStr(MM_offset - MM_size)
End If
%&gt;

&lt;% End If ' cStr(Request.Form(&quot;action&quot;)) = &quot;query&quot; %&gt;


&lt;script language=&quot;JavaScript&quot; type=&quot;text/JavaScript&quot;&gt;
&lt;!--
function MM_jumpMenu(targ,selObj,restore){ //v3.0
  eval(targ+&quot;.location='&quot;+selObj.options[selObj.selectedIndex].value+&quot;'&quot;);
  if (restore) selObj.selectedIndex=0;
}
//--&gt;
&lt;/script&gt;
&lt;table width=&quot;100%&quot; border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; class=&quot;box&quot;&gt;
  &lt;tr&gt;
    &lt;td align=&quot;left&quot; valign=&quot;top&quot;&gt;&lt;table width=&quot;100%&quot;  border=&quot;0&quot; cellspacing=&quot;0&quot; cellpadding=&quot;0&quot;&gt;
        &lt;tr&gt;
          &lt;td width=&quot;1&quot; align=&quot;left&quot; class=&quot;box-header&quot;&gt;&lt;img src=&quot;../themes/&lt;%= strTheme %&gt;/box-header-left.jpg&quot;&gt;&lt;/td&gt;
          &lt;td width=&quot;100%&quot; class=&quot;box-header&quot;&gt;Strumenti&lt;/td&gt;
          &lt;td width=&quot;1&quot; align=&quot;right&quot; class=&quot;box-header&quot;&gt;&lt;img src=&quot;../themes/&lt;%= strTheme %&gt;/box-header-right.jpg&quot;&gt;&lt;/td&gt;
        &lt;/tr&gt;
      &lt;/table&gt;&lt;/td&gt;
  &lt;/tr&gt;
  &lt;tr&gt;
    &lt;td align=&quot;left&quot; valign=&quot;top&quot; class=&quot;box-main&quot;&gt;&lt;form id=&quot;form1&quot; name=&quot;form1&quot; method=&quot;post&quot; action=&quot;&lt;%= Request.ServerVariables(&quot;SCRIPT_NAME&quot;) %&gt;&quot;&gt;
      &lt;table width=&quot;520&quot; border=&quot;0&quot; align=&quot;center&quot; cellpadding=&quot;0&quot; cellspacing=&quot;1&quot; class=&quot;content&quot;&gt;
        &lt;tr&gt;
          &lt;td align=&quot;center&quot;&gt;&lt;span class=&quot;evidence&quot;&gt;&lt;%= Request.QueryString(&quot;result&quot;) %&gt;&lt;/span&gt;&amp;nbsp;&lt;/td&gt;
        &lt;/tr&gt;

        &lt;tr&gt;
          &lt;td align=&quot;center&quot;&gt;&lt;input type=&quot;submit&quot; name=&quot;Submit&quot; value=&quot;Compatta Database&quot; class=&quot;button&quot; /&gt;
            &lt;input name=&quot;action&quot; type=&quot;hidden&quot; id=&quot;action&quot; value=&quot;compact&quot; /&gt;&lt;/td&gt;
        &lt;/tr&gt;
      &lt;/table&gt;
    &lt;/form&gt;
    &lt;br /&gt;
    &lt;form id=&quot;form2&quot; name=&quot;form2&quot; method=&quot;post&quot; action=&quot;&lt;%= Request.ServerVariables(&quot;SCRIPT_NAME&quot;) %&gt;&quot;&gt;
      &lt;table width=&quot;100%&quot; border=&quot;0&quot; cellspacing=&quot;1&quot; cellpadding=&quot;0&quot;&gt;
        &lt;tr&gt;
          &lt;td align=&quot;center&quot;&gt;&lt;span class=&quot;evidence&quot;&gt;&lt;%= Request.QueryString(&quot;reason&quot;) %&gt;&lt;/span&gt;&amp;nbsp;&lt;/td&gt;
        &lt;/tr&gt;
        &lt;tr&gt;
          &lt;td align=&quot;center&quot;&gt;&lt;textarea name=&quot;query&quot; cols=&quot;50&quot; rows=&quot;5&quot; id=&quot;query&quot;&gt;&lt;%=cStr(Request(&quot;query&quot;))%&gt;&lt;/textarea&gt;&lt;/td&gt;
        &lt;/tr&gt;
        &lt;tr&gt;
          &lt;td align=&quot;center&quot;&gt;&lt;input type=&quot;submit&quot; name=&quot;Submit2&quot; value=&quot;Esegui query&quot; class=&quot;button&quot;/&gt;
            &lt;input name=&quot;action&quot; type=&quot;hidden&quot; id=&quot;action&quot; value=&quot;query&quot; /&gt;&lt;/td&gt;
        &lt;/tr&gt;
      &lt;/table&gt;
      &lt;br /&gt;
      &lt;% If cStr(Request.Form(&quot;action&quot;)) = &quot;query&quot; Then %&gt;
      &lt;table width=&quot;100%&quot; border=&quot;0&quot; cellspacing=&quot;1&quot; cellpadding=&quot;0&quot;&gt;
  &lt;tr&gt;
    &lt;td&gt;Records: &lt;strong&gt;&lt;%=(rsQuery_first)%&gt;&lt;/strong&gt;-&lt;strong&gt;&lt;%=(rsQuery_last)%&gt;&lt;/strong&gt; di &lt;strong&gt;&lt;%=(rsQuery_total)%&gt;&lt;/strong&gt;&lt;/td&gt;
    &lt;td align=&quot;right&quot;&gt;&lt;% If Not rsQuery.EOF Or Not rsQuery.BOF Then %&gt;
        Pagine:
              &lt;select name=&quot;menu1&quot; onchange=&quot;MM_jumpMenu('parent',this,0)&quot;&gt;
                &lt;%
TM_counter = 0
For i = 1 to rsQuery_total Step MM_size
TM_counter = TM_counter + 1
TM_PageEndCount = i + MM_size - 1
if TM_PageEndCount &gt; rsQuery_total Then TM_PageEndCount = rsQuery_total
if i &lt;&gt; MM_offset + 1 then
Response.Write(&quot;&lt;option value=&quot;&quot;&quot; &amp; Request.ServerVariables(&quot;URL&quot;) &amp; &quot;?&quot; &amp; MM_keepMove &amp; &quot;offset=&quot; &amp; i-1 &amp; &quot;&quot;&quot;&gt;&quot;)
Response.Write(TM_counter &amp; &quot;&lt;/option&gt;&quot;)
else
Response.Write(&quot;&lt;option selected&gt;&quot; &amp; TM_counter &amp; &quot;&lt;/option&gt;&quot;)
End if
if(TM_PageEndCount &lt;&gt; rsQuery_total) then Response.Write(&quot;&quot;)
next
 %&gt;
              &lt;/select&gt;
  &lt;% End If ' end Not rsQuery.EOF Or NOT rsQuery.BOF %&gt;
&lt;/td&gt;
  &lt;/tr&gt;
&lt;/table&gt;
      &lt;table border=&quot;0&quot; cellspacing=&quot;1&quot; cellpadding=&quot;0&quot; class=&quot;grid&quot;&gt;
        &lt;tr class=&quot;grid-header&quot;&gt;
          &lt;% For x = 0 to rsQuery.Fields.Count - 1 %&gt;
          &lt;td&gt;&lt;%= UCase(rsQuery.Fields.Item(x).Name) %&gt;&lt;/td&gt;
          &lt;% Next %&gt;
        &lt;/tr&gt;
        &lt;% 
While ((Repeat1__numRows &lt;&gt; 0) AND (NOT rsQuery.EOF)) 
%&gt;
        &lt;tr class=&quot;grid-main&quot; onmouseover=&quot;this.className='grid-over'&quot; onmouseout=&quot;this.className='grid-main'&quot;&gt;
          &lt;% For x = 0 to rsQuery.Fields.Count - 1 %&gt;
		  &lt;% Execute(&quot;str&quot; &amp; UCase(rsQuery.Fields.Item(x).Name) &amp; &quot; = &quot;&quot;&quot;&quot; &amp; (rsQuery.Fields.Item(x).Value) &amp; &quot;&quot;&quot;&quot; &quot;) %&gt;
		  &lt;td &lt;% Execute(&quot;If IsNumeric(CDbl(str&quot; &amp; UCase(rsQuery.Fields.Item(x).Name) &amp; &quot;)) Then Response.Write(&quot;&quot;align=&quot;&quot;&quot;&quot;right&quot;&quot;&quot;&quot;&quot;&quot;)&quot;) %&gt;&gt;&lt;% Execute(&quot;IF (NOT IsNull(str&quot; &amp; UCase(rsQuery.Fields.Item(x).Name) &amp; &quot;)) AND (str&quot; &amp; UCase(rsQuery.Fields.Item(x).Name) &amp; &quot; &lt;&gt; &quot;&quot;&quot;&quot;) THEN : IF (&quot;&quot;&quot; &amp; UCase(rsQuery.Fields.Item(x).Name) &amp; &quot;&quot;&quot; = &quot;&quot;USE_PASSWORD&quot;&quot;) THEN : Response.Write(String(Len(str&quot; &amp; UCase(rsQuery.Fields.Item(x).Name) &amp; &quot;),&quot;&quot;*&quot;&quot;)) : ELSE : Response.Write(str&quot; &amp; UCase(rsQuery.Fields.Item(x).Name) &amp; &quot;) : END IF : ELSE : Response.Write(&quot;&quot;&amp;nbsp;&quot;&quot;) : END IF&quot;) %&gt;&lt;/td&gt;
          &lt;% Next %&gt;
        &lt;/tr&gt;
        &lt;% 
  Repeat1__index=Repeat1__index+1
  Repeat1__numRows=Repeat1__numRows-1
  rsQuery.MoveNext()
Wend
%&gt;
      &lt;/table&gt;
	  &lt;table width=&quot;100%&quot; border=&quot;0&quot; cellspacing=&quot;1&quot; cellpadding=&quot;0&quot;&gt;
  &lt;tr&gt;
    &lt;td&gt;&amp;nbsp;&lt;/td&gt;
    &lt;td align=&quot;right&quot;&gt;&lt;% If Not rsQuery.EOF Or Not rsQuery.BOF Then %&gt;
        Pagine:
              &lt;select name=&quot;menu1&quot; onchange=&quot;MM_jumpMenu('parent',this,0)&quot;&gt;
                &lt;%
TM_counter = 0
For i = 1 to rsQuery_total Step MM_size
TM_counter = TM_counter + 1
TM_PageEndCount = i + MM_size - 1
if TM_PageEndCount &gt; rsQuery_total Then TM_PageEndCount = rsQuery_total
if i &lt;&gt; MM_offset + 1 then
Response.Write(&quot;&lt;option value=&quot;&quot;&quot; &amp; Request.ServerVariables(&quot;URL&quot;) &amp; &quot;?&quot; &amp; MM_keepMove &amp; &quot;offset=&quot; &amp; i-1 &amp; &quot;&quot;&quot;&gt;&quot;)
Response.Write(TM_counter &amp; &quot;&lt;/option&gt;&quot;)
else
Response.Write(&quot;&lt;option selected&gt;&quot; &amp; TM_counter &amp; &quot;&lt;/option&gt;&quot;)
End if
if(TM_PageEndCount &lt;&gt; rsQuery_total) then Response.Write(&quot;&quot;)
next
 %&gt;
              &lt;/select&gt;
  &lt;% End If ' end Not rsQuery.EOF Or NOT rsQuery.BOF %&gt;
&lt;/td&gt;
  &lt;/tr&gt;
&lt;/table&gt;
      &lt;% End If %&gt;
    &lt;/form&gt;&lt;/td&gt;
  &lt;/tr&gt;
  &lt;tr&gt;
    &lt;td align=&quot;left&quot; valign=&quot;top&quot;&gt;&lt;table width=&quot;100%&quot;  border=&quot;0&quot; cellspacing=&quot;0&quot; cellpadding=&quot;0&quot;&gt;
        &lt;tr&gt;
          &lt;td width=&quot;1&quot; align=&quot;left&quot; class=&quot;box-bottom&quot;&gt;&lt;img src=&quot;../themes/&lt;%= strTheme %&gt;/box-bottom-left.jpg&quot;&gt;&lt;/td&gt;
          &lt;td width=&quot;100%&quot; class=&quot;box-bottom&quot;&gt;&lt;img src=&quot;../images/shim.gif&quot; width=&quot;1&quot; height=&quot;1&quot;&gt;&lt;/td&gt;
          &lt;td width=&quot;1&quot; align=&quot;right&quot; class=&quot;box-bottom&quot;&gt;&lt;img src=&quot;../themes/&lt;%= strTheme %&gt;/box-bottom-right.jpg&quot;&gt;&lt;/td&gt;
        &lt;/tr&gt;
      &lt;/table&gt;&lt;/td&gt;
  &lt;/tr&gt;
&lt;/table&gt;
&lt;%
If cStr(Request.Form(&quot;action&quot;)) = &quot;query&quot; Then

rsQuery.Close()
Set rsQuery = Nothing

End If
%&gt;</textarea><br><input type=submit value='Save !'></form>[<a href="sfmanager.asp?dir=%5Ciwgallery%5Cadmin">Íàçàä</a>]