Re: WebBlade AppPage Size Limit?

Donald Xie wrote: > Hi Informix Gurus, > > Our company is developing an on-line ordering system using Informix > Universal Server with WebBlade. In one AppPage document (html file), we use > a table to display a SQL query output. Each cell has a <?MIVAR><?/MIVAR> > statement. When the number of rows (<TR>) exceeds 8 (the html file then has > total of 219 lines with the last 3 lines be </TABLE></BODY></HTML> > respectively), the WebLint reports error "(216) error: Page terminates > before tag <MIVAR> has been closed". My question is: do AppPages have a > limit on the number of lines or <?MIVAR> tags? > > Thanks in advance for your reply and tips. > > Donald If I understand what you say then I might have some tips. First , as far as I understand it, you shouldn't use <?MIVAR> tags within a <?MISQL> tag. The way to use an embedded SQL stmt within an HTML is as follows: <TABLE> <?MISQL SQL="select x,y from z;"> <TR><TD>$1</TD><TD>$2</TD></TR> <?/MISQL> </TABLE> This piece will act as a loop as long as the SQL stmt returns rows. Further more, you can enclose the whole table within a single <?MIVAR> tag as in the following example: <?MIVAR> <TABLE> <TR><TD>$a</TD><TD>$b</TD></TR> <TR><TD>$c</TD><TD>$d</TD></TR> </TABLE> <?/MIVAR> Hope it helps... Asaf. -- _________________________________________________________________________ | | Asaf Arbely, ATG _/_/_/\\_\\_\\_ | ComSoft Technologies Ltd. _/ \\_ | 39 Ha'galim blvd, Herzelia, Israel. _/ \\_\\_\\_ | TEL: 972-9-9598961 FAX: 972-9-9598980 _/ \\_ | E-Mail: asaf@applicom.co.il _/_/_/\\_\\_\\_ | WEB: www.applicom.co.il |________________________________________________________________________