|
|
|
|
Leader / 2002-01-10 / ¿ÀÀü 10:22:31 / 211.189.136.10
Á¶È¸¼ö : 138
|
[Áú¹®] ^¤Ñ^ °¨»ç... ÀÌ·¸°Ô Çؼ Çѹø ÄÚµùÇØ º¼°Ô¿ä... (__) |
> > set conn = µðºñ¿ÀºêÁ§Æ® ¿¡À̵ð¿À Ä¿³Ø¼Ç...
> >
> > ÇÏ°í...
> >
> > Äõ¸®¹®="¿¡½ºÅ¥¿¤ Äõ¸®¹®1"
> > set rs1 = conn.execute(Äõ¸®¹®)
> >
> > Äõ¸®¹®2="¿¡½ºÅ¥¿¤ Äõ¸®¹®2"
> > set rs2 = conn.execute(Äõ¸®¹®2)
> >
> >
> > ÀÌ·±½ÄÀ¸·Î ¤Ñ¤Ñ¤» rs ¸¦ ¸î°³³ª »ç¿ëÇÒ¼ö ÀÖÁÒ??
> >
> > ¤Ñ¤Ñ¤» Èû´Ý´Â µ¥ ±îÁöÀÎÁÙ ¾Æ¶ú´Âµ¥... -_-;;
> >
> -----------------------------------------------------------
>
> Èû ´Ý´Âµ¥ ±îÁö »ý¼º ½ÃŲ´Ù¸é ¾Æ¸¶ À¥ÆäÀÌÁö ¾È ¶ßÁö ½Í³×¿ä..
>
> »ý¼º °¹¼öÀÇ Á¦ÇÑÀº ¾øÁö¸¸ µðºñ¿ÍÀÇ Á¢ÃËÀ» ÃÖ¼ÒÈ ÇÏ´Â°Ô ÆÛÆ÷¸Õ½º ¸é¿¡¼ ³´½À´Ï´Ù.
>
> ±×¸®°í ¿©·¯°³ÀÇ ·¹ÄÚµå ¼Â °´Ã¼¸¦ »ç¿ëÇϱ⺸´Ù´Â
> ÇÑ°³ÀÇ ·¹ÄÚµå¼Â °´Ã¼¸¦ »ç¿ëÇÏ´Â ÆíÀÌ ³´±¸¿ä.
> Set objRs = Server.CreateObject("ADODB.RecordSet")
> objRs.Open ~~~
> .
> .
> .
> objRs.Close
>
> objRs.Open~~~
> .
> .
> .
> objRs.Close
>
> ......
>
> Set objRs = Nothing
>
> ±×¸®°í Insert³ª Update, Delete Äõ¸®¹®µéÀº ·¹ÄÚµå¼ÂÀ» »ý¼º ½Ãų ÇÊ¿ä°¡ ¾øÀ¸¹Ç·Î
> ±»ÀÌ
>
> Set objRs = objCon.Execute(strQuery)
>
> ÀÌ·±½ÄÀÇ ½ÇÇà º¸´Ù´Â
>
> objCon.Execute strQuery, , adCmdText+adExecuteNoRecords
>
> ½ÄÀ¸·Î ÇÏ¿© ·¹ÄÚµå¼ÂÀ» »ý¼º ½ÃÅ°Áö ¾Ê´Â°Ô Á» ´õ ³´°ÚÁÒ..
>
> ±×·³ À̸¸..
>
>
>
-----------------------------------------------------------
|
|
|
|