RE: CF5 to CFMX - cfif breaks

2005-02-02 Thread Earl, George
I said: > The following cfif has been working fine in CF5 for 3 years > but it breaks in > MX 6.1 with updater (we are just now migrating CF5 to MX, so > I don't know if > it would have worked in MX or MX 6.1 pre updater . . .): > > >and trim(code) is not "W8" > and trim(code

Re: CF5 to CFMX - cfif breaks

2005-02-01 Thread Rebecca Wells
Exactly. The way this is written, the cfif statement could still execute even is the code = "W8" or "W12" if RS1 is not defined. >It looks to me like there is a parentheses missing or something, >depending on what RS1 is. Maybe MX places different priority on the >comparisons. I would think the

RE: CF5 to CFMX - cfif breaks

2005-02-01 Thread Dave Watts
> I figure this is an ODBC vs. JDBC issue . . . > > The following cfif has been working fine in CF5 for 3 years > but it breaks in MX 6.1 with updater (we are just now > migrating CF5 to MX, so I don't know if it would have worked > in MX or MX 6.1 pre updater . . .): > > >and tri

Re: CF5 to CFMX - cfif breaks

2005-02-01 Thread Bud
>I figure this is an ODBC vs. JDBC issue . . . > >The following cfif has been working fine in CF5 for 3 years but it breaks in >MX 6.1 with updater (we are just now migrating CF5 to MX, so I don't know if >it would have worked in MX or MX 6.1 pre updater . . .): > > > and trim(code) is no