IBM å
(C) IBM Corp. 2000

Net Search Extender

°ü¸® ¹× »ç¿ëÀÚ ¾È³»¼­

ÀÔ·Â ¸Å°³º¯¼ö

ÀÚ¼¼ÇÑ Á¤º¸´Â TextSearch ½ºÅä¾îµå ÇÁ·Î½ÃÀú¸¦ ÂüÁ¶ÇϽʽÿÀ.

sqlQuery
ÀúÀå ÇÁ·Î½ÃÀú¿¡¼­ ¸®ÅÏÇÑ °á°ú Å×À̺íÀÇ Ä÷³°ú ÇàÀ» ÁöÁ¤ÇÏ´Â SQL¹®. ¼øÀ§°¡ ¾ø´Â Äõ¸®(ranking-Flag=0)ÀÇ °æ¿ì ¸í·É¹®Àº ´ÙÀ½ ±¸Á¶¸¦ °®½À´Ï´Ù.

select ...from ... where ... 

WhereÀý(À妽º¸¦ ÀÛ¼ºÇÑ Å×ÀÌºí ¶Ç´Â ºä¸¦ ÂüÁ¶ÇÏ´Â FromÀý¿¡ ¼ÓÇÔ)Àº SQLÀÌ IN ¼ú¾î¸¦ Çã¿ëÇÏ´Â À§Ä¡¿¡ "<keycolumn> (%s)"À»(¸¦) Æ÷ÇÔÇØ¾ß ÇÕ´Ï´Ù.

¼øÀ§°¡ ÀÖ´Â Äõ¸®(ranking-Flag=1)ÀÇ °æ¿ì ¸í·É¹®Àº ´ÙÀ½ ±¸Á¶¸¦ °®½À´Ï´Ù.

select ...from ... where ... 
SelectÀýÀº SQLÀÌ Ç¥Çö½ÄÀ» Çã¿ëÇÏ´Â À§Ä¡¿¡ Ä÷³ ÂüÁ¶ "RSCORE"¸¦ Æ÷ÇÔÇØ¾ß ÇÕ´Ï´Ù. FromÀýÀº SQLÀÌ Å×À̺í ÂüÁ¶¸¦ Çã¿ëÇÏ´Â À§Ä¡¿¡ "%s"À»(¸¦) Æ÷ÇÔÇØ¾ß ÇÕ´Ï´Ù. WhereÀý(À妽º¸¦ ÀÛ¼ºÇÑ Å×ÀÌºí ¶Ç´Â ºä¸¦ ÂüÁ¶ÇÏ´Â FromÀý¿¡ ¼ÓÇÔ)Àº SQLÀÌ IN ¼ú¾î¸¦ Çã¿ëÇÏ´Â À§Ä¡¿¡ "%s"À»(¸¦) Æ÷ÇÔÇØ¾ß ÇÕ´Ï´Ù.


[ ÆäÀÌÁöÀÇ ¸Ç À§ | ÀÌÀü ÆäÀÌÁö | ´ÙÀ½ ÆäÀÌÁö | ¸ñÂ÷ | »öÀÎ ]