Hi Frank

thanks for the reply.

so if i am correct in interpreting your reply, it *is* a
good idea to generate a unique number to <dbUnit>, unless
in certain cicumstances, it is preferable to use the
same objec/unitid.

could you give a yes or no answer to that please ?

kind regards
beez

------------
Frank Kwong at 8/13/00 9:54:27 AM

It is a good idea NOT to re-use the dbUnit. But, somtimes you want to generate different objects (e.g. a grid and it&#39;s corresponding chart) using the same object to save a bit of performance. Therefore, you&#39;ll need to reset a few properties and re-execute ASPDB. Further more , you need this user controlled user ID to place the objects onto the template. This dbUnit is also the key in doing somthing like data warehousing where objects (grid, chart,blocks, sboxes etc..) are generated from different data sources and then placed onto the template.

FK


------------
beez at 8/12/00 3:22:12 AM


Hi Mark

first off thank you very much for the prompt reply.
second, had forgotten about the dbReset() and that
sounds spot on!
thrid, had already guessed about your first point about
having a unique id on each page, and unique variable name;
which i don&#39;t have, tut tut!!
fourth, the inconsistent behaivour, was too elaborate
to explain; needless to say, that in the particular page,
one of the 6 ASPDB objects was behaving like a previous
instance of the page; hence my guess about the variable
names and unique id&#39;s.

Q. what do you think about &#34;generating&#34; the unique id,
using a random generator, say based on the timestamp ?
that way one could guarantee the uniqueness ?
although, what random genertor is ever truly random ?

Finally, i&#39;d like to say that, in 11 years of being a
contractor, i have never seen a piece of software that
has as yet to deliver what it promises; ASPDB is the
exception to that dismal record; and you can quote
me on that.

kind regards
beez


------------
Mark at 8/11/00 1:59:43 PM

Hi &#34;Beez&#34;

Things to look for:

1) Be sure that every page has a unique dbUnit number.
2) If your dbSQL statement ever changes (like if you use a variable in the WHERE clause) you MUST do a dbReset(). This forces a re-read (and re-count) of the database. We have examples on-line that show how to do this.
3) You didn&#39;t say what the inconsistent behavior looks like. Knowing that could help a lot.

Thanks.

Mark.

------------
beez at 8/10/00 10:22:42 PM


Hi All

i have about 7 asp files that have ASPDB code in them;
when i first open Expolrer to test them, everything is
fine. after a while however, with the SAME data and
the same behaivour (i.e. pressing the same buttons) i
get inconsistent behaivour, which i am almost 100% sure
is due to existing objects in the cache.

I am using different id&#39;s and object variable names;

any help would be welcome