¸¶½ºÅÍÆ÷À¯(Master4U)
Monday, 17 of January
 

Á¦¸ñ: Ŭ¶óÀÌ¾ðÆ®¿Í ¼­¹ö »çÀÌÀÇ °æ°è¸¦ ¾ø¾Ö´Â Remote Scripting
ºÐ·ù: À©µµ¿ì
À̸§: ±èÀÎÈ£ * http://www.master4u.net


µî·ÏÀÏ: 2005-10-12 10:34
Á¶È¸¼ö: 12570 / Ãßõ¼ö: 78
 
Ŭ¶óÀÌ¾ðÆ®¿Í ¼­¹ö »çÀÌÀÇ °æ°è¸¦ ¾ø¾Ö´Â Remote Scripting | WEB 2005/05/19 14:33
http://blog.naver.com/skeehun/140013070219

Jeff Sandquist Àú

Ŭ¶óÀÌ¾ðÆ®¿Í ¼­¹ö »çÀÌÀÇ °æ°è¸¦ ¾ø¾Ö´Â Remote Scripting

À̹ø ´Þ¿¡´Â Microsoft Remote ScriptingÀ» µµÀÔÇÏ¿© Ŭ¶óÀÌ¾ðÆ®¿Í ¼­¹ö »çÀÌÀÇ °æ°è¸¦ ¾ø¾Ù ¿¹Á¤ÀÔ´Ï´Ù. Remote ScriptingÀ» ÀÌ¿ëÇÏ¸é ºê¶ó¿ìÀú°¡ ÆäÀÌÁö Àüü¸¦ ¸®·ÎµåÇÏÁö ¾Ê°íµµ ¼­¹ö¿¡ ÀÖ´Â ½ºÅ©¸³Æ®¸¦ È£ÃâÇÒ ¼ö ÀÖ´Â ¾ÖÇø®ÄÉÀ̼ÇÀ» ¸¸µé ¼ö ÀÖ½À´Ï´Ù. ÀÌ ±â»ç¿¡¼­´Â Remote ScriptingÀ» »ç¿ëÇØ¼­ ¾ÖÇø®ÄÉÀ̼ÇÀ» ¿øÈ°ÇÏ°Ô ¿î¿µÇϰí À¥ »çÀÌÆ®¸¦ º¸´Ù ºü¸£°í dzºÎÇÏ°í ´ëÀÀÀûÀ¸·Î ¸¸µå´Â ¹ýÀ» ¹è¿ï °ÍÀÔ´Ï´Ù.


Microsoft Remote ScriptingÀ» »ç¿ëÇÏ¿© ¼­¹ö¿Í Ŭ¶óÀÌ¾ðÆ® »çÀÌÀÇ °ü°è¸¦ Çâ»ó½ÃŰ½Ê½Ã¿À.

½Ã³ª¸®¿À

´ÙÁß ºê¶ó¿ìÀú ȯ°æÀÇ ¾ÖÇø®ÄÉÀ̼ÇÀ» °³¹ßÇϰí Àִµ¥ ¸ðµç »ç¿øÀÇ À̸§ÀÌ µé¾î ÀÖ´Â Select ¹Ú½º¸¦ ³ªÅ¸³»°í ½Í½À´Ï´Ù.

¿©·¯ºÐÀÇ SQL Server µ¥ÀÌÅͺ£À̽º¿¡ 1¸¸ ¸íÀÇ »ç¿ø À̸§ÀÌ µé¾î ÀÖ´Â Å×À̺íÀÌ ÀÖ½À´Ï´Ù. »ç¿ëÀÚ¸¦ À§Çؼ­ Å×À̺í Àüü¸¦ Select ¹Ú½º¿¡ ·ÎµåÇÏ°Ô µÇ¸é ¼º´É¿¡ Å« ÁöÀåÀÌ ÀÖÀ¸¸ç ÇÊ¿ä ¾ø´Â Á¤º¸¸¦ ´Ù¿î·ÎµåÇÏ´Â µ¿¾È ±â´Ù·Á¾ß ÇÕ´Ï´Ù. ´ë½Å¿¡ óÀ½ 10°³ ±â·Ï¸¸ º¸¿©ÁØ ´ÙÀ½ Ãß°¡ ·¹ÄÚµå´Â »ç¿ëÀÚÀÇ ÀÔ·ÂÀÇ ÄÁÅØ½ºÆ®¿¡ ±âÃÊÇÏ¿© º¸³»°í ½Í½À´Ï´Ù. ±×·¯¹Ç·Î »ç¿ëÀÚ°¡ "S"¸¦ ÀÔ·ÂÇϸé Å×À̺íÀº ±× ¼ºÀÌ "S"·Î ½ÃÀ۵Ǵ »ç¿øÀÇ Ã³À½ 10°³ ±â·ÏÀ» öÀÚ¼øÀ¸·Î ¿­°ÅÇÒ °ÍÀÔ´Ï´Ù. »ç¿ëÀÚÀÇ ºê¶ó¿ìÀú¿¡ ³ªÅ¸³ª´Â Ãâ·ÂÀº ´ÙÀ½°ú °°Àº ¸ð¾çÀÌ µÉ °ÍÀÔ´Ï´Ù.

Select Box

Microsoft Remote Data Service(RDS)¸¦ »ç¿ëÇØ¼­ Å×À̺íÀ» ·ÎµåÇÒ ¼öµµ ÀÖÁö¸¸ ¹®Á¦´Â ¿©·¯ºÐÀÇ ¾ÖÇø®ÄÉÀ̼ÇÀÌ Netscape Navigator 4.x¿Í Internet Explorer 4.x¿Í ¸ðµÎ ÀÛ¾÷ÀÌ ÀÌ·ç¾îÁ®¾ß ÇÑ´Ù´Â Á¡ÀÔ´Ï´Ù. ÃÖ¼±ÀÇ ÇØ°áÃ¥Àº Microsoft Remote ScriptingÀÇ À¶Å뼺À» Ȱ¿ëÇÏ´Â °ÍÀÔ´Ï´Ù.

Remote ScriptingÀ» ÀÌ¿ëÇϸé À¥ ¾ÖÇø®ÄÉÀ̼ǿ¡¼­ µÎ °³ÀÇ ½ºÅ©¸³ÆÃ Ç÷§ÆûÀ» ÇÑ ÆäÀÌÁö·Î °áÇÕÇÒ ¼ö ÀÖ½À´Ï´Ù. ¶ÇÇÑ ¾ÖÇø®ÄÉÀ̼ÇÀÇ »ç¿ëÀÚ ÀÎÅÍÆäÀ̽º¸¦ Á¶ÀýÇϴ Ŭ¶óÀÌ¾ðÆ® ½ºÅ©¸³Æ®¸¦ ¸¸µé ¼ö ÀÖ½À´Ï´Ù. µ¿½Ã¿¡, ¼­¹öÀÇ ½ºÅ©¸³Æ®¸¦ ½ÇÇàÇÏ¿© µ¥ÀÌÅͺ£À̽º Äõ¸®¿Í Áß°£Ãþ ºñÁî´Ï½º ·ÎÁ÷, µî ¼­¹öÃø ÀÛ¾÷À» ¼öÇàÇϵµ·Ï ÇÒ ¼ö ÀÖ½À´Ï´Ù. Ŭ¶óÀÌ¾ðÆ® ÆäÀÌÁö°¡ ¾ÆÁ÷ »ì¾ÆÀÖ´Â µ¿¾È Remote ScriptingÀÌ ¼­¹ö¿¡¼­ ½ÇÇàµÇ±â ¶§¹®¿¡ ¿©·¯ºÐÀÇ ½ºÅ©¸³Æ®´Â Å©°Ô ´Ü¼øÈ­µÇ°í, ¾ÖÇø®ÄÉÀ̼ÇÀº º¸´Ù dzºÎÇÏ°í »ç¿ëÀÚ¿¡°Ô Ä£¼÷ÇÑ ÀÎÅÍÆäÀ̽º¸¦ Á¦°øÇÒ ¼ö ÀÖ½À´Ï´Ù.

¿ä±¸ »çÇ×

¿ì¸®ÀÇ ¾ÖÇø®ÄÉÀ̼ÇÀº µÎ °³ÀÇ ÆÄÀÏ RSClient.htm°ú Server.asp·Î ±¸¼ºµË´Ï´Ù. ±×¸®°í ´ÙÀ½ÀÇ ÆÄÀϵ鵵 ÇÊ¿äÇÒ °ÍÀÔ´Ï´Ù:

    ¡¤ RS.asp, ´Â ¿©·¯ºÐÀÇ .asp ÆÄÀÏ¿¡¼­ È£ÃâµÇ´Â ¸Þ¼­µå°¡ µé¾î ÀÖ´Â °ÍÀ¸·Î¼­ ¼­¹öÃø Remote ScriptingÀ» ÃʱâÈ­ÇÏ°í ¿©·¯ºÐÀÇ ÆäÀÌÁö¿¡ Àû´çÇÑ ÇÔ¼ö·Î º¸³À´Ï´Ù.

    ¡¤ RS.htm, Àº ¿©·¯ºÐÀÇ .htm ÆÄÀÏ¿¡¼­ »ç¿ëÇÏ´Â ¸Þ¼­µå¸¦ Æ÷ÇÔÇÏ´Â °ÍÀ¸·Î¼­ Remote ScriptingÀ» ÃʱâÈ­Çϰí, ¿ø°Ý ÇÁ·Î½ÃÀú¸¦ ½ÇÇàÇϰí, ¿ø°Ý È£ÃâÀÇ »óŸ¦ Á¡°ËÇϰí, ¸Þ¼­µå °á°ú¸¦ ¾ò½À´Ï´Ù.

    ¡¤ Rsproxy.class, ´Â Ŭ¶óÀÌ¾ðÆ®¿Í ¼­¹ö ÆäÀÌÁö »çÀÌ¿¡ Åë½ÅÇÏ´Â ¾ÖÇø´À» À§ÇÑ Java Ŭ·¡½º ÆÄÀÏ(°´Ã¼ ÄÚµå)À» Æ÷ÇÔÇÕ´Ï´Ù.

ÀÌ ÆÄÀϵéÀº Microsoft Remote Scripting ´Ù¿î·ÎµåÀÇ ÀϺÎÀÔ´Ï´Ù. ÀÌ ÆÄÀϵéÀº ¿©·¯ºÐÀÇ ¼­¹ö³ª ÇÁ·ÎÁ§Æ® ÀÇ °¡»ó ·çÆ®ÀÇ ¹Ù·Î ¹Ø¿¡ _ScriptLibrary¶ó´Â Æú´õ¿¡ º¹»çµÇ¾î¾ß ÇÕ´Ï´Ù. Visual Interdev 6.0À» »ç¿ëÇϸé ÀÌ ÆÄÀϵéÀº ÀÚµ¿À¸·Î ¿©·¯ºÐÀÇ ¼­¹ö¿¡ Visual Interdev 6.0 Script LibraryÀÇ ÀϺημ­ º¹»çµË´Ï´Ù.

Internet Information Server(IIS)¿Í Active Server Pages(ASP) ±×¸®°í ActiveX Data Objects(ADO)µµ ÇÊ¿äÇÒ °ÍÀÔ´Ï´Ù. Windows NT 4.0 Option PackNon-MSDN linkÀº ÇÊ¿äÇÑ ÆÄÀϵéÀ» ¸ðµÎ ¼³Ä¡ÇØÁÝ´Ï´Ù.

System DSN ¸¸µé±â

µ¥ÀÌÅ͸¦ ÂüÁ¶ÇÏ´Â ½Ã½ºÅÛ µ¥ÀÌÅÍ ¼Ò½º À̸§(DSN)À» ¸¸µå½Ê½Ã¿À. System DSNÀº DSNÀÌ ¸¸µé¾îÁø ÄÄÇ»ÅÍÀÇ Windows Registry¿¡ µ¥ÀÌÅÍ ¿¬°á¿¡ ´ëÇÑ Á¤º¸¸¦ ÀúÀåÇÕ´Ï´Ù. ¿©·¯ºÐÀÇ ¾ÖÇø®ÄÉÀ̼ÇÀº Microsoft SQL Server Pubs »ùÇà µ¥ÀÌÅͺ£À̽º¿¡ ¿¬°áµË´Ï´Ù. À¥ ¼­¹ö¿¡¼­ Á¦¾îÆÇÀÇ ODBC ¾ÆÀÌÄÜÀ» ´õºíŬ¸¯Çϰí System DSN ÅÇÀ» Ŭ¸¯ÇÏ¿© Pubs µ¥ÀÌÅͺ£À̽º¸¦ °¡¸®Å°´Â "Pubs"¶ó´Â À̸§ÀÇ »õ·Î¿î System DSNÀ» ¸¸µé¾î Ãß°¡ÇϽʽÿÀ.

  1. Á¦¾îÆÇÀ» ¿­°í ODBC¸¦ ´õºíŬ¸¯ÇϽʽÿÀ.
  2. System DSN ÅÇÀ» Ŭ¸¯Çϰí Add¸¦ Ŭ¸¯ÇϽʽÿÀ.
  3. ¼³Ä¡µÈ ODBC µå¶óÀ̹ö ¸ñ·Ï¿¡¼­ SQL Server¸¦ ¼±ÅÃÇϽʽÿÀ. Finish¸¦ Ŭ¸¯ÇϽʽÿÀ.
  4. Á¦°øµÈ ÅØ½ºÆ® ¹Ú½º¿¡ µ¥ÀÌÅÍ ¼Ò½ºÀÇ À̸§°ú ¼­¹ö¸¦ ÀÔ·ÂÇϽʽÿÀ. NameÀ»"Pubs"·Î ¼³Á¤Çϰí Server¸¦ SQL ServerÀÇ À̸§À¸·Î ¼³Á¤ÇϽʽÿÀ. ¼³¸í Ãß°¡´Â ¼±ÅûçÇ×ÀÔ´Ï´Ù. Next¸¦ Ŭ¸¯ÇϽʽÿÀ.
  5. SQL Server Authentication ¿É¼Ç ¹öưÀ» ¼±ÅÃÇϰí Login ID ÅØ½ºÆ® ¹Ú½º¿¡ "sa"¸¦ ÀÔ·ÂÇϽʽÿÀ. ¾ÏÈ£µµ ÁöÁ¤ÇÒ Çʿ䰡 ÀÖ½À´Ï´Ù. Next¸¦ Ŭ¸¯ÇϽʽÿÀ.

       a. ±âº» µ¥ÀÌÅͺ£À̽º üũ ¹Ú½º¸¦ ¼±ÅÃÇϰí, µ¥ÀÌÅͺ£À̽º ¸ñ·Ï¿¡¼­ Pubs¸¦ ãÀ¸½Ê½Ã¿À. Next¿Í Finish¸¦ Ŭ¸¯ÇϽʽÿÀ.

       b. ¸ðµç °ÍÀÌ Àß µÇ¾ú´ÂÁö È®ÀÎÇÏ·Á¸é Test Data Source¸¦ Ŭ¸¯ÇϽʽÿÀ. OK¸¦ Ŭ¸¯ÇÏ¿© ³¡³»½Ê½Ã¿À. ODBC Administrator¸¦ ´ÝÀ¸½Ê½Ã¿À.

Äڵ带 ÀÛ¼ºÇսôÙ!

´ÙÀ½ÀÇ Äڵ带 RSClient.HTMÀ̶ó´Â HTM ÆÄÀÏ¿¡ º¹»çÇϽʽÿÀ. ·Îµå À̺¥Æ®¿¡¼­ <BODY>¿¡ ÀÖ´Â refresh_list ÇÔ¼ö¸¦ È£ÃâÇÕ´Ï´Ù. Ŭ¶óÀÌ¾ðÆ®¿¡¼­ Remote ScriptingÀ» »ç¿ëÇϴµ¥ ÇÊ¿äÇÑ ·çƾÀº Rs.htm ÆÄÀÏ¿¡ µé¾î ÀÖ½À´Ï´Ù. ÀÌ ÆÄÀÏÀº Microsoft JScript include¸¦ »ç¿ëÇÏ¿© Æ÷ÇÔ½Ãŵ´Ï´Ù.

<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
<TITLE>Servin' It Up with Remote Scripting</TITLE>
<BODY onload="refresh_list()">

<SCRIPT Language="JavaScript" src="_ScriptLibrary/rs.htm">
</SCRIPT>

Á¦¸ñ°ú HTML ÆûÀ» µð½ºÇ÷¹ÀÌÇÒ °ÍÀÔ´Ï´Ù. ÆûÀº INPUT ¹Ú½º Çϳª¿Í SELECT ¹Ú½º Çϳª·Î ±¸¼ºµË´Ï´Ù. INPUT ¹Ú½º´Â onkeyup À̺¥Æ®¿¡¼­ ¿ì¸®ÀÇ JScript refresh_list ÇÔ¼ö¸¦ È£ÃâÇÕ´Ï´Ù.

listbox¸¦ À§ÇÑ ±âº» ¿É¼Ç °ªµµ °ø±ÞÇÒ Çʿ䰡 ÀÖ½À´Ï´Ù. À̰ÍÀº Netscape Navigator¿¡ ÇÊ¿äÇÑ °ÍÀ̸ç ÀÌ·¸°Ô ÇÏÁö ¾ÊÀ¸¸é Navigator°¡ ¿ì¸®ÀÇ ¸ñ·Ï ³¡À» Àß¶ó¹ö¸± °ÍÀÔ´Ï´Ù.

<H2>Address Book Sample</H2>

<FORM id=form1 name=form1>
 <INPUT type="text" size="50" id=Myname name=MyName onkeyup=refresh_list()><br>
 <SELECT id=NameList name=NameList size=10>
- One Moment Please ----------------------------------------------------------------------</SELECT>
</FORM>

Microsoft JScript Äڵ带 ÀÌ¿ëÇØ¼­ ¿ì¸®´Â Remote Scripting ¸Þ¼­µå RSEnableRemoteScriptingNon-MSDN linkÀ» È£ÃâÇϰí ÀÌ ÆäÀÌÁö¿¡¼­ Remote ScriptingÀÌ °¡´ÉÇÏ°Ô ÇÕ´Ï´Ù. refresh_list JScript ÇÔ¼öµµ ¸¸µì´Ï´Ù.

<SCRIPT LANGUAGE=javascript>
<!--
 RSEnableRemoteScripting();

function refresh_list() {

µÎ °³ÀÇ º¯¼ö serverURL°ú DisplayLength¸¦ Á¤ÀÇÇÕ´Ï´Ù.

  var serverURL = "server.asp"; /* Filename of our server-side script */
      var DisplayLength = 10   /* Maxinum number of records to return */

Dynamic HTMLÀ» »ç¿ëÇØ¼­ ¿ì¸®ÀÇ SELECT ¹Ú½ºÀÇ ±æÀ̸¦ 0À¸·Î ¼³Á¤ÇÑ ´ÙÀ½ DisplayLength º¯¼öÀÇ °ªÀ¸·Î ¼³Á¤ÇÕ´Ï´Ù.

     
    document.form1.NameList.length = 0
    document.form1.NameList.length = DisplayLength

textboxÀÇ °ªÀ» °Ë»öÇÏ¿© Remote ScriptingÀÇ RSExcuteNon-MSDN link ¸Þ¼­µå¿Í ÇÔ²² ¼­¹öÃø ÇÔ¼ö¿¡ Àü´ÞÇÕ´Ï´Ù.

    var inValue = document.form1.MyName.value;
  var myVar = RSExecute(serverURL, "myFunction", inValue, DisplayLength);

Remote Scripting°¡ »ç¿øÀÇ À̸§°ú ¼ºÀÌ µé¾î ÀÖ´Â JScript °´Ã¼¸¦ ¸®ÅÏÇÕ´Ï´Ù. °¢ ·¹ÄÚµå´Â ÄÝ·ÐÀ¸·Î ±¸ºÐµË´Ï´Ù. Microsoft JScript split method¸¦ ÀÌ¿ëÇØ¼­ ÀÌ Ç׸ñµéÀ» »ìÆìº» ´ÙÀ½ ÇϳªÀÇ ¹è¿­¿¡ ÀúÀåÇÕ´Ï´Ù.

split method

¹è¿­¿¡ ·çÇÁ¸¦ ¸¸µé°í ¸®½ºÆ® ¹Ú½º¸¦ ¹è¿­ ³»¿ëÀ¸·Î ä¿ó´Ï´Ù. ¸¶Áö¸·À¸·Î <SCRIPT>¿Í <HTML> ºí·ÏÀ» ´Ý½À´Ï´Ù.

  var myArray = myVar.return_value.split(":");
  for (i = 0; i < 10; i++)
  {
    var myOpt = new Option
    myOpt.value = myArray[i];
    myOpt.text  = myArray[i];
    if (i < myArray.length) 
    {
      document.form1.NameList.options[i] = myOpt;
    }
  }
  
  document.form1.NameList.options[0].selected = true;
 } 
//-->
</SCRIPT>

</BODY>
</HTML>

ÀÌÁ¦ ¼­¹öÃøÀ¸·Î ³Ñ¾î°©´Ï´Ù(Á¦°¡ ÁÁ¾ÆÇÏ´Â ºÎºÐÀÔ´Ï´Ù). server.asp¶ó´Â Active Server Page¸¦ ¸¸µì´Ï´Ù. ÀÌ ÆäÀÌÁö¿¡´Â ActiveX Data Objects(ADO)¸¦ »ç¿ëÇØ¼­ ¿ì¸®ÀÇ µ¥ÀÌÅͺ£À̽º¸¦ Äõ¸®ÇÏ´Â ¼­¹öÃø JScript ÇÔ¼ö°¡ µé¾î ÀÖ½À´Ï´Ù.

À¸·Î ±×´ë·Î µÎ°í RS.asp ÆÄÀÏÀ» ±âº» ¾ð¾î´Â Microsoft Visual Basic Scripting EditionÆ÷ÇÔ½Ãŵ´Ï´Ù. ÆäÀÌÁöÀÇ ±âº» ¾ð¾î¸¦ JScript·Î ¼³Á¤Çϸé Remote Scripting Æ÷ÇÔ ÆÄÀÏÀº ÇÔ¼ö µÚ¿¡ 󸮵ǰí ÀÌ·¸°Ô µÇ¸é Äڵ忡 ¿Â°® ¿¡·¯°¡ ¹ß»ýÇÕ´Ï´Ù. Active Server PagesÀÇ ½ÇÇà ¼ø¼­¿¡ ´ëÇÏ¿© ÀÚ¼¼ÇÑ »çÇ×Àº "Server Q & A - Why does the order of ASP execution seem to be so random?"À» Âü°íÇϽʽÿÀ.

Remote ScriptingÀÇ RSDispatch ¸Þ¼­µå¸¦ È£ÃâÇØ¼­ Remote ScriptingÀ» ÃʱâÈ­ÇÕ´Ï´Ù. RSDispatch È£ÃâÀº ÇØ´ç ÆäÀÌÁö¿¡¼­ ½ÇÇàµÇ´Â ù¹øÂ° ¼­¹ö ½ºÅ©¸³Æ®À̾î¾ß ÇÕ´Ï´Ù.

<%@ LANGUAGE=VBSCRIPT %>
<!--#include file="_ScriptLibrary/rs.asp"-->
<% RSDispatch %>

public_description °´Ã¼¸¦ ¸¸µé°í Ŭ¶óÀÌ¾ðÆ® ÆäÀÌÁö¿¡ ³ëÃâ½ÃŰ°í ½ÍÀº ¸Þ¼­µå¸¦ ¿­°ÅÇÕ´Ï´Ù.

<SCRIPT Language=JavaScript RUNAT=SERVER>
 function Description()
 { 
  this.myFunction = myFunction;
 }
 public_description = new Description();

ÀÌÁ¦ ÃʱâÈ­°¡ ÀÌ·ç¾îÁö°í JScript public description °´Ã¼°¡ ¸¸µé¾îÁ³À¸¹Ç·Î Ŭ¶óÀÌ¾ðÆ® ½ºÅ©¸³Æ®¿¡¼­ È£ÃâÇÏ´Â ÇÔ¼ö¸¦ ¸¸µé ¼ö ÀÖ½À´Ï´Ù. Server Side JScript¸¦ »ç¿ëÇØ¼­ ÇÔ¼ö¸¦ ÀÛ¼ºÇÒ °ÍÀÔ´Ï´Ù. ¿ì¸®ÀÇ ÇÁ·Î½ÃÀú´Â µÎ °³ÀÇ ¸Å°³º¯¼ö-¿ì¸®°¡ ¸®ÅÏÇϰíÀÚ ÇÏ´Â ¼ö ·¹ÄÚµå(numLength)¿Í ¿ì¸®ÀÇ ºÐ·ù ¸Å°³º¯¼ö(strInput)-¸¦ ÃëÇÕ´Ï´Ù.

    function myFunction(strInput, numLength)
    {

ADODB Connection °´Ã¼¸¦ ÀνºÅϽºÈ­Çϰí, µ¥ÀÌÅͺ£À̽º ¿¬°áÀ» ¿¬ ´ÙÀ½ recordset °´Ã¼¸¦ ÀνºÅϽºÈ­ÇÕ´Ï´Ù. ¿©·¯ºÐÀÇ È¯°æ¿¡ À¯È¿Çϵµ·Ï ¿¬°á ½ºÆ®¸µÀ» ¼öÁ¤ÇÒ Çʿ䰡 ÀÖ´ÂÁö È®ÀÎÇÒ Çʿ䰡 ÀÖ½À´Ï´Ù.

      var objConn = Server.CreateObject("ADODB.Connection");
  objConn.Open("dsn=pubs;uid=sa;pwd=;Network=DBMSSOCN");
      var objRS = Server.CreateObject("ADODB.Recordset");

¿ì¸®ÀÇ Å¬¶óÀÌ¾ðÆ®¿¡°Ô ¸®ÅÏÇÏ°í ½ÍÀº ·¹ÄÚµå ¼ö·Î MaxRecords ÇÁ·ÎÆÛƼ¸¦ ¼³Á¤ÇÕ´Ï´Ù.

      objRS.MaxRecords = numLength;

SQL Select ¹®À» »ç¿ëÇØ¼­ »ç¿øÀÇ À̸§°ú ¼ºÀ» ¸®ÅÏÇÕ´Ï´Ù. À̰ÍÀº textbox¿¡ ÀÔ·ÂµÈ Å°°¡ ¹«¾ùÀ̰ǰ£¿¡ ±× ¹®ÀÚ·Î ½ÃÀ۵Ǵ »ç¶÷ÀÇ À̸§ÀÌ µÇµµ·Ï Çϰí À̰ÍÀ» öÀÚ¼øÀ¸·Î Á¤·ÄÇÕ´Ï´Ù. Transact SQL ´öºÐ¿¡ ÀÌ ÀÏÀº ÂüÀ¸·Î ½±½À´Ï´Ù.

      objRS.Open("SELECT au_lname, au_fname FROM Authors Where (au_lname + ', ' + au_fname) >= '" + strInput + "' ORDER BY au_lname, au_fname", objConn, 0, 3);
      
      var tmpMsg = new String;
      tmpMsg.value = "";  

µ¥ÀÌÅͺ£À̽º ³¡¿¡ µµ´ÞÇÒ ¶§±îÁö recordsets¸¦ ¼øÈ¯ÇÕ´Ï´Ù. °Ë»öµÈ À̸§°ú ¼ºÀ» ¿¬°áÇÏ¿© °¢ ±â·ÏÀ» ÄÝ·ÐÀ¸·Î ±¸ºÐÇÕ´Ï´Ù.

      while (!objRS.EOF)
      {
        tmpMsg.value = tmpMsg.value + objRS("au_lname") + ", " + objRS("au_fname") + ":";

        objRS.MoveNext();
      }


¸¶Áö¸· ´Ü°è´Â µ¥ÀÌÅͺ£À̽º ¿¬°áÀ» ´Ý°í, resultset¸¦ Ŭ¶óÀÌ¾ðÆ® ½ºÅ©¸³Æ®¿¡ ¸®ÅÏÇÏ°í ±×¸®°í ¸¶Áö¸·À¸·Î <SCRIPT> ºí·ÏÀ» ´Ý´Â °ÍÀÔ´Ï´Ù.

      objConn.Close();
      
      return tmpMsg.value;
    }
</SCRIPT>

³¡³µ½À´Ï´Ù!

Remote ScriptingÀ» »ç¿ëÇØ¼­ ¿ì¸®´Â Ŭ¶óÀÌ¾ðÆ®¿Í ¼­¹ö »çÀÌÀÇ °æ°è¸¦ È¿°úÀûÀ¸·Î ¾ø¾Ý½À´Ï´Ù. ¿ì¸®ÀÇ ¾ÖÇø®ÄÉÀ̼ÇÀº Ŭ¶óÀÌ¾ðÆ® ÄÚµåÀÇ À§·ÂÀ» Ȱ¿ëÇÏ¿© Çü½ÄÁöÁ¤°ú °ËÁõÀ» ó¸®ÇÏ¸ç ¼­¹öÃø ÄÚµåÀÇ ´ÙÁß ºê¶ó¿ìÀú ȣȯ¼º¿¡ ÀÇÁ¸ÇÕ´Ï´Ù.

¾ÕÀÇ ÄÚµå´Â ´Ù¾çÇÑ Remote Scripting ¾ÖÇø®ÄÉÀ̼ÇÀ» À§ÇÑ ÇÁ·¹ÀÓ¿÷À¸·Î »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù. Remote Scripting ÄÚµåÀÇ ¹®Á¦ ÇØ°á¿¡ ´ëÇØ¼­´Â MSDN Scripting Web Site (US)Non-MSDN link¿¡ ÀÖ´Â Checking for ErrorsNon-MSDN link¸¦ Âü°íÇϽʽÿÀ. À̹ø ´Þ¿¡´Â ÀúÀÇ ÆÀ µ¿·áÀÎ ÀÌ ´Þ¿¡ Äڵ带 ó¸®ÇØ ÁØ Doug Rothaus¿¡°Ô °¨»çÀÇ ¸»À» ÀüÇÕ´Ï´Ù.

 


Jeff Sandquist´Â MicrosoftÀÇ ÃÖÁ¤¿¹ Canucks Áß ÇÑ »ç¶÷À̸ç Microsoft Developer Support ºÎ¼­ÀÇ Active Server Pages Escalation Team¿¡ ¼Ò¼ÓµÇ¾î ÀÖ½À´Ï´Ù.

       
¡â ÀÌÀü±Û: Indexing Service
¡ä ´ÙÀ½±Û: Remote Registry
Copyright 1999-2025 Zeroboard / skin by enFree