|
|
|
|
ûÇæÔñýѨ / 2002-08-09 / ¿ÀÈÄ 5:51:52 / 203.255.3.190
Á¶È¸¼ö : 153
|
[Áú¹®] ¼Ò½ºÁ¡ ºÁÁÖ¼¼¿ä..... ¤Ì,¤Ì |
> ABC¾÷·Îµå ÄÄÆ÷³ÍÆ®¸¦ »ç¿ëÇϰŵ翩.....
> ±Ùµ¥....¸Ó°¡ À߸ø‰ç´ÂÁö ¸ô°Ú¾î¿©.....
> Çѹø ºÁÁÖ¼¼¿ä.....^^;;
> DBÁ¢¼ÓºÎºÐÀº »°½À´Ï´Ù.......
>
> Set theForm = Server.CreateObject("ABCUpload4.XForm")
> theForm.AbsolutePath = True
> theForm.Overwrite = True
>
> artist = theForm.item("artist") '°¡¼ö
> album = theForm.item("album") '¾Ù¹ü¸í
> album_num = theForm.item("album_num") '¾Ù¹ü¼ø¼
> album_num2 = theForm.item("album_num2") '¾Ù¹üºÐ·ù¹øÈ£
> shop_num = theForm.item("shop_num") '»óÇ°ºÐ·ù
> shop = theForm.item("shop") 'ÁÖ¹®¹øÈ£
> world = theForm.item("world") '±¹³»&±¹¿Ü ±¸ºÐ
> new1 = theForm.item("new") 'Ãֽžٹü µî·Ï
> find = theForm.item("find") 'À½¾Çã±â ù ÀÚÀ½
>
> response.write "°¡¼öÀ̸§Àº : "&artist&" ÀÔ´Ï´Ù..<br><br><br>"
>
> Set theField = theForm.item("file1")(1)
> if world = "korea" then
> If theField.FileExists Then
> filename = theField.SafeFileName
> theField.Save "d:\images\album\ko_ccm\" & theField.safeFileName
> Response.Write "ºüÀÏÀÌ ¾÷·Îµå µÇ¾ú½À´Ï´Ù...."
>
> SQL = "insert into kccm_album(artist,album,album_num,album_num2,filename"
> SQL = SQL & ",shop_num,shop,world,new,find) values"
> SQL = SQL & "('"&artist&"'"
> SQL = SQL & ",'"&album&"'"
> SQL = SQL & ",'"&album_num&"'"
> SQL = SQL & ",'"&album_num2&"'"
> SQL = SQL & ",'"&filename&"'"
> SQL = SQL & ",'"&shop_num&"'"
> SQL = SQL & ",'"&shop&"'"
> SQL = SQL & ",'"&world&"'"
> SQL = SQL & ",'"&new&"'"
> SQL = SQL & ",'"&find&"')"
>
> db.Execute SQL
>
> Else
> Response.Write "ºüÀÏ ¾÷·Îµå ½ÇÆÐÀÔ´Ï´Ù. ´Ù½Ã ÇØÁÖ¼î..."
> End If
> else
> If theField.FileExists Then
> filename = theField.SafeFileName
> theField.Save "d:\images\album\w_ccm\" & theField.safeFileName
> Response.Write "ºüÀÏÀÌ ¾÷·Îµå µÇ¾ú½À´Ï´Ù...."
>
> SQL = "insert into wccm_album(artist,album,album_num,album_num2,filename"
> SQL = SQL & ",shop_num,shop,world,new) values"
> SQL = SQL & "('"&artist&"'"
> SQL = SQL & ",'"&album&"'"
> SQL = SQL & ",'"&album_num&"'"
> SQL = SQL & ",'"&album_num2&"'"
> SQL = SQL & ",'"&filename&"'"
> SQL = SQL & ",'"&shop_num&"'"
> SQL = SQL & ",'"&shop&"'"
> SQL = SQL & ",'"&world&"'"
> SQL = SQL & ",'"&new&"')"
>
> db.Execute SQL
>
> Else
> Response.Write "ºüÀÏ ¾÷·Îµå ½ÇÆÐÀÔ´Ï´Ù. ´Ù½Ã ÇØÁÖ¼î..."
> End If
> End if
>
-----------------------------------------------------------
º¸±ä ºÃ´Âµ¥¿ä...
¿¡·¯°¡ ³´Ù¸é ¹«½¼ ¿¡·¯°¡ ¾îµð¼ ¾î¶»°Ô ³ª´ÂÁö¸¦ ¾Ë·ÁÁּžß...
¹®Á¦Á¡À» ãÁö¿ä...
¾î¶² ¿¡·¯°¡ ¿Ö ³ª´ÂÁö ¾Ë·ÁÁÖ¼¼¿ä....
|
|
|
|