|
|
|
|
俵ÀÌ / 2001-12-19 / ¿ÀÀü 11:03:52 / 203.255.3.190
Á¶È¸¼ö : 141
|
[Áú¹®] ¤¾¤¾¤¾ Áú¹® -_-;;
|
> >
> > strSQLFind="insert into groupadmin.APPROVAL_TABLE (DEPTNO, APP_NAME, SEQNO, EMPNO)"
> > strSQLFind=strSQLFind & " "
> > strSQLFind=strSQLFind & " select ºÎ¼CODE,'"&approverPath&"',"&s&","&ApproverID&" from openquery(stc,'select ºÎ¼CODE from Àλç_ÃÖ±Ù¹ß·É Where »çÁ÷ÀÏÀÚ Is Null and »ç¹ø=''"&AppID&"''')"
> >
> >
> > ÀÏ´Ü Àú¹øºÎÅÍ ±×·¨´ø°Çµ¥... ÀÌ ºÎºÐ¿¡¼ from µÚ¿¡ ÀÖ´Â
> >
> > openquery¶ó´Â°Ô ¹» ÀǹÌÇÏ´Â °Ç°¡¿ä?
> >
> > ÇÔ¼öÀΰ¡¿ä? ±×·³ ±× µÞºÎºÐÀº ¹» ÀǸ¶Çϴ°ǰ¡¿ä?
> >
> > ±×¸®°í openquery ¾È¿¡ »ç¹ø = ´ÙÀ½¿¡´Â ¿Ö ÀÛÀº µû¿ÈÇ¥°¡ 2°³¾¿ µé¾î°¬³ª¿ä?
> >
> > ±×¸®°í strSQLFind=strSQLFind & " select ºÎ¼CODE,'"&approverPath&"',"&s&","&ApproverID&" from
> >
> > ÀÌ ¹®Àå¿¡¼´Â approverPath º¯¼ö ÁÖÀ§¿¡ ÀÖ´Â ÀÛÀº µû¿ÈÇ¥´Â ºÒÇÊ¿ä ÇÑ°Í °°Àºµ¥¿ä...
> >
> > ±×¸®°í Àú¹ø¿¡µµ ¸»¾¸ µå·È´Âµ¥... Áú¹°À» ÇϽǶ§´Â
> >
> > ±×³É ¾È µÇ´Âµ¥¿ä ÀûÀ¸¸é ¾È µÇ°í¿ä.....
> >
> > ¾îµð¼ ¾î¶»°Ô ¾È µÇ´ÂÁö¸¦ Àû¾î¾ß¸¸ ´äº¯ÀÌ °¡´ÉÇÕ´Ï´Ù....
> >
> > ¿¡·¯°¡ ³ª´ÂÁö ¾Æ´Ï¸é ¿¡·¯´Â ¾È ³ª´Âµ¥ ³í¸®ÀûÀ¸·Î ¿øÇÏ´Â ´äÀÌ ¾È ³ª¿À´ÂÁö
> >
> > ¿¡·¯°¡ ³´Ù¸é ¾î¶² ¿¡·¯°¡ ³ª´ÂÁö¸¦ Àû¾î Áּž߸¸ ´Ù¸¥ ºÐµéÀÌ
> >
> > ¸®´õ´ÔÀÇ Áú¹®À» ÀÌÇØÇÒ ¼ö ÀÖ°ÚÁÒ... ¾ó±¼ ¸Â´ë°í À̾߱âÇÏ´Â °Íµµ ¾Æ´Ï°í ¸»ÀÌ¿¹¿ä... ^^
> >
> > ³Ñ ¹«¸®ÇÏÁö ¸¶½Ã°í ½¬¾ö½¬¾ö Çϼ¼¿ä~~
> >
> >
> -----------------------------------------------------------
>
> ¾Æ... ¼³¸íÀ» Çص帱°Ô¿ä...
>
> SQL°ú ORACLE À» °°ÀÌ ¿¬°áÇؼ »ç¿ëÀ» Çϴµ¥¿ä...
>
> ORACLEÀ» SQL¿¡¼ Á÷Á¢ Äõ¸®¸¦ ÇÏ·Á¸é...
>
> SELECT * FROM OPENQUERY(¿À¶óŬ¼¹öÀ̸§,'Äõ¸®¹®')
>
> ÀÌ·± Çü½ÄÀ¸·Î ¾´´ä´Ï´Ù...
>
> ¸¸¾à...¿À¶óŬ¿¡ AAAA¶ó´Â Å×ÀÌºí¿¡¼ ¡º¼¼ÀÚ¡»¶ó´Â
>
> °É ãÀ¸·Á¸é...
>
> SELECT * FROM OPENQUERY(¿À¶óŬ¼¹öÀ̸§,'SELECT * FROM AAAA WHERE NAME = ''¼¼ÀÚ''')
>
> ÀÌ·¸°Ô Çؾߵǰŵç¿ä...
>
> ¤Ñ¤Ñ;;; ÄõÅ×À̼ÇÀ» µÎ°³¾¿ ºÙ¿©Áà¾ßÇØ¿ä...
>
> ¿¡ÈË...
>
> Á¦°¡ ¾ÈµÇ´Â ºÎºÐÀº...
>
> str = "2000066,2000001,2000066,2000002,2000003,2000004,"
>
> ÀÌ°ªÀÌ ³ª¿À´Â °÷¿¡¼...
>
> ½ºÇÁ¸®Æ®·Î ÂÉ°³°í....
>
> appID = split(str,",")
>
> ·çÇÁ¸¦ µ¹·Á¼....
> s=0
> do until s<ubound(appId)
> appID(s) <==¿ä°í ÀúÀå...
> ÀμƮ¹®...
> loop
>
> ÀÌ·±½ÄÀ¸·Î... Â÷·ÊÂ÷·Ê ÀúÀåÀ» ÇÏ°í ½Í¾î¿ä...
>
> ±×·±µ¥... -_-;; ±×³É ÆäÀÌÁö¿¡ ¿À·ù´Â ¾È³ª´Âµ¥...
>
> -_-;; Å×À̺íÀ» º¸¸é µ¥ÀÌÅÍ°¡ ¾Èµé¾î°¡ÀÖ¾î¿ä...
>
> ¤Ñ_¤Ì
>
>
-----------------------------------------------------------
ÁøÀÛ ÀÌ·¸°Ô ¸»¾¸ÇϽÃÁö... ^^
ÀÏ´Ü °ªÀÌ ¾È µé¾î°¡´Â ÀÌÀ¯´Â
do ¹®ÀÇ Á¶°ÇÀÌ Æ²¸°°Í °°Àºµ¥¿ä...
do until¹®À» »ç¿ëÇϼÌÀ¸´Ñ±î ÀÛÀ»¶§±îÁö µ¹¾Æ¾ß µÇ´Ñ±î
do until s < ubound....
ÀÌ ¹®ÀåÀÌ
do until s > ubound....
ÀÌ·¸°Ô µÇ¾î¾ß µÉ°Í °°±¸¿ä....
´ÙÀ½¿¡ splitÇϽǶ§...
ApproverID = split(ApproverID,",")
ÀÌ·¸°Ô ÇϽŴٰí Çϼ̴µ¥....
º¯¼ö¸íÀÌ Æ²·Á¾ß µÉ°Í °°Àºµ¥¿ä....
ApproverID¿¡ µé¾îÀÖ´Â °ªÀ» splitÇÑ°É ´Ù½Ã ApproverID¿¡ ³Ö´Â´Ù´Â°Í ¾îµò°¡ ÀÌ»óÇÏÁö ¾Ê³ª¿ä?
ApproverIDs = split(ApproverID,",")
ÀÌ·¸°Ô Çؼ
ApproverIDs ¶ó´Â º¯¼ö¿¡ ³Ö°í ±× °ªÀ» »ç¿ëÇØ º¸¼¼¿ä....
±×·³....
|
|
|
|