|
|
|
|
±Ç±â¿Ï / 2001-10-29 / ¿ÀÈÄ 2:58:08 / 211.49.118.3
Á¶È¸¼ö : 132
|
[Áú¹®] update ¿¡¼ null °ªÀ» ³Ö°í ½Í½À´Ï´Ù. |
ȸ¿øÀÌ ¾î´õ¸¦ ½ÅûÇßÀ»°æ¿ì ±× ¾î´õ¸¦ µ¥ÀÌÅͺ£À̽º¿¡ ÀúÀåÇÕ´Ï´Ù.
±×·±µ¥ ÁøÇàÁßÀε¥ °©ÀÚ±â ȸ¿øÀÌ ±× ¿À´õ¿¡ ´ëÇؼ
ĵ½½À» ÇßÀ»°æ¿ì
¹×ÀÇ ¼Ò½º¸¦ »ç¿ëÇؼ ¾÷µ«À» ÇÏ°Ô µË´Ï´Ù.
set strConnect=server.createobject("adodb.connection")
strConnect.Open strConn
handphone = request("handphone")
sql= "update tbl_members set "
sql= sql & " point= '"& null &"',"
sql= sql & " cash= '"& null &"',"
sql= sql & " usedate = '"& null &"',"
sql= sql & " partner = '"& null &"',"
sql= sql & " usecontents = '"& null &"',"
sql= sql & " driver = '"& null &"',"
sql= sql & " discount = '"& null &"',"
sql= sql & " total = '"& null &"' where handphone = '"& request("handphone") &"'"
strConnect.execute sql
±×·±µ¥ null °ªÀÌ µé¾î°¡¾ßÇÒ ¸î°³ÀÇ Çʵ常
¾÷µ«¿¡¼ null °ªÀ¸·Î ³Ö°í ½ÍÀºµ¥...
null °ªÀ» ¾î¶»°Ô ³Ö¾î¾ß µÇÁÒ....?
|
|
|