Re: query of variables in a Illustra table

In article <3403c707.1351242@news.eunet.be>, Eddy.DeClercq@coi.be (Eddy De Clercq) writes: > > We have a table with name of variables in it. We write a query for it > (in a illustra web datablade), we get the name of the variable instead > of the wanted value. > > <?MiSQL SQL="select K_NR from EG;"> > $1 > <?/MiSQL> > > K_NR is the name of the variable, but we want to show the contents of > it. OK, here's the answer to what I think your question is: <?MISQL sql="select WebExplode('$$' || K_NR,'') from EG;"> $1 <?/MISQL> This assumes that you just have the variable name stored in K_NR, without the dollar sign. -- Peter Haworth pmh@edison.ioppublishing.com Take off all your clothes and walk down the street waving a machete and firing an Uzi, and terrified citizens will phone the police and report: "There's a naked person outside!" - Mike Nichols