|
|
|
|
俵ÀÌ / 2000-06-29 / ¿ÀÈÄ 10:08:34 / 203.255.3.190
Á¶È¸¼ö : 126
|
[Áú¹®] 俵´Ô~ ÇÏÀÌ~ ¶óµð¿À¹öÆ° üũ¹®Á¦Á» ÇØ°áÇØ ÁÖ¼¼¿ä. |
> ¼³¹®Á¶»ç¿¡¼ ¶óµð¿À¹öÆ°À» ÀÌ¿ëÇؼ üũÇÏ´Â ·ÎÁ÷ÀÔ´Ï´Ù. ¶óµð¿À¹öÆ°À» db¿¡¼ ²ø°í¿Â µ¥ÀÌÅ͵é·Î ·çÇÁ¸¦ µ¹¸®¸é, 5°³ÀÇ ¹öÆ°ÀÌ »ý±â´Âµ¥, ¸¸¾à ,üũ¸¦ ¾ÈÇÏ¸é ¸ø³Ñ±â°Ô ÇÏ´Â ½ºÅ©¸³Æ®°¡ À߾ȵdz׿ä.üũ¸¦ Çصµ ¾ÈÇß´Ù°í ¸Þ¼¼Áö°¡ ¶å´Ï´Ù.
> ¹Ø¿¡ ½ºÅ©¸³Æ® ºÎºÐÀº ´Ù¸¥ÆäÀÌÁö¿¡¼µµ ¾²´Â°Çµ¥ ´Ù¸¥ÆäÀÌÁö ¶óµð¿À¹öÆ°Àº db·Î ²ø¾î¿Í ·çÇÁµ¹¸®´Â°ÍÀÌ ¾Æ´Ï°í, ÀÏÀÏÀÌ ÄÚµùÇϴ°ÍÀä. ÀÌ°Ç µÇ¿ä.~~ ¾î¶»°Ô ÇؾßÇϳª¿ä.
>
>
>
> <%
> Set Conn = Server.CreateObject("ADODB.Connection")
> Conn.Open ("dsn=xx;Uid=xx;pwd=xx")
>
> ' ===== ¼³¹® Á¶»ç °ü¸® Å×ÀÌºí º¸¿©ÁÖ±â =========
> SQL1="Select * from survey_mng order by no_survey desc" '¼³¹®Á¶»ç¹øÈ£ ÃÖÁ¾°ÍÀÌ À§·Î.
> Set RS = Conn.Execute (SQL1)
> no=RS("no_survey") ' ¼³¹®Á¶»ç °íÀ¯ ¹øÈ£
> number=RS("number_sv") ' ¹®Ç× °¹¼ö
> ' ======== ¼³¹® ¹®Ç× °¡Á®¿À±â ==============
> SQL2="Select * from surveys where no_survey = " & RS("no_survey")
> Set RS2 = Conn.Execute (SQL2)
> ' ===== ¼³¹® ³»¿ë º¸¿©ÁÖ±â ========
> %>
>
>
>
>
>
>
>
> |
>
>
>
>
> [Q] <%= RS("content_sv")%>
> |
>
>
>
> <%
> Conn.close
> Set RS = nothing
> Set RS2 = nothing
> %>
>
>
>
> |
>
>
>
-----------------------------------------------------------
Áú¹®ÀÌ ´Ù ÅÂÅ©¶§¹®¿¡ ¹«½¼ ¹®Á¦ÀÎÁö ¸ð¸£°Ú³×¿ä...
¶óµð¿À ¹öÆ°ÀÇ Ã¼Å© ¹®Á¦¶ó¸é....
Â÷¶ó¸® ¶óµð¿À ¹öÆ°À» ¸¸µé¾î ÁÙ¶§ selectÇÒ¶§ if¹®À» ÀÌ¿ëÇÏ¿©
óÀ½ Çϳª¸¦ checked·Î Ç¥½ÃÇØ ÁÖ¸é °£´ÜÇÒ °Í °°Àºµ¥¿ä...
±×·¸Ä¡ ¾ÊÀ»±î¿ä?
´Ù¸¥ Áú¹®µµ ¿ª½Ã ű׶§¹®¿¡ Àß ¸ð¸£°Ú³×¿ä...
|
|
|