home *** CD-ROM | disk | FTP | other *** search
/ PC World 2003 February / PCWorld_2003-02_cd.bin / Komunik / sambar / sambar53b3.exe / sysadmin / isql / sql.stm < prev   
Encoding:
Text File  |  2002-11-11  |  2.4 KB  |  68 lines
  1. <html>
  2. <head>
  3. <TITLE>Interactive SQL</TITLE>
  4. <meta http-equiv="Pragma" content="no-cache">
  5. <style type="text/css">
  6. body {margin:0pt 0pt 0pt 0pt;}
  7. </style>
  8. </head>
  9. <BODY bgcolor=#ffffff onLoad="document.sqlForm.sql.focus();" scroll='no' >
  10. <SCRIPT language="JavaScript">
  11. function savewindow() {
  12.     window.open('show.stm','savesql','toolbar=0,location=0,directories=0,status=1,menubar=0,scrollbars=1,resizable=1,left=0,top=0,screenX=10,screenY=0,width=800,height=200,dependent=no')
  13. }
  14.  
  15. function Form_Validator(theForm,towhere)
  16. {
  17.     if (theForm.sql.value == "")
  18.     {
  19.         alert("Please enter a value for the \"SQL\" field.");
  20.         theForm.sql.focus();
  21.     }
  22.     else
  23.         {
  24.             if (towhere == 'n')
  25.                 {
  26.                 var wname = Math.random() * 1000;
  27.                 wname = Math.floor(wname);
  28.                 document.sqlForm.target=wname;
  29.                 }
  30.             document.sqlForm.submit();
  31.         }
  32. }
  33.  
  34. </SCRIPT>
  35. <A TARGET=_top HREF="/sysadmin/index.stm">
  36. <IMG border=0 ALIGN=left SRC="/sysimage/system/console.gif" alt='Return to Sambar admin page'></A>
  37. <CENTER>
  38. <FONT style="font-family:arial; font-size:16pt; font-weight:bold; color:#800000">Interactive SQL</FONT>
  39. <FORM METHOD=POST ACTION="/sysadmin/isql/data.stm" NAME="sqlForm" TARGET=data>
  40. <TABLE border=0 cellpadding=0 cellspacing=4>
  41.     <TR>
  42.         <TD><font style="font-family:arial; font-size:10pt; font-weight:bold; color:#000080;">ODBC:</FONT></td>
  43.         <td rowspan=6 align=center><TEXTAREA NAME="sql" ROWS=8 COLS=60 wrap=virtual></TEXTAREA></td>
  44.         <TD rowspan=2><a href='javascript:Form_Validator(document.sqlForm,"d")'><img src='/sysimage/system/go.gif' border=0 alt='Execute SQL query'></a></td>
  45.     </tr>
  46.     <TR>
  47.         <TD align=right><SELECT NAME="dbcache"><RCXdbcachelist></SELECT></td>
  48.     </tr>
  49.     <TR>
  50.         <TD><font style="font-family:arial; font-size:9pt; color:#000080;">User:</FONT></td>
  51.         <TD rowspan=2><a href='javascript:Form_Validator(document.sqlForm,"n")'><img src='/sysimage/system/blank.gif' border=0 alt='Execute query Into New Page'></a></td>
  52.     </tr>
  53.     <TR>
  54.         <TD align=right><INPUT TYPE=text NAME=user SIZE=12></td>
  55.     </tr>
  56.     <TR>
  57.         <TD><font style="font-family:arial; font-size:9pt; color:#000080;">Pass:</FONT></td>
  58.     </tr>
  59.     <TR>
  60.         <TD align=right><INPUT TYPE=password NAME=pass SIZE=12></td>
  61.         <TD><a href='javascript:savewindow()'><img src='/sysimage/icons/page.gif' border=0 alt='Open page to save SQL query'></a></td>
  62.     </tr>
  63. </TABLE>
  64. </FORM>
  65. </CENTER>
  66. </BODY>
  67. </HTML>
  68.