|
|
|
|
¹Ý¾ß / 2000-06-29 / ¿ÀÈÄ 6:39:21 / 210.207.238.52
Á¶È¸¼ö : 117
|
[Áú¹®] 俵´Ô~ ÇÏÀÌ~ ¶óµð¿À¹öÆ° üũ¹®Á¦Á» ÇØ°áÇØ ÁÖ¼¼¿ä. |
¼³¹®Á¶»ç¿¡¼ ¶óµð¿À¹öÆ°À» ÀÌ¿ëÇؼ üũÇÏ´Â ·ÎÁ÷ÀÔ´Ï´Ù. ¶óµð¿À¹öÆ°À» 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
%>
|
|
|
|