File : edittmpnum.asp. ID : 2508
Skin : Default | Sons-of-obsidian | Sunburst | Highlighter | Frame
<%
' ถ้ากำหนด dim connect,sql จะ error : Name redefined 
' เพราะเรียกโปรแกรมภายนอก selecttab.asp แต่โปรแกรมนั้นกำหนด dim ไว้แล้ว
' dim connect, sql 
dim gtmpch, gtmpnum, toconfirm, found
found = 0
gtmpnum = request.form("gtmpnum")
gtmpch = request.form("gtmpch")
toconfirm = request.form("toconfirm")
set connect = server.createobject("ADODB.Connection")
connect.open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" &_
Server.MapPath("\perlphpasp\db\tempdb.mdb"))
if toconfirm = "yes" then
  sql="update tempfile set tmpnum = "& gtmpnum 
  sql=sql & " where tmpch ='" & gtmpch & "'"
  connect.execute(sql)   	  
  connect.close
  set connect = nothing
  response.write("Edit : ok")
else
  sql = "select * from tempfile"
  set rs = connect.execute(sql)
  do while not rs.eof    
    if trim(rs("tmpch")) = gtmpch then   ' trim จะลบช่องว่างทั้งซ้ายและขวา
      found = 1
    end if
    rs.movenext
  loop
  connect.close
  set rs = nothing
  set connect = nothing
  if found = 1 and len(gtmpnum) > 0 then
    response.write("<form action=edittmpnum.asp method=post>")
    response.write("<input type=hidden name=gtmpnum value=" & gtmpnum & ">")
    response.write("<input type=hidden name=gtmpch value='" & gtmpch & "'>")
    response.write("<br>Your request : " & gtmpch & " - " & gtmpnum & "<br>")
    response.write("<input type=hidden name=toconfirm value=yes>")
    response.write("<input type=submit value=Confirm>")
    response.write("</form>")
  else
    response.write("Not found or tmpnum equal 0")
  end if
end if
%><br>
<! ด้านล่างทำงานแบบ ssi (Server Side Includes) แต่บรรทัดนี้เป็น comment ใน html>
<!--#include file=selecttab.asp-->