Limited number of DB records returned with 2.02

[Sarah]

With MySQL and Rev 2.0.2, revDatabaseColumnNamed and 
revDatabaseColumnNumbered both work fine.

Sarah

On Wednesday, July 30, 2003, at 12:22  pm, Chris Sheffield wrote:

> I think other database functions are not working
> correctly either.  I've been working with Valentina
> for several months now and not had any problems.  When
> I updated to 2.0.2, suddenly the
> revDatabaseColumnNamed function is not working.  It
> just returns garbage.  I have verified that the data
> is in fact in my database by accessing it from 2.0.1.
> Still works perfectly.  I'd be curious as to whether
> or not others are experiencing similar problems.
>
> Chris Sheffield
>
> --- Sarah <sarahr at genesearch.com.au> wrote:
>> This morning I just got my license code for 2.0.2 so
>> I have downloaded
>> and tested it. I get the same problems with DB
>> access: the correct
>> number of records is reported but after 22, they
>> just repeat. In fact,
>> because the move to next record code seems to be
>> broken, it never
>> reaches the end so my test stack gets stuck in an
>> infinite loop. Then
>> when I command-period to stop it, the cursor doesn't
>> get closed so next
>> time I try to connect, I get a "restricted under
>> current license"
>> error, which is what happens if you don't close
>> cursors when you have
>> finished with them. GRRRR.
>>
>> However, the same stack, connecting to exactly the
>> same database but
>> using Rev 2.0.1 works perfectly.
>>
>> I built a query using the Database Query Builder in
>> Rev 2.0.2 and it
>> works fine. It returns all my records (33 in my test
>> DB) without
>> duplicating. So it looks like there is something
>> wrong in the
>> revMoveToNextRecord routine.
>>
>> Workaround:
>> Instead of starting at record 1 and looping through
>> each record from
>> start to finish, I jumped to the last record and
>> looped backwards. This
>> worked perfectly! I'll update MySQL tests.rev and
>> upload it to handle
>> this error.
>>
>> Cheers,
>> Sarah
>> sarahr at genesearch.com.au
>> http://www.troz.net/Rev/
>>
>> P.S. Joel: I tried to respond to your email but my
>> reply bounced. If
>> you have another email address for me to try, please
>> email me again.
>>
>> _______________________________________________
>> use-revolution mailing list
>> use-revolution at lists.runrev.com
>>
> http://lists.runrev.com/mailman/listinfo/use-revolution
>
>
> =====
> Chris Sheffield
> Read Naturally
> www.readnaturally.com
>
> __________________________________
> Do you Yahoo!?
> Yahoo! SiteBuilder - Free, easy-to-use web site design software
> http://sitebuilder.yahoo.com
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> http://lists.runrev.com/mailman/listinfo/use-revolution
>
>
>