AIX | HP-UX | OS/2 | OS/390 | OS/400 | SCO | SUN | Win NT |
X | X | X | X | X | X | X | X |
list º¯¼ö¸¦ »ç¿ëÇÏ¿© ±¸ºÐµÈ °ª ¹®ÀÚ¿À» ÀÛ¼ºÇÒ ¼ö ÀÖ½À´Ï´Ù. À̵é Áß ÀϺδ WHERE ¶Ç´Â HAVING Àý¿¡¼ ¹ß°ßµÈ °Í°ú °°Àº º¹¼öÀÇ Ç׸ñÀ» »ç¿ëÇÏ¿© SQL Á¶È¸¸¦ ±¸¼ºÇÏ´Â µ¥ À¯¿ëÇÕ´Ï´Ù.
°ø¹éÀº Áß¿äÇÕ´Ï´Ù. ÀϹÝÀûÀ¸·Î °ªÀÇ ¾ç³¡¿¡ °ø¹éÀ» µÎ¾î °ªÀ» ºÐ¸®ÇÕ´Ï´Ù. ´ëºÎºÐÀÇ Á¶È¸¿¡¼´Â ºÎ¿ï ¶Ç´Â »ê¼ú ¿¬»êÀÚ(¿¹: AND, OR ¹× >)¸¦ »ç¿ëÇÕ´Ï´Ù. ±¸¹® ¹× ÀÚ¼¼ÇÑ Á¤º¸¸¦ º¸·Á¸é LIST ¸í·É¹®À» Âü°íÇϽʽÿÀ.
¿¹Á¦ 1: Á¶°Ç º¯¼ö, ¼û°ÜÁø º¯¼ö ¹× list º¯¼öÀÇ »ç¿ë
%HTML(INPUT){ <FORM METHOD="POST" ACTION="/cgi-bin/db2www/example2.max/report"> Select one or more cities:<BR> <INPUT TYPE="checkbox" NAME="conditions" VALUE="$$(cond1)">Sao Paulo<BR> <INPUT TYPE="checkbox" NAME="conditions" VALUE="$$(cond2)">Seattle<BR> <INPUT TYPE="checkbox" NAME="conditions" VALUE="$$(cond3)">Shanghai<BR> <INPUT TYPE="submit" VALUE="Submit Query"> </FORM> %} %DEFINE{ DATABASE="custcity" %LIST " OR " conditions cond1="cond1='Sao Paolo'" cond2="cond2='Seattle'" cond3="cond3='Shanghai'" whereClause= ? "WHERE $(conditions)" : "" %} %FUNCTION(DTW_SQL) mySelect() { SELECT name, city FROM citylist $(whereClause) %} %HTML(REPORT){ @mySelect() %}
HTML Çü½Ä¿¡¼ ¼±ÅÃµÈ ¹Ú½º°¡ ¾øÀ¸¸é Á¶°ÇÀÌ ³Î(NULL)À̹ǷΠÁ¶È¸¿¡¼ whereClauseµµ ³Î(NULL)ÀÌ µË´Ï´Ù. ±×·¸Áö ¾ÊÀ¸¸é whereClause´Â ºÎ¿ï ¿¬»êÀÚ OR·Î ºÐ¸®µÈ ¼±ÅÃµÈ °ªÀ» °¡Áý´Ï´Ù. ¿¹¸¦ µé¾î, ¼¼ µµ½Ã°¡ ¸ðµÎ ¼±ÅõǾúÀ¸¸é SQL Á¶È¸´Â ´ÙÀ½°ú °°½À´Ï´Ù.
SELECT name, city FROM citylist WHERE cond1='Sao Paolo' OR cond2='Seattle' OR cond3='Shanghai'
¿¹Á¦ 2: °ª ºÐ¸®ÀÚ
%DEFINE %LIST " | " VLIST %REPORT{ %ROW{ <EM>$(ROW_NUM):</EM> $(VLIST) %} %}
ÀÌ ¿¹Á¦¿¡¼ ³»ÀçÀû º¯¼ö VLIST´Â µÎ °³ÀÇ Å« µû¿ÈÇ¥¿Í ÇϳªÀÇ OR ¸·´ë " | "¸¦ °ª ºÐ¸®ÀÚ·Î »ç¿ëÇÕ´Ï´Ù. ¹®ÀÚ¿ °ªÀº µû¿ÈÇ¥·Î ºÐ¸®µË´Ï´Ù.