Home > Archive > dBASE Web Applications > April 2005 > unusual glitch









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author unusual glitch
Dan Anderson

2005-04-04, 8:03 pm

I have a program (db+) that has been working for quite some time. Last
Thursday everything seemed to change. This is dBase CGI web application.
Now when I try to sign in I get the following error message:
Error Code: 167

Error: Variable undefined: VALUE

Source File: D:\htdocs\ubiquote\p
ublic\cgi-bin\WebClass.cc

Routine: CGISESSION::LOADARRA
YFROMFIELDS

Line: 656

Does anyone have a clue what's wrong, what it really wants or how to fix
this mess?


--
Dan Anderson
UBI Processing Dept.
andersond@ubinc.com
800-444-4824 ext 101


Michael Nuwer [dBVIPS]

2005-04-04, 8:03 pm

Dan Anderson wrote:
> I have a program (db+) that has been working for quite some time. Last
> Thursday everything seemed to change. This is dBase CGI web application.
> Now when I try to sign in I get the following error message:
> Error Code: 167
>
> Error: Variable undefined: VALUE
>
> Source File: D:\htdocs\ubiquote\p
ublic\cgi-bin\WebClass.cc
>
> Routine: CGISESSION::LOADARRA
YFROMFIELDS
>
> Line: 656
>
> Does anyone have a clue what's wrong, what it really wants or how to fix
> this mess?
>
>



Looks like a bug in WebClass.cc. The following includes line 656.

elseif rf[cKey].type = 'DATE'
this[cKey] = dtoc(value)

elseif rf[cKey].type = 'LOGICAL'
this[cKey] = iif(value,'TRUE','FA
LSE')


Change the above to the following. Notice that the DATE files contains
the same bug as the Logical field, so you should fix both:

elseif rf[cKey].type = 'DATE'
this[cKey] = dtoc(rf[cKey].value)

elseif rf[cKey].type = 'LOGICAL'
this[cKey] = iif(rf[cKey]. value,'TRUE','FALSE'
)


--
Michael Nuwer
http://www.nuwermj.potsdam.edu/dLearn/
http://www.nuwermj.potsdam.edu/dSamples/
Claus Mygind

2005-04-04, 8:03 pm

It has been my experience that everything you send to the WebClass.cc must
be a string. So I just convert dates and numbers to string values like
dtoc(mydate) or str(mynumber,10,2) etc.

"Michael Nuwer [dBVIPS]" <nuwermj@nospam.please.yahoo.com> wrote in message
news:v0p95j5LFHA.432@news-server...
> Dan Anderson wrote:
>
>
> Looks like a bug in WebClass.cc. The following includes line 656.
>
> elseif rf[cKey].type = 'DATE'
> this[cKey] = dtoc(value)
>
> elseif rf[cKey].type = 'LOGICAL'
> this[cKey] = iif(value,'TRUE','FA
LSE')
>
>
> Change the above to the following. Notice that the DATE files contains the
> same bug as the Logical field, so you should fix both:
>
> elseif rf[cKey].type = 'DATE'
> this[cKey] = dtoc(rf[cKey].value)
>
> elseif rf[cKey].type = 'LOGICAL'
> this[cKey] = iif(rf[cKey]. value,'TRUE','FALSE'
)
>
>
> --
> Michael Nuwer
> http://www.nuwermj.potsdam.edu/dLearn/
> http://www.nuwermj.potsdam.edu/dSamples/



Dan Anderson

2005-04-04, 8:03 pm

You nailed the problem. When I made those changes everything worked. I
just wonder what happened in the first place. One day everything worked and
the next day it didn't.



--
Dan Anderson
UBI Processing Dept.
andersond@ubinc.com
800-444-4824 ext 101
"Claus Mygind" <cmygind@yahoo.com> wrote in message
news:AauDVv7LFHA.320@news-server...
> It has been my experience that everything you send to the WebClass.cc must
> be a string. So I just convert dates and numbers to string values like
> dtoc(mydate) or str(mynumber,10,2) etc.
>
> "Michael Nuwer [dBVIPS]" <nuwermj@nospam.please.yahoo.com> wrote in
> message news:v0p95j5LFHA.432@news-server...
>
>



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com