List:General Discussion« Previous MessageNext Message »
From:Barry Date:June 10 1999 8:33pm
Subject:Re: COUNT() - Thanks everyone
View as plain text  
Hello All,

Thanks for your help. Using Delphi's TmySQL shielded me from rows with
column numbers by providing GetFieldByName().

I made the following little test and can now see exactly where "OneRow[0]"
came from.

 :-) :o) :+) :o) :-)  (very happy)

Thanks,
Barry.

-------------------

mysql> use authdb
Database changed
mysql> select * from testselect
    -> go
+-----+
| Num |
+-----+
|   1 |
|   2 |
|   3 |
|   4 |
|   5 |
+-----+
5 rows in set (0.00 sec)

mysql> select count(*), max(num) from testselect
    -> go
+----------+----------+
| count(*) | max(num) |
+----------+----------+
|        5 |        5 |
+----------+----------+
1 row in set (0.00 sec)


Thread
COUNT()Net-Lynx10 Jun
Re: COUNT()Jorge Santos10 Jun
  • Re: COUNT() - Explain pleaseBarry10 Jun
    • Re: COUNT() - Explain pleasePaul DuBois10 Jun
      • Re: COUNT() - Thanks everyoneBarry11 Jun
Re: COUNT() - Explain pleaseJim Faucette10 Jun