Interesting a spooky. Try to use different cursor types. As you know, ADO, or better said, OLE DB behaves (or misbehaves) depending on the cursor. Have you tried a FORWARD and READ ONLY cursor.
Good Luck --- "Menard, Inc. Information Systems" <[EMAIL PROTECTED]> wrote: > Evening > > I think I'm losing my mind. I have a very simple > query that works fine in > MySQLFront but will not work when I connect using > ADO: > > select booger, count(*) from nose group by booger > > If I try the above query with one record It works > fine. Once I try it with > more records, nothing returns. > > If I try: > select booger from nose group by booger > It returns results with one or more records. > > Thanks for all of your help! > > Jake > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list > archive) > > To request this thread, e-mail > <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > __________________________________________________ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
