RE: Web Datablade Language Gotcha

I'm finding the same with the version 4 blade, at the top of the HTML I now just make sure all variables are set, but I tend to used a NXST test to avoid over writing variable passed through. Paul Watson # WFSoftware Ltd # Things Are Going to Tel: +44 1436 674729 # Get a Lot Worse Fax: +44 1436 678693 # Before Things Get Worse www.wfsoftware.com/informix # -----Original Message----- From: Thomas Tatum [mailto:ttatum@koz.com] Sent: Tuesday, April 18, 2000 6:44 PM To: Ius-Users@Iiug. Org; informix-list@iiug.org Subject: Web Datablade Language Gotcha I wanted to pass along a discovery we have made here in the last few weeks about Web Datablade syntax and stablilty: The following type of web datablade code: <?MISQL SQL="some sql that returns a single value here;"><?/MISQL> <?MIVAR NAME=$test>$1<?/MIVAR> <?MISQL SQL="execute function webexplode($test,'');">$1<?/MISQL> where the variable is assigned outside of the misql tag works fine under: INFORMIX-Universal Server Version 9.14.UC6 web.3.32.UC4 but has stability problems under: Informix Dynamic Server 2000 Version 9.20.UC2 web.3.32.UC4 when the db server is under heavier load. Informix has repeated the problem and recommends you do something like the following to work around it: <?MIVAR NAME=$test DEFAULT=NULL><?/MIVAR> <?MISQL SQL="some sql that returns a single value here;">$(SETVAR,$test,$1)<?/MISQL> <?MISQL SQL="execute function webexplode($test,'');">$1<?/MISQL> Thomas Tatum http://www.koz.com/ 919.767.2129