|
|
|
|
Leader / 2002-02-28 / ¿ÀÀü 9:15:31 / 211.189.136.10
Á¶È¸¼ö : 139
|
[Áú¹®] °ø¹é üũ |
> BOARD Å×ÀÌºí¿¡¼ Á¦¸ñ(title)ÀÌ °ø¹éÀÌ
> ¾Æ´Ñ°ÍÀ» °Ë»öÇÏ·Á°í Çϴµ¥..¾îÄÉ ÇØ¾ß Çϳª¿ä?
>
> ¸¸¾à ³Î°ª üũ¶ó¸é..
> select * from board where title is not null À̶ó°í
> ÇÏ¸é µÇ´Âµ¥..°ø¹éÀ϶§´Â ¾î‰F°Ô ÇØ¾ß ÇÑ´ÀÁö..
>
> °í¼ö´Ôµé ºÎŹµå¸³´Ï´Ù.
-----------------------------------------------------------
select * from board where title is not null and title != ''
ÀÌ·¸°Ô ÇÏ¸é µÇ´Âµ¥...
ºÎÁ¤ÇüÀ» ¾²¸é... À妽º¸¦ ¾ÈŸ±â¶§¹®¿¡...
¼ºê Äõ¸®¸¦ ½á¾ßÇÕ´Ï´Ù...
select * from board where title is not null
ÀÌ·¸°Ô ÇϽŴÙÀ½¿¡...
Á¶°ÇÀýÀ» ¾²¼Å¼...
if ŸÀÌƲ = "" or IsNull(ŸÀÌƲ) then
ŸÀÌƲ = "Á¦¸ñ¾øÀ½"
end if
ÀÌ·± ½ÄÀ¸·Î ¾²½É ´î°Å °°Àºµ¥¿ë... -_-;; |
|
|