|
¹Ú°¡·ç / 2001-12-30 / ¿ÀÈÄ 1:09:10 / 210.178.30.238
Á¶È¸¼ö : 142
|
[Áú¹®] ¹ÌÄ¡°Ú´Ù,,,±¸¹®¿¡·¯ Á» ÇØ°áÇØ Áֽʽÿä.. |
> <%@ Language=VBScript %>
>
> <%
> Response.Buffer = False
>
> if Request("IsWrite") = "TRUE" then
> set dbCon = Server.CreateObject("ADODB.Connection")
> dbCon.Open "health", "", ""
> strQuery = _
> "INSERT INTO salyung(from,grade,name,aim,mon,tue,wed,thu,fri,sat,sun) VALUES ('"&_
> Request("from") & "', '" & _
> Request("grade") & "', '" & _
> Request("name") & "', '" & _
> Request("aim") & "', '" & _
> Request("mon") & "', '" & _
> Request("tue") & "', '" & _
> Request("wed") & "', '" & _
> Request("thu") & "', '" & _
> Request("fri") & "', '" & _
> Request("sat") & "', '" & _
> Request("sun") & "')"
>
> Response.Write strQuery
> dbCon.Execute strQuery
>
>
> ÀÌ·¸°Ô ÇϽøé
> ÀμƮ Äõ¸® ¹®ÀåÀÌ ÂïÈù ´ÙÀ½ ¿¡·¯¸Þ½ÃÁö ¶ã°Ì´Ï´Ù.
>
> È®ÀÎÇÏ¿© º¸¼¼¿ä..
-----------------------------------------------------------
INSERT INTO salyung(from,grade,name,aim,mon,tue,wed,thu,fri,sat,sun) VALUES ('ÀÔ·ÂµÈ ³»¿ëµé',......)
ÀÌ·¸°Ô ³ª¿À°í ¶È°°Àº ¿¡·¯¹® ³ª¿É´Ï´Ù..
±×¸®°í ±ôºýÇߴµ¥
¸Ç À§¿¡ DB¿¡·¯ ¸Þ¼¼Áöµµ °°ÀÌ ³ª¿É´Ï´Ù..
ÇÏÁö¸¸ ODBC¿¬°áÀº È®½ÇÈ÷ Çß½À´Ï´Ù.
¶È°°Àº DB·Î ¸®½ºÆ® º¸¿©ÁÖ´Â ºÎºÐÀº ÀÌ»ó¾øÀÌ Àß ³ª¿À´Ï±î......ÀÌÀ¯°¡ ¹ºÁö Àß ¸ð¸£°Ú½À´Ï´Ù..
Ȥ½Ã ÇÊµå ¼Ó¼º¿¡ ¹®Á¦°¡ ÀÖ´ÂÁö
´Ù½Ã Çѹø¸¸ Á¶¾ðÀ» Áֽʽÿä,.
|
|
|