IBM Books

Net.Data ÂüÁ¶¼­

List º¯¼ö


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 ¸·´ë " | "¸¦ °ª ºÐ¸®ÀÚ·Î »ç¿ëÇÕ´Ï´Ù. ¹®ÀÚ¿­ °ªÀº µû¿ÈÇ¥·Î ºÐ¸®µË´Ï´Ù.


[ ÆäÀÌÁöÀÇ ¸Ç À§ | ÀÌÀü ÆäÀÌÁö | ´ÙÀ½ ÆäÀÌÁö | ¸ñÂ÷ | »öÀÎ ]