Re: IUS HTML Serial Value

Hi, I use this solution: (assuming that the serial column name is called 'id'.) ... <?MISQL SQL="SELECT id FROM mytab WHERE id=dbinfo('sqlca.sqlerrd1');"><?/MISQL> <?MIVAR NAME=id>$1<?/MIVAR> Cheers, Jozsef Rick Ward wrote: > 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.