Re: IUS HTML Serial Value

I have found this doesn't work, I get the error message: Exception from Informix: XUWEB1:-937:Undefined variable:$MI_OID Any more clues ? Rick. Dmitry Belochkin wrote: > Is not there MI_OID variable, that contain object ID inserted row. > Try this: > > <?MISQL SQL="insert into mytab values (0,'hello');"> > <?/MISQL> > <?MIVAR > NAME=last_serial_val>$MI_OID<?/MIVAR> > > At least, it was in Web Blade version 2.2. > > > Informix: 9.12.uc1 > > Blade: web.3.30.uc6 > > > > In my HTML page, can I retrieve the value of the last serial insert just > > made ? > > > > IE: > > > > <?MISQL SQL="insert into mytab values (0,'hello');"> > > <?/MISQL> > > > > where the table has a serial value for the first column. > > > > What I then wish to do is: > > > > <?MIVAR > > NAME=last_serial_val>$something-or-other-to-get-me-the-serial-value-just-inserted</?MIVAR> > > > > etc > > > > Can this sort of thing be done ?? > > > > Cheers, > > > > Rick. > > > > -- > > Rick Ward > > Senior DBA > > Great Universal Stores Home Shopping > > MANCHESTER, UK > > > > All views and comments in this e-mail are expressed by myself only, and > > are not necessarily representative of my employer, Great Universal > > Stores. > > > > > > -- > Dmitry V. Belochkin phone: +7 8452 512828 > INTERCOM Company, Saratov http://www.intercom.ru/~db -- Rick Ward Senior DBA Great Universal Stores Home Shopping MANCHESTER, UK All views and comments in this e-mail are expressed by myself only, and are not necessarily representative of my employer, Great Universal Stores.