Re: Which DB/Software suite combo is best for Web<->DB implementation

I said: > > Don't even think about Informix's web datablade. Thomas Tatum wrote: > I disagree. Validating a date in Informix Web-Datablade tags. This resembles no language I ever heard of, except maybe RPG. But not really. <?MIBLOCK COND=$(EQ,$MMI_VALID,TRUE)> <?MIVAR NAME=MMI_VALDATE>TRUE<?/MIVAR> <?MIVAR COND=$(NOT,$(ISINT,$year_date_birth))NAME=MMI_VALID>FALSE<?/MIVAR> <?MIVAR COND=$(ISINT,$year_date_birth)>$(IF,$(<,$year_date_birth,1900),$(SETVAR,$MMI_VALID,FALSE))<?/MIVAR> <?MIVAR COND=$(NOT,$(ISINT,$month_date_birth)) NAME=MMI_VALID>FALSE<?/MIVAR> <?MIVAR COND=$(ISINT,$month_date_birth)>$(IF,$(<,$month_date_birth,1),$(SETVAR,$MMI_VALID,FALSE))<?/MIVAR> <?MIVAR COND=$(ISINT,$month_date_birth)>$(IF,$(NOT,$(<,$month_date_birth,13)),$(SETVAR,$MMI_VALID,FALSE))<?/MIVAR> <?MIVAR COND=$(NOT,$(ISINT,$day_date_birth)) NAME=MMI_VALID>FALSE<?/MIVAR> <?MIVAR COND=$(ISINT,$day_date_birth)>$(IF,$(<,$day_date_birth,1),$(SETVAR,$MMI_VALID,FALSE))<?/MIVAR> <?MIBLOCK COND=$(AND,$(ISINT,$day_date_birth),$(ISINT,$month_date_birth))> <?MIVAR COND=$(AND,$(<,0,$day_date_birth),$(<,$month_date_birth,13),$(<,0,$month_date_birth))> $(IF, $(<, $(NTH,$month_date_birth, 0,31, $(IF,$(=,$(/,$year_date_birth, 4),$(FIX,$(/,$year_date_birth, 4))), $(IF,$(=,$(/,$year_date_birth,100),$(FIX,$(/,$year_date_birth,100))), $(IF,$(=,$(/,$year_date_birth,400),$(FIX,$(/,$year_date_birth,400))), 29, 28), 29), 28), 31,30,31,30,31,31,30,31,30,31), $day_date_birth), $(SETVAR,$MMI_VALID,FALSE)) <?/MIVAR> <?/MIBLOCK> <?MIVAR COND=$(EQ,$MMI_VALID,FALSE)>$(SETVAR,$MMI_VALDATE,FALSE)<?/MIVAR> It took an embarrasing amount of effort to figure out to do this simple task. There are few if any resources 'out there' on how to do this kind of thing. In contrast, there are zillions of pages on cold fusion, php, etc etc. Another gripe I have is that each page is an atomic transaction. To select for update, or perform certain other kinds of operations, requires control over transaction boundaries. This is impossible with IUS/WEB-DB unless you queue a request to an external process with it's own session connection..... And the exception-handling is really cruddy. John