web datablade and databases
Can I refer to tables outside the web datablade page database in embedded sql queries?. It doesn't let me do that. Can i have webpages in another database different from the webdb database? <A HREF=http://ict2.pue.udlap.mx/cgi-bin/wd/webdriver?MIval=firstpage&MI_DATABASE?$ > maybe it is not easily seen, but this says-----> MI_DATABASE=lac2@ict when i follow this link it gives me this error: Exception from Informix: X42000:-206:Base table not found the web.cnf is like this: # Webdaemon Specific Variables MI_DATABASE? webdb MI_USER dbclient MI_PASSWORD <> <-------- obviously there's a pwd here # MI_WEBDRVLOG /tmp/.log MI_WEBDRVLEVEL 0x0002 INFORMIXDIR /export/home/sw/informix INFORMIXSERVER ict2 # Webdriver Specific Variables MInam ID MIcol object MItab? webPages MIval? apb MI_WEBSHOWEXCEPTIONS on # MI_WEBRAWPASSWORD <your_password_here> WEB_HOME http://ict2.pue.udlap.mx/cgi-bin/wd/webdriver REMOTE_USER default i don't know if i can override MI_DATABASE, as you can see it has the ? mark, but it doesn't make any change if i do it. the web page source is: <HTML> <HEAD><TITLE>Prueba</TITLE></HEAD> <BODY> <?MIVAR NAME=$QUERY>select ID from webPages;<?/MIVAR> <TABLE BORDER> <?MiSQL SQL=$QUERY> <TR>{<TD>$*</TD>}</TR> <?/MiSQL> </TABLE> <?MiBLOCK COND=$(EQ,$MI_DATABASE,lac2)> <TABLE BORDER> <?MiSQL SQL="select * from profesor;"> <TR>{<TD>$*</TD>}</TR> <?/MiSQL> <?/MiBLOCK> <BR> <A HREF=http://ict2.pue.udlap.mx/cgi-bin/wd/webdriver?MIval=firstpage&MI_DATABASE?=lac2&MItab?=profesor>siguiente</A>; </BODY> </HTML> ____roberto dircio palacios macedo__________________________________ __ | | /\\_\\__ | Interactive and | http://ict.udlap.mx/people/roberto \\/_/\\_\\ | Cooperative | tel:(22)292431 /\\_\\/_/ | Technologies Lab. | mail: is092756@cca.pue.udlap.mx \\/_/ ict | UDLA-P, Mexico. | __________|____________________|____________________________________
Try using a synonym in your database to the desired table in the other database. Cheers, Frank Roberto Dircio Palacios-Macedo wrote in message <7afus2$b81$1@news.xmission.com>... > > > Can I refer to tables outside the web datablade page database in embedded >sql queries?. It doesn't let me do that. Can i have webpages in another >database different from the webdb database? > ><A >HREF=http://ict2.pue.udlap.mx/cgi-bin/wd/webdriver?MIval=firstpage&MI_DATAB ASE?$ >> >maybe it is not easily seen, but this says-----> MI_DATABASE=lac2@ict > >when i follow this link it gives me this error: > >Exception from Informix: X42000:-206:Base table not found > >the web.cnf is like this: > ># Webdaemon Specific Variables > MI_DATABASE? webdb > MI_USER dbclient > MI_PASSWORD <> <-------- obviously there's a pwd here > # MI_WEBDRVLOG /tmp/.log > MI_WEBDRVLEVEL 0x0002 > > INFORMIXDIR /export/home/sw/informix > INFORMIXSERVER ict2 > ># Webdriver Specific Variables > MInam ID > MIcol object > MItab? webPages > MIval? apb > > > MI_WEBSHOWEXCEPTIONS on > # MI_WEBRAWPASSWORD <your_password_here> > > WEB_HOME http://ict2.pue.udlap.mx/cgi-bin/wd/webdriver > REMOTE_USER default > > >i don't know if i can override MI_DATABASE, as you can see it has the ? >mark, but it doesn't make any change if i do it. > > >the web page source is: > ><HTML> ><HEAD><TITLE>Prueba</TITLE></HEAD> ><BODY> ><?MIVAR NAME=$QUERY>select ID from webPages;<?/MIVAR> ><TABLE BORDER> ><?MiSQL SQL=$QUERY> ><TR>{<TD>$*</TD>}</TR> ><?/MiSQL> ></TABLE> ><?MiBLOCK COND=$(EQ,$MI_DATABASE,lac2)> ><TABLE BORDER> ><?MiSQL SQL="select * from profesor;"> ><TR>{<TD>$*</TD>}</TR> ><?/MiSQL> ><?/MiBLOCK> ><BR> ><A >HREF=http://ict2.pue.udlap.mx/cgi-bin/wd/webdriver?MIval=firstpage&MI_DATAB ASE?=lac2&MItab?=profesor>siguiente</A> ></BODY> ></HTML> > > > >____roberto dircio palacios macedo__________________________________ > __ | | > /\\_\\__ | Interactive and | http://ict.udlap.mx/people/roberto > \\/_/\\_\\ | Cooperative | tel:(22)292431 > /\\_\\/_/ | Technologies Lab. | mail: is092756@cca.pue.udlap.mx > \\/_/ ict | UDLA-P, Mexico. | >__________|____________________|____________________________________
I don't think you can override MI_DATABASE, but something like <?MISQL SQL="SELECT c.id, d.id FROM DBNAME1@DBSERVER:yourtable c, DBNAME2@DBSERVER:yourtable d where c.id = d.id order by 1,2;"><TR><TD>$1</TD><TD>$2</TD></TR><?/MISQL> might. Tony Roberto Dircio Palacios-Macedo <is092756@cca.pue.udlap.mx> emitted: >> >> >> Can I refer to tables outside the web datablade page database in embedded >>sql queries?. It doesn't let me do that. Can i have webpages in another >>database different from the webdb database?