four colums=two records
Posted in 1997
I'm currently working on a project storing MPeg movies as Large_Objects in an Illustra database and using Internet through the Webdatablade to retrieve those MPegs. Here is the example code. <TABLE BORDER> <?MISQL SQL="select * from commercial order by id_com;"> $(IF,$(AND,$(<,$begin,$MI_CURRENTROW),$(>=,$end,$MI_CURRENTROW)), <TR> <TD><IMG SRC=$WEB_HOME?LO=$7&type=image/gif width=144 height=114></TD> <TD><B>$(upper,$2)</B><BR> <A HREF="$WEB_HOME?LO=$6&MItypeObj=video/mpeg">$3</A><BR> $4 sec<BR> $5 Mb</TD> </TR>) <?/MISQL> </TABLE BORDER> My output is fine. It retreives one row of records and displays them in the following format: ******** ****** *$7 * *$2 * *Image * *$3 * * * *$4 * * * *$5 * ******** ****** Now I want two records to be displayed in one row. In the manual it says I should use [x] to define the second recordoutput. But this does not seem to work with Large_Objects, for I get an Illustra server error when using something like: <IMG SRC=$WEB_HOME?LO=$7[2]&type=image/gif width=144 height=114> **** Suggestions anyone?? A big thanks from Peter