Re: ILLUSTRA and WebDataBlade (pb with MIVAR an MISQL) ?
Posted in 1997
Antonio J. Salerno, Jr. — — source: Informix-list mailing list archive (1991-1998)
Olivier FERNANDEZ <ofernandez@icor.fr> emitted: >>Hello, >> >>How could assign a result from an SQL REQUEST to an MIVAR variable. >> >>(MI tags can't be encapsluled ??? so ...) >>Thanks... I'm not at work, so I can't check, but I'm pretty sure that I have done the following (minus error checking and MI_ROWCOUNT checking): If you are getting back more than one row: <?MISQL SQL="select * from junk;"> $(SETVAR,$VAR1,$1)... <?/MISQL> If you know you are getting back only 1 row: <?MISQL SQL="select * from junk;"> <?/MISQL> <?MIVAR NAME=$VAR1>$1<?/MIVAR> ... Tony remove "NO" and "SPAM" from my e-mail address to respond. _______________________ Antonio J. Salerno, Jr. asalerno@monmouth.com