Re: Witango-Talk: DBMS Action Select with Limit # or Rows

[Customer Support]

As this is R:Base specific it may be worth contacting R:Base to see  
what is happening in the db/ODBC driver.   The issue may lie in the  
Oterro 3 driver.  065 introduced a strict ODBC 3.0 interface.   058  
used an ODBC 2 interface to make db calls.  Oterro prior to version 3  
only supported ODBC 2.5 calls.  Try placing a trace on the db and the  
ODBC dm to see what sql it is executing.  Are they different?

If anyone is experiencing this with other dbs can they let us know.

On 10/03/2004, at 7:22 AM, Fogelson, Steve wrote:

Thanks Bill. I thought something was up here.

Steve

-----Original Message-----
From: Bill Downall [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 09, 2004 10:38 AM
To: [EMAIL PROTECTED]
Subject: RE: Witango-Talk: DBMS Action Select with Limit # or Rows
A followup:

This definitely was broken in Witango server 5.0 after patch .58 and  
before
patch .65.  I have a site still running on .58. A taf that observes the
limit and pages groups of 40 just fine in .58 puts the whole result  
set on
the page on a server running .65.

I'll send the example tafs to Fergal at Witango.

Bill

At 11:07 AM 3/9/2004, you wrote:
Steve,

This is quite weird! I went to look at my taf that does this just  
fine,
and it doesn't do this just fine anymore!

I have a taf that pages in 50s, and has been working great this way  
with
next/previous buttons and your configuration as below,  except that  
at the
client site is is Oterro 2.6, on my development system it is Oterro
3.0.  But now, it is not breaking where it should the buttons compute
correctly, but it tries to assemble all 1032 on the first page.

The only thing that has changed since this worked was my installing
Witango server .65 over .58 that had been running there!
Bill

At 09:30 AM 3/9/2004, you wrote:
Bill & Jason,

Windows 2003 Web Edition, R:Tango version 5, Oterro 3.0 update 3

Yes this used to work correctly for me with R:Tango 2000 as well.  
When I
upgraded to version 5 is when it changed.

I just tried using a search builder for a test, used the default of  
20 for
"Limit to" and it listed 28 rows. Display below.

There are 28 matching records.

Displaying matches 1 through 28.

With the "Next 8 Matches" submit button after the list of urls.

Thanks


______________________________________________________________________ 
__
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf


_______________________________________________________________________ 
_
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
_______________________________________________________________________ 
_
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf



________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf