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

From: John Mullee <john_at_exmachina.net>
Date: 1999/04/13
Message-ID: <7f08mi$2s6$1_at_news.xmission.com>#1/1

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 Received on Tue Apr 13 1999 - 00:00:00 CEST