/beta/reports/reports_top.asp

http://github.com/khaneh/Orders · ASP · 27 lines · 18 code · 3 blank · 6 comment · 2 complexity · 8a6b16554407829d982815b0469c689e MD5 · raw file 

    

  1. <%
    2. 

  2. if (session("ID")="") then

    3. 

  3. 	session.abandon

    4. 

  4. 	response.redirect "../login.asp"
    5. 

  5. end if
    6. 

  6. %>
    7. 

  7. <html>

    8. 

  8. <head>

    9. 

  9. <meta HTTP-EQUIV="Content-Type" CONTENT="text/html;charset=utf-8">

    10. 

  10. <title><%=reportTitle%></title>

    11. 

  11. </head>

    12. 

  12. <body>

    13. 

  13. <%

    14. 

  14. if Request.QueryString("act")="show" then

    15. 

  15. 

    16. 

  16. '	conStr="DRIVER={SQL Server};SERVER=(local);DATABASE=sefareshat;UID=sefadmin; PWD=5tgb;"

    17. 

  17. conStr = "Provider=SQLNCLI10.1;Persist Security Info=False;User ID=sefadmin;Initial Catalog=sefareshat;Data Source=(local);PWD=5tgb;"

    18. 

  18. 	Set conn = Server.CreateObject("ADODB.Connection")

    19. 

  19. 	conn.open conStr

    20. 

  20. 

    21. 

  21. '	------------------ 

    22. 

  22. '	-----  

    23. 

  23. '	-----  Create the Query from posted parameters

    24. 

  24. '	-----  

    25. 

  25. '	------------------ 

    26. 

  26. 

    27. 

  27. %>
    28.