Do you have a non-Witango ODBC client that you can use to run the same SQL expression? It might help narrow down the source of the problem. Just make sure that it is using the same ODBC data source.
Hope this helps, Steve Smith Oakbridge Information Solutions Office: (519) 624-4388 GTA: (416) 606-3885 Fax: (519) 624-3353 Cell: (416) 606-3885 Email: [EMAIL PROTECTED] Web: http://www.oakbridge.ca > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Web Dude > Sent: December 17, 2002 10:54 AM > To: Multiple recipients of list witango-talk > Subject: RE: Witango-Talk: Wierd > > > Sorry... > > SQL 7 - latest sp's on a separate server NT 4.0 sp6a > > I am currently weeding out duplicate entries in the customer table. > > >Did you mention what you are using for a database server? > > > >Please let us know. > > > >Thanks, > > > >Steve Smith > > > >Oakbridge Information Solutions > >Office: (519) 624-4388 > >GTA: (416) 606-3885 > >Fax: (519) 624-3353 > >Cell: (416) 606-3885 > >Email: [EMAIL PROTECTED] > >Web: http://www.oakbridge.ca > > > > > >> -----Original Message----- > >> From: [EMAIL PROTECTED] > >> [mailto:[EMAIL PROTECTED]]On Behalf Of Web Dude > >> Sent: December 17, 2002 10:13 AM > >> To: Multiple recipients of list witango-talk > >> Subject: Witango-Talk: Wierd > >> > >> > >> Witango 2000 > >> NT 4.0 > >> sp6a > >> IIS > >> > >> I have a customer table that has around 1600 records. It has around > >> 25 columns with various info (last name, address, ship address, > >> phone, etc.). > >> > >> When I build a search and search for all records, Witango bombs. It > >> takes up 100% of the CPU and just spins. I have taken this exact same > >> search and search a different customer table (Same columns different > >> database) with only around 350 records, and it works fine. If I click > >> off the get total rows it works fine, but of course I cannot scroll > >> to next or previous pages. It is almost as if Witango can't take the > >> return of all the rows in the list. > >> > >> I have tried building a simple search with multiple page results > >> searching for just the last name and I get the same result. Bomb > >> City. Is it possible that the returning list is too large? And is > >> there a place I can go to fix this? > >> > >> First time I have ever encountered something like this. Could the > >> Table be corrupt. Is there something in the config I need to adjust? > >> > >> Thanks... > >> -- > >> > ________________________________________________________________________ > >> TO UNSUBSCRIBE: send a plain text/US ASCII email to > [EMAIL PROTECTED] > >> with unsubscribe witango-talk in the message body > >> > >> > >________________________________________________________________________ > >TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > > with unsubscribe witango-talk in the message body > > > -- > ________________________________________________________________________ > TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body > ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
