Re: [Mysql-cocoa-users] count(*)

[Aaron J. <aj...@ed...>]

Perhaps make your query something like:

SELECT COUNT(*) AS rowCount;

Then use something like:

NSNumber rowCount = [[result fetchRowAsDicitonary] 
objectForKey:@"rowCount"];


Aaron



On Aug 2, 2004, at 2:33 PM, John Spicer wrote:

> I'd like to use this to get the number of rows in a table. But there 
> does not seem to be an easy way with this API.
>
> What are other people doing?
>
> This is what is returned by the connection (MCPResult):
>
> MCPResult: (encoding : 5, dim 1 x 1)
> count(*)
> 0
>
> It's that zero that I want! How do I get it?
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by OSTG. Have you noticed the changes on
> Linux.com, ITManagersJournal and NewsForge in the past few weeks? Now,
> one more big change to announce. We are now OSTG- Open Source 
> Technology
> Group. Come see the changes on the new OSTG site. www.ostg.com
> _______________________________________________
> Mysql-cocoa-users mailing list
> Mys...@li...
> https://lists.sourceforge.net/lists/listinfo/mysql-cocoa-users