AIX | HP-UX | OS/2 | OS/390 | OS/400 | SCO | SUN | Win NT |
X | X | X | X | X | X | X | X |
¼û°ÜÁø º¯¼ö¸¦ ÅëÇØ HTML ¼Ò½º¿¡ ½ÇÁ¦ º¯¼ö °ªÀÌ ¼û°ÜÁ® ÀÖ´Â °æ¿ì¿¡µµ º¯¼ö¸¦ ÂüÁ¶ÇÒ ¼ö ÀÖ½À´Ï´Ù. ¼û°ÜÁø º¯¼ö¸¦ »ç¿ëÇÏ·Á¸é ´ÙÀ½°ú °°ÀÌ ÇϽʽÿÀ.
¿¹Á¦ 1: HTML Çü½ÄÀ¸·Î ¼û°ÜÁø º¯¼ö
%HTML(INPUT){ <FORM ...> <P>Select fields to view: <SELECT NAME="Field"> <OPTION VALUE="$$(name)"> Name <OPTION VALUE="$$(addr)"> Address . . . </FORM> %} %DEFINE{ name="customer.name" addr="customer.address" %} %FUNCTION(DTW_SQL) mySelect() { SELECT $(Field) FROM customer %} . . .
HTML Çü½ÄÀÌ À¥ ºê¶ó¿ìÀú¿¡ ³ªÅ¸³ª¸é $$(name) ¿Í $$(addr)°¡ °¢°¢ $(name) ¿Í $(addr)·Î ´ëüµÇ¾î ½ÇÁ¦ Å×ÀÌºí ¹× Ä÷³¸íÀÌ HTML Çü½ÄÀ¸·Î ³ªÅ¸³ªÁö ¾ÊÀ¸¹Ç·Î ½ÇÁ¦ º¯¼ö¸íÀÌ ¼û°ÜÁ® ÀÖ´Ù´Â »ç½ÇÀ» ¾Æ¹«µµ ¾Ë ¼ö ¾ø½À´Ï´Ù. »ç¿ëÀÚ°¡ ¾ç½ÄÀ» Á¦ÃâÇϸé, HTML(REPORT) ºí·ÏÀÌ È£ÃâµË´Ï´Ù. @mySelect()°¡ FUNCTION ºí·ÏÀ» È£ÃâÇϸé $(Field)´Â SQL¹®¿¡¼´Â customer.nameÀ¸·Î, SQL Á¶È¸¿¡¼´Â customer.addr·Î ´ëüµË´Ï´Ù.