[Mysql-cocoa-users] find replace strings
Brought to you by:
sergecohen
From: Patel, N. M <Nil...@qu...> - 2004-08-06 14:04:33
|
I have a string going into mysql database and I need away to invoke a = specific character for example a plus sign (+) everytime a user enters = a= + character. Having even number of (+) would not crash my app. Does = anyone know a method that I can implement that will allow me to invoke = an extra charcter (+) everytime it is entered.=20 Assumption: (+) is not alwasy entered. =20 Thanks. -----Original Message----- =46rom: mys...@li... [mailto:mys...@li...]On Behalf Of mys...@li... Sent: Monday, August 02, 2004 11:35 PM To: mys...@li... Subject: Mysql-cocoa-users digest, Vol 1 #116 - 2 msgs Send Mysql-cocoa-users mailing list submissions to mys...@li... To subscribe or unsubscribe via the World Wide Web, visit https://lists.sourceforge.net/lists/listinfo/mysql-cocoa-users or, via email, send a message with subject or body 'help' to mys...@li... You can reach the person managing the list at mys...@li... When replying, please edit your Subject line so it is more specific than "Re: Contents of Mysql-cocoa-users digest..." Today's Topics: 1. count(*) (John Spicer) 2. Re: count(*) (Aaron Jacobs) --__--__-- Message: 1 To: mys...@li... =46rom: John Spicer <joh...@hw...> Date: Mon, 2 Aug 2004 14:33:13 -0500 Subject: [Mysql-cocoa-users] count(*) I'd like to use this to get the number of rows in a table. But there=20 does not seem to be an easy way with this API. What are other people doing=3F 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=3F --__--__-- Message: 2 =46rom: Aaron Jacobs <aj...@ed...> Subject: Re: [Mysql-cocoa-users] count(*) Date: Mon, 2 Aug 2004 14:35:47 -0500 To: John Spicer <joh...@hw...>, mys...@li... Perhaps make your query something like: SELECT COUNT(*) AS rowCount; Then use something like: NSNumber rowCount =3D [[result fetchRowAsDicitonary]=20 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= =20 > does not seem to be an easy way with this API. > > What are other people doing=3F > > 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=3F > > > > ------------------------------------------------------- > This SF.Net email is sponsored by OSTG. Have you noticed the changes = on > Linux.com, ITManagersJournal and NewsForge in the past few weeks=3F = Now, > one more big change to announce. We are now OSTG- Open Source=20 > 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 --__--__-- _______________________________________________ Mysql-cocoa-users mailing list Mys...@li... https://lists.sourceforge.net/lists/listinfo/mysql-cocoa-users End of Mysql-cocoa-users Digest =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D The contents of this message, together with any attachments, are = intended only for the use of the person(s) to which they are addressed = and may contain confidential and/or privileged information. Further, an= y= medical information herein is confidential and protected by law. It is= = unlawful for unauthorized persons to use, review, copy, disclose, or = disseminate confidential medical information. If you are not the = intended recipient, immediately advise the sender and delete this = message and any attachments. Any distribution, or copying of this = message, or any attachment, is prohibited. =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D |