Re: Universal Server - multiple inserts from an AppPage

I have. We had the same problem during our port early last year and when you select multiple items on the html form, our perl NSAPI parser would validate then cat all of the values together and delimit them with ':;:'. Since Id rather use C than SPL, I wrote a C routine that goes in and tokenizes (strips out the ':;:') the input and then inserts the input to the database. The C routine gets compiled into a shared object library (.so) that is loaded by IUS when needed. You call the C routine (function if it returns back a value, procedure if not) from an MISQL tag after the routine had been registered to the DB server. The C call that tokenizes a string is strtok (or strtok_r to be MT safe). Thomas Tatum 919-767-2129 -----Original Message----- From: Alison Evans <Alison.Evans.aevans@nt.com> To: 'informix_list' <informix-list@iiug.org> Date: Wednesday, April 22, 1998 6:40 PM Subject: Universal Server - multiple inserts from an AppPage >Hello - > >I'm currently trying to port an Illustra web application to the Universal >Server. Things are going surprisingly well - but I've run into a wall. > >With our Illustra web app, we had forms with elements that would take >multiple selections. ( For example, a group of checkboxes, a list box, >etc.) To insert the results into the database, we would use the MIEXEC tag >and run a perl script that created a suitable load file, and just copy it >into the appropriate table. I can't seem to duplicate this approach with >the Universal Server. I've tried the exact approach - using "load" instead >of "copy" from a MISQL tag. But kept getting syntax errors. I've tried a >few other things (mainly different ways of accessing the database via >os-calls) none of which seem to work - and all of which are just way >convoluted. > >Does anyone have any experience with this? > >Thanks! > >Alison Evans >aevans@nortel.ca > >