Jeff Sandquist Àú
Ŭ¶óÀÌ¾ðÆ®¿Í ¼¹ö »çÀÌÀÇ °æ°è¸¦ ¾ø¾Ö´Â Remote Scripting
À̹ø ´Þ¿¡´Â Microsoft Remote ScriptingÀ» µµÀÔÇÏ¿© Ŭ¶óÀÌ¾ðÆ®¿Í ¼¹ö »çÀÌÀÇ °æ°è¸¦ ¾ø¾Ù ¿¹Á¤ÀÔ´Ï´Ù. Remote ScriptingÀ» ÀÌ¿ëÇÏ¸é ºê¶ó¿ìÀú°¡ ÆäÀÌÁö Àüü¸¦ ¸®·ÎµåÇÏÁö ¾Ê°íµµ ¼¹ö¿¡ ÀÖ´Â ½ºÅ©¸³Æ®¸¦ È£ÃâÇÒ ¼ö ÀÖ´Â ¾ÖÇø®ÄÉÀ̼ÇÀ» ¸¸µé ¼ö ÀÖ½À´Ï´Ù. ÀÌ ±â»ç¿¡¼´Â Remote ScriptingÀ» »ç¿ëÇØ¼ ¾ÖÇø®ÄÉÀ̼ÇÀ» ¿øÈ°ÇÏ°Ô ¿î¿µÇϰí À¥ »çÀÌÆ®¸¦ º¸´Ù ºü¸£°í dzºÎÇÏ°í ´ëÀÀÀûÀ¸·Î ¸¸µå´Â ¹ýÀ» ¹è¿ï °ÍÀÔ´Ï´Ù.
Microsoft Remote ScriptingÀ» »ç¿ëÇÏ¿© ¼¹ö¿Í Ŭ¶óÀÌ¾ðÆ® »çÀÌÀÇ °ü°è¸¦ Çâ»ó½ÃŰ½Ê½Ã¿À.
½Ã³ª¸®¿À
´ÙÁß ºê¶ó¿ìÀú ȯ°æÀÇ ¾ÖÇø®ÄÉÀ̼ÇÀ» °³¹ßÇϰí Àִµ¥ ¸ðµç »ç¿øÀÇ À̸§ÀÌ µé¾î ÀÖ´Â Select ¹Ú½º¸¦ ³ªÅ¸³»°í ½Í½À´Ï´Ù.
¿©·¯ºÐÀÇ SQL Server µ¥ÀÌÅͺ£À̽º¿¡ 1¸¸ ¸íÀÇ »ç¿ø À̸§ÀÌ µé¾î ÀÖ´Â Å×À̺íÀÌ ÀÖ½À´Ï´Ù. »ç¿ëÀÚ¸¦ À§Çؼ Å×À̺í Àüü¸¦ Select ¹Ú½º¿¡ ·ÎµåÇÏ°Ô µÇ¸é ¼º´É¿¡ Å« ÁöÀåÀÌ ÀÖÀ¸¸ç ÇÊ¿ä ¾ø´Â Á¤º¸¸¦ ´Ù¿î·ÎµåÇÏ´Â µ¿¾È ±â´Ù·Á¾ß ÇÕ´Ï´Ù. ´ë½Å¿¡ óÀ½ 10°³ ±â·Ï¸¸ º¸¿©ÁØ ´ÙÀ½ Ãß°¡ ·¹ÄÚµå´Â »ç¿ëÀÚÀÇ ÀÔ·ÂÀÇ ÄÁÅØ½ºÆ®¿¡ ±âÃÊÇÏ¿© º¸³»°í ½Í½À´Ï´Ù. ±×·¯¹Ç·Î »ç¿ëÀÚ°¡ "S"¸¦ ÀÔ·ÂÇϸé Å×À̺íÀº ±× ¼ºÀÌ "S"·Î ½ÃÀ۵Ǵ »ç¿øÀÇ Ã³À½ 10°³ ±â·ÏÀ» öÀÚ¼øÀ¸·Î ¿°ÅÇÒ °ÍÀÔ´Ï´Ù. »ç¿ëÀÚÀÇ ºê¶ó¿ìÀú¿¡ ³ªÅ¸³ª´Â Ãâ·ÂÀº ´ÙÀ½°ú °°Àº ¸ð¾çÀÌ µÉ °ÍÀÔ´Ï´Ù.
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 Pack Àº ÇÊ¿äÇÑ ÆÄÀϵéÀ» ¸ðµÎ ¼³Ä¡ÇØÁÝ´Ï´Ù.
System DSN ¸¸µé±â
µ¥ÀÌÅ͸¦ ÂüÁ¶ÇÏ´Â ½Ã½ºÅÛ µ¥ÀÌÅÍ ¼Ò½º À̸§(DSN)À» ¸¸µå½Ê½Ã¿À. System DSNÀº DSNÀÌ ¸¸µé¾îÁø ÄÄÇ»ÅÍÀÇ Windows Registry¿¡ µ¥ÀÌÅÍ ¿¬°á¿¡ ´ëÇÑ Á¤º¸¸¦ ÀúÀåÇÕ´Ï´Ù. ¿©·¯ºÐÀÇ ¾ÖÇø®ÄÉÀ̼ÇÀº Microsoft SQL Server Pubs »ùÇà µ¥ÀÌÅͺ£À̽º¿¡ ¿¬°áµË´Ï´Ù. À¥ ¼¹ö¿¡¼ Á¦¾îÆÇÀÇ ODBC ¾ÆÀÌÄÜÀ» ´õºíŬ¸¯Çϰí System DSN ÅÇÀ» Ŭ¸¯ÇÏ¿© Pubs µ¥ÀÌÅͺ£À̽º¸¦ °¡¸®Å°´Â "Pubs"¶ó´Â À̸§ÀÇ »õ·Î¿î System DSNÀ» ¸¸µé¾î Ãß°¡ÇϽʽÿÀ.
- Á¦¾îÆÇÀ» ¿°í ODBC¸¦ ´õºíŬ¸¯ÇϽʽÿÀ.
- System DSN ÅÇÀ» Ŭ¸¯Çϰí Add¸¦ Ŭ¸¯ÇϽʽÿÀ.
- ¼³Ä¡µÈ ODBC µå¶óÀ̹ö ¸ñ·Ï¿¡¼ SQL Server¸¦ ¼±ÅÃÇϽʽÿÀ. Finish¸¦ Ŭ¸¯ÇϽʽÿÀ.
- Á¦°øµÈ ÅØ½ºÆ® ¹Ú½º¿¡ µ¥ÀÌÅÍ ¼Ò½ºÀÇ À̸§°ú ¼¹ö¸¦ ÀÔ·ÂÇϽʽÿÀ. NameÀ»"Pubs"·Î ¼³Á¤Çϰí Server¸¦ SQL ServerÀÇ À̸§À¸·Î ¼³Á¤ÇϽʽÿÀ. ¼³¸í Ãß°¡´Â ¼±ÅûçÇ×ÀÔ´Ï´Ù. Next¸¦ Ŭ¸¯ÇϽʽÿÀ.
- 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 ¸Þ¼µå RSEnableRemoteScripting À» È£ÃâÇϰí ÀÌ ÆäÀÌÁö¿¡¼ 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ÀÇ RSExcute ¸Þ¼µå¿Í ÇÔ²² ¼¹öÃø ÇÔ¼ö¿¡ Àü´ÞÇÕ´Ï´Ù.
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) ¿¡ ÀÖ´Â Checking for Errors ¸¦ Âü°íÇϽʽÿÀ. À̹ø ´Þ¿¡´Â ÀúÀÇ ÆÀ µ¿·áÀÎ ÀÌ ´Þ¿¡ Äڵ带 ó¸®ÇØ ÁØ Doug Rothaus¿¡°Ô °¨»çÀÇ ¸»À» ÀüÇÕ´Ï´Ù.
|