mysql-cocoa-users — The mysql-cocoa users mailing list

Re: [Mysql-cocoa-users] installing SMySQl under 10.2

[John G. <jo...@jl...>]

I am using it quite happily at the moment.

When I upgraded from 10.1 to 10.2 and now to 10.2.2 it simply continued 
to work automatically.

I haven't recompiled or re-installed it though.

The Framework is stored in my home folder in the ~/Library/Frameworks 
folder

One thing I have noticed since my upgrade (I think the 10.2.2 one) is 
that my command line mysql client is no longer functioning correctly so 
I suspect I may need to re-install  mysql at some point in the near 
future.

JOhn


On Sunday, November 24, 2002, at 07:25 AM, Camille Goureau-Suignard 
wrote:

> Hi is anybody using SMySQL with Jaguar ?
>
> Thanks.
>
> Camile
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Mysql-cocoa-users mailing list
> Mys...@li...
> https://lists.sourceforge.net/lists/listinfo/mysql-cocoa-users
>

[Mysql-cocoa-users] installing SMySQl under 10.2

[Camille Goureau-S. <sui...@wa...>]

Hi is anybody using SMySQL with Jaguar ?

Thanks.

Camile

[Mysql-cocoa-users] App Distribution

[Stuart <li...@sh...>]

I've just started learning Cocoa and have started a small MySQL-based 
project to help me learn it. The problem I have is in packaging it up 
for distribution. I want to give it to several friends for testing but 
I don't seem to be able to package the framework in the bundle so that 
it will work straight out of the email. Can someone please guide me or 
point me towards relevant documentation for distributing a framework 
with an app?

Thanks.

-- 
Stuart

[Mysql-cocoa-users] (no subject)

[Syphor <sy...@sp...>]

Dear List,
		I'm using the MySQL framework to connect to a mysql db. When I 
send a query to my db my result is in a type of hex. This is my code...

     SMySQLResult *newsResult = [[[SMySQLResult alloc] init] autorelease];
     NSArray *newsFields = [[[NSArray alloc] init] autorelease];

     newsResult = [newsConnection queryString:@"select * from test"];
     newsFields = [newsResult fetchRowAsArray];

     NSLog(@"%@", [newsFields objectAtIndex:0]);

the table test has (Bam text) so it should return text... though it 
returns a type of hex as the result... anyway here is the result:

<677468>

[Mysql-cocoa-users] Change to SMySQL

[Famille GOUREAU-S. <sui...@wa...>]

Hi,

I'm trying to add something to the source code :
if fetchRowAsDictionary encounter a null field, it places a NSNull item=20=

in the dictionary.
I put some NSLog to check the work.
I cleaned all target then build and run (=EF=A3=BFR)

But my own project (the one using SMySQL as framework) does not show the=20=

NSLogs).
I think that my project is still using an old version of the framework.
How can I check that ?

Thanks.

Camille

[Mysql-cocoa-users] NSNull

[Famille GOUREAU-S. <sui...@wa...>]

Hi,

has somebody modified the SMySQL source this way :
fetchRowAsDictionary send a NSNull instance when the DB had a null field.

Thanks.

Camille

[Mysql-cocoa-users] version 1 ?

[Famille GOUREAU-S. <sui...@wa...>]

Hi,

I've heard about a version 1 of SMySQL, but I can only find version 0.7 
on the web.
Where is my mistake ?

Thanks.

Camille

Re: [Mysql-cocoa-users] generating libmysqlclient.dylib

[Serge C. <co...@em...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi Nat;

Indeed the thing you have to do more likely (I don't have 10.2 so I'm 
not sure of what's up with this version of the system) is to apply the 
patch, and then go inside ltconfig and edit the line darwin5.* ... to 
have darwin6.* accepted as well.

Now for what is the use of the patch:
On Darwin dynamic libraries have their path hardcoded in the library at 
linking time (when the archive is made...). This was not handled 
properly by previous version of the ltconfig. On top of that it tries to 
prebind the library (execution time optimisation, more precisely 
launching opt. -If I properly understood-). The adress is either given 
in a file (setted by LD_SEG_ADDR_TABLE env var, see man ld, 
- -seg_addr_table), or on the command line with -seg1addr. Anyway having 
enabled the prebinding permit to redo_prebinding later, even if you 
don't want to give the adress right away.

Everything about prebinding is in ld and redo_prebinding man pages.

Hope that helps.

Serge.


> I haven't figured out how to create libmysqlclient.dylib when building
> MySQL from source. MySQL is built and runs fine. Any suggestions? I
> would much rather figure out how to generate this myself than use the
> precompiled version, because both my OS and my MySQL installation are a
> little unusual. I was under the impression that all I had to do was
> configure MySQL with --enabled-shared, but apparently I was mistaken. I
> see libmysqlclient.a in /usr/local/lib/mysql, but no dylib.
>
> As a subset of that question, I would appreciate understanding what the
> ltconfig patch mentioned in the RTF build instructions actually does. It
> appears to me that it will not have an effect on 10.2 (which has Darwin
> 6.0, while the patch only targets 5.*), but since I don't know what it's
> supposed to accomplish, I can't tell if that's a problem.
>
> Thanks very much.
>
>   -nat
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Mysql-cocoa-users mailing list
> Mys...@li...
> https://lists.sourceforge.net/lists/listinfo/mysql-cocoa-users
>
>
- ----------------------------------------------------
Serge Cohen

GPG Key ID: 1024D/69B1D346
- ----------------------------------------------------
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (Darwin)
Comment: For info see http://www.gnupg.org

iD8DBQE9UO2/Mygj1Wmx00YRAnn5AKCZeD+cW1wOFLRKvQtlXJIaYPXabQCfcNbG
sRRJY8p+s644mQC1GNwTv4Q=
=OyrC
-----END PGP SIGNATURE-----

[Mysql-cocoa-users] generating libmysqlclient.dylib

[Nathaniel I. <nd...@bu...>]

I haven't figured out how to create libmysqlclient.dylib when building
MySQL from source. MySQL is built and runs fine. Any suggestions? I
would much rather figure out how to generate this myself than use the
precompiled version, because both my OS and my MySQL installation are a
little unusual. I was under the impression that all I had to do was
configure MySQL with --enabled-shared, but apparently I was mistaken. I
see libmysqlclient.a in /usr/local/lib/mysql, but no dylib.

As a subset of that question, I would appreciate understanding what the
ltconfig patch mentioned in the RTF build instructions actually does. It
appears to me that it will not have an effect on 10.2 (which has Darwin
6.0, while the patch only targets 5.*), but since I don't know what it's
supposed to accomplish, I can't tell if that's a problem.

Thanks very much.

  -nat

Re: [Mysql-cocoa-users] Inserting and getting blobs

[Jerome R. <jer...@fn...>]

Thanks for your answers.

Now, I'm able to insert Images in my DB. Here is how I've done it (it 
may not be the best solution)

	MCPConnection	*connection;
	NSImage			*theImage;
	NSData			*representationOfTheImage;
	NSString			*stringToInsert;
	NSString			*insertQuery;
	......

	//The TIFFRepresentation method have an option to compress data, 
it's not used here, but it should
	representationOfTheImage = [ theImage TIFFRepresentation ];
	stringToInsert = [ connection prepareBinaryData: readData ];

	insertQuery = [ [ NSString alloc] initWithFormat: @"INSERT INTO 
PHOTO (PHOTO) VALUES (  \"%@\") ", stringToInsert ];

and then you just have to lauch the query .

About the size of blobs, I use longblob. When I started my tests, I used 
simple blobs, and when my data was big, it "seemed" to be inserted 
correctly in the DB (no error, and a simple select in the terminal 
showed me that line was inserted). But when I tried to get this blob 
with my tests, the program simply crashed (error 255).

I hope it could help if someone needs it.


Jerome Rabas.

Re: [Mysql-cocoa-users] Problems with null fields in version 2

[Jerome R. <jer...@fn...>]

After checking out the last version, all my tests are running perfectly: 
having null field in the database (either null field or date with 
0000-00-00) is not a problem anymore.

Thanks for your work, Serge.

Jerome.

Re: [Mysql-cocoa-users] Inserting and getting blobs

[Serge C. <co...@em...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

=0D
Indeed in the version-2 framework there is a prepareString: method, =0D
there is also a method to convert a NSData to a NSString using the =0D
encoding of the DB (stringWithText:); it's in both MCPConnection and =0D
MCPResult (as both these class hold an encoding informaion).=0D
=0D
The conversion method (prepareString:) prepare a string to be inserted =0D=

in a query, hence it will escape single and double quotes plus other =0D
things (based on the C API function mysql_real_escape_string).=0D
=0D
Indeed the prepareString already existed in version-1, but it was not =0D=

implemented in the same way (don't remember precise difference). the =0D
stringWithText: exist only in v-2.=0D
=0D
Serge.=0D
=0D
PS: the problem for the LONGTEXT, is that it's not recognised by the C =0D=

API, which does not make difference between TEXT and BLOBS. So far I =0D
don't have any thing to get the info if a column is TEXT or BLOB, so I =0D=

treat both as BLOB.=0D
If anyone experimented with C API, knows how to make the diff, tell me =0D=

I'll use it.=0D
=0D
=0D
Le mardi 23 juillet 2002, =E0 06:11 , John Guy a =E9crit :=0D
=0D
> I've been using a lot of BLOBs in my current test, mainly because =0D
> LONGTEXT are not supported yet and I have been inserting large text =0D=

> files and templates into my database.=0D
>=0D
> So what I have been doing is convert my NSString to NSData using the =0D=

> method of NSString, and then preparing my NSData back into a string to =
=0D
> insert in SQL.=0D
>=0D
> Actually I have a helper object that does the conversion and has the =0D=

> following method:=0D
>=0D
> -(NSString*)prepareString:(NSString*)sourceString=0D
> {=0D
>     // convenience method, it converts a string into an NSData=0D
>     // object then converts it back to an SQL safe string=0D
>     NSData* binData =3D [sourceString =0D
> dataUsingEncoding:NSASCIIStringEncoding=0D
> 				allowLossyConversion:YES];=0D
> 	=0D
>     return([dbConnection prepareBinaryData:binData]);=0D
> }=0D
>=0D
> and here is how it would be used in SQL=0D
>=0D
> NSString* sql =3D [NSString stringWithFormat:=0D
> 	@"INSERT INTO templates (ID, NAME, TEMPLATESET, TEMPLATE) =0D
> VALUES('%@', '%@', %@, '%@')",=0D
> 	    nextId, newName, newSet, [dbConnection =0D
> prepareString:templateContents]];=0D
>=0D
> if (res =3D [dbConnection runQuery:sql])=0D
> {=0D
> 	// All OK=0D
> }=0D
>=0D
> As Serge says, when you pull the blob back out of a query it arrives =
as =0D
> an NSData object so you just need to convert it back to your own =0D
> preferred type.=0D
>=0D
>=0D
> I hope this helps people.=0D
>=0D
> Serge, in future releases you may want to add a function like my =0D
> prepareString method since I use it all the time when inserting user =0D=

> provided data into the DB since they may provide characters that are =0D=

> not SQL safe.=0D
>=0D
> JOhn=0D
>=0D
> On Tuesday, July 23, 2002, at 04:07 PM, Serge Cohen wrote:=0D
>=0D
>> -----BEGIN PGP SIGNED MESSAGE-----=0D
>> Hash: SHA1=0D
>>=0D
>> Hello again;=0D
>>=0D
>> About blob the best is to put them in a NSData, use the method =0D
>> prepareBinaryData: from MCPConnection to transform it into a string =0D=

>> (you still should make the single quotes yourself) that you can =
insert =0D
>> into a query (obviously insert or update...).=0D
>>=0D
>> To get it back, it just should work ok. In a row, a blob is put in a =0D=

>> NSData; so you should be able to use directly as input to one o the =0D=

>> NSImage init method.=0D
>>=0D
>> Indeed I'm very interested on the result, I've done only a very small =
=0D
>> test on both inserting blob using NSData and prepareBinaryData:, and =0D=

>> getting a NSData from a DB blob.=0D
>>=0D
>> Serge.=0D
>>=0D
>>=0D
>> Le jeudi 18 juillet 2002, =E0 12:13 , Jerome Rabas a =E9crit :=0D
>>=0D
>>> Does anybody know how to insert/get blobs from the DB?=0D
>>>=0D
>>> My problem is that I have a NSImage and I want to insert its content =
=0D
>>> in the DB and, then, be able to get it.=0D
>>> What conversion should I do? (converting to NSData, and then?)=0D
>>>=0D
>>>=0D
>>> Thanks.=0D
>>>=0D
>>>=0D
>>> Jerome.=0D
>>>=0D
>>>=0D
>>>=0D
>>> -------------------------------------------------------=0D
>>> This sf.net email is sponsored by:ThinkGeek=0D
>>> Welcome to geek heaven.=0D
>>> http://thinkgeek.com/sf=0D
>>> _______________________________________________=0D
>>> Mysql-cocoa-users mailing list=0D
>>> Mys...@li...=0D
>>> https://lists.sourceforge.net/lists/listinfo/mysql-cocoa-users=0D
>>>=0D
>>>=0D
>> - ----------------------------------------------------=0D
>> Serge Cohen=0D
>>=0D
>> GPG Key ID: 1024D/69B1D346=0D
>> - ----------------------------------------------------=0D
>> -----BEGIN PGP SIGNATURE-----=0D
>> Version: GnuPG v1.0.6 (Darwin)=0D
>> Comment: For info see http://www.gnupg.org=0D
>>=0D
>> iD8DBQE9PXEmMygj1Wmx00YRAkXbAJ4ji6AwVd8WMrge5niUU9KPhdqJrgCeJ/6F=0D
>> tdinAH4SvLGJDYeCIzbxwRk=3D=0D
>> =3DrokP=0D
>> -----END PGP SIGNATURE-----=0D
>>=0D
>>=0D
>>=0D
>> -------------------------------------------------------=0D
>> This sf.net email is sponsored by:ThinkGeek=0D
>> Welcome to geek heaven.=0D
>> http://thinkgeek.com/sf=0D
>> _______________________________________________=0D
>> Mysql-cocoa-users mailing list=0D
>> Mys...@li...=0D
>> https://lists.sourceforge.net/lists/listinfo/mysql-cocoa-users=0D
>>=0D
>=0D
>=0D
>=0D
> -------------------------------------------------------=0D
> This sf.net email is sponsored by:ThinkGeek=0D
> Welcome to geek heaven.=0D
> http://thinkgeek.com/sf=0D
> _______________________________________________=0D
> Mysql-cocoa-users mailing list=0D
> Mys...@li...=0D
> https://lists.sourceforge.net/lists/listinfo/mysql-cocoa-users=0D
>=0D
>=0D
- ----------------------------------------------------=0D
Serge Cohen=0D
=0D
GPG Key ID: 1024D/69B1D346=0D
- ----------------------------------------------------=0D
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (Darwin)
Comment: For info see http://www.gnupg.org

iD8DBQE9PnvPMygj1Wmx00YRAhMCAJ0Qzrvcg6gZEmsfawo4eKHcFMG46ACeLnfE
85yie9vLmt9g4qbh69fawMc=3D
=3DFAch
-----END PGP SIGNATURE-----

Re: [Mysql-cocoa-users] Inserting and getting blobs

[John G. <jo...@jl...>]

I've been using a lot of BLOBs in my current test, mainly because=20
LONGTEXT are not supported yet and I have been inserting large text=20
files and templates into my database.

So what I have been doing is convert my NSString to NSData using the=20
method of NSString, and then preparing my NSData back into a string to=20=

insert in SQL.

Actually I have a helper object that does the conversion and has the=20
following method:

-(NSString*)prepareString:(NSString*)sourceString
{
     // convenience method, it converts a string into an NSData
     // object then converts it back to an SQL safe string
     NSData* binData =3D [sourceString=20
dataUsingEncoding:NSASCIIStringEncoding
				allowLossyConversion:YES];
=09
     return([dbConnection prepareBinaryData:binData]);
}

and here is how it would be used in SQL

NSString* sql =3D [NSString stringWithFormat:
	@"INSERT INTO templates (ID, NAME, TEMPLATESET, TEMPLATE)=20
VALUES('%@', '%@', %@, '%@')",
	    nextId, newName, newSet, [dbConnection=20
prepareString:templateContents]];

if (res =3D [dbConnection runQuery:sql])
{
	// All OK
}

As Serge says, when you pull the blob back out of a query it arrives as=20=

an NSData object so you just need to convert it back to your own=20
preferred type.


I hope this helps people.

Serge, in future releases you may want to add a function like my=20
prepareString method since I use it all the time when inserting user=20
provided data into the DB since they may provide characters that are not=20=

SQL safe.

JOhn

On Tuesday, July 23, 2002, at 04:07 PM, Serge Cohen wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hello again;
>
> About blob the best is to put them in a NSData, use the method=20
> prepareBinaryData: from MCPConnection to transform it into a string=20
> (you still should make the single quotes yourself) that you can insert=20=

> into a query (obviously insert or update...).
>
> To get it back, it just should work ok. In a row, a blob is put in a=20=

> NSData; so you should be able to use directly as input to one o the=20
> NSImage init method.
>
> Indeed I'm very interested on the result, I've done only a very small=20=

> test on both inserting blob using NSData and prepareBinaryData:, and=20=

> getting a NSData from a DB blob.
>
> Serge.
>
>
> Le jeudi 18 juillet 2002, =E0 12:13 , Jerome Rabas a =E9crit :
>
>> Does anybody know how to insert/get blobs from the DB?
>>
>> My problem is that I have a NSImage and I want to insert its content=20=

>> in the DB and, then, be able to get it.
>> What conversion should I do? (converting to NSData, and then?)
>>
>>
>> Thanks.
>>
>>
>> Jerome.
>>
>>
>>
>> -------------------------------------------------------
>> This sf.net email is sponsored by:ThinkGeek
>> Welcome to geek heaven.
>> http://thinkgeek.com/sf
>> _______________________________________________
>> Mysql-cocoa-users mailing list
>> Mys...@li...
>> https://lists.sourceforge.net/lists/listinfo/mysql-cocoa-users
>>
>>
> - ----------------------------------------------------
> Serge Cohen
>
> GPG Key ID: 1024D/69B1D346
> - ----------------------------------------------------
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.0.6 (Darwin)
> Comment: For info see http://www.gnupg.org
>
> iD8DBQE9PXEmMygj1Wmx00YRAkXbAJ4ji6AwVd8WMrge5niUU9KPhdqJrgCeJ/6F
> tdinAH4SvLGJDYeCIzbxwRk=3D
> =3DrokP
> -----END PGP SIGNATURE-----
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Mysql-cocoa-users mailing list
> Mys...@li...
> https://lists.sourceforge.net/lists/listinfo/mysql-cocoa-users
>

Re: [Mysql-cocoa-users] Inserting and getting blobs

[Serge C. <co...@em...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hello again;=0D
=0D
About blob the best is to put them in a NSData, use the method =0D
prepareBinaryData: from MCPConnection to transform it into a string (you =
=0D
still should make the single quotes yourself) that you can insert into a =
=0D
query (obviously insert or update...).=0D
=0D
To get it back, it just should work ok. In a row, a blob is put in a =0D
NSData; so you should be able to use directly as input to one o the =0D
NSImage init method.=0D
=0D
Indeed I'm very interested on the result, I've done only a very small =0D=

test on both inserting blob using NSData and prepareBinaryData:, and =0D
getting a NSData from a DB blob.=0D
=0D
Serge.=0D
=0D
=0D
Le jeudi 18 juillet 2002, =E0 12:13 , Jerome Rabas a =E9crit :=0D
=0D
> Does anybody know how to insert/get blobs from the DB?=0D
>=0D
> My problem is that I have a NSImage and I want to insert its content =
in =0D
> the DB and, then, be able to get it.=0D
> What conversion should I do? (converting to NSData, and then?)=0D
>=0D
>=0D
> Thanks.=0D
>=0D
>=0D
> Jerome.=0D
>=0D
>=0D
>=0D
> -------------------------------------------------------=0D
> This sf.net email is sponsored by:ThinkGeek=0D
> Welcome to geek heaven.=0D
> http://thinkgeek.com/sf=0D
> _______________________________________________=0D
> Mysql-cocoa-users mailing list=0D
> Mys...@li...=0D
> https://lists.sourceforge.net/lists/listinfo/mysql-cocoa-users=0D
>=0D
>=0D
- ----------------------------------------------------=0D
Serge Cohen=0D
=0D
GPG Key ID: 1024D/69B1D346=0D
- ----------------------------------------------------=0D
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (Darwin)
Comment: For info see http://www.gnupg.org

iD8DBQE9PXEmMygj1Wmx00YRAkXbAJ4ji6AwVd8WMrge5niUU9KPhdqJrgCeJ/6F
tdinAH4SvLGJDYeCIzbxwRk=3D
=3DrokP
-----END PGP SIGNATURE-----

Re: [Mysql-cocoa-users] Problems with null fields in version 2

[Serge C. <co...@em...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

=0D
Hello Jerome;=0D
=0D
It's true I did the modification in 'version-1' before. Indeed I had the =
=0D
correction in the v-2 as well but it looks like I have not committed it, =
=0D
now it's done so that should work.=0D
=0D
I'd be very happy if you can make the test, I really does not have much =0D=

time now.=0D
=0D
Report to the list if it still not work, I'll go for the test myself and =
=0D
get it to work.=0D
=0D
=0D
Serge.=0D
=0D
Le mercredi 17 juillet 2002, =E0 12:32 , Jerome Rabas a =E9crit :=0D
=0D
> Hello,=0D
>=0D
> I've just checked out the version-2, and all I've done with version =
0.7 =0D
> works correctly with this version.=0D
>=0D
> After this, I tried to test if NULL field problem was corrected, but I =
=0D
> still have a problem (maybe I don't use it as it should).=0D
> The null field I try to read are dates.=0D
>=0D
> Here is a part of my source code:=0D
>=0D
>     MCPConnection	*connection;=0D
>     NSString		*query;=0D
>     MCPResult	*result;=0D
>     NSDictionary	*row;=0D
>=0D
>     connection =3D [[MCPConnection alloc] initToHost:server =0D
> withLogin:login password:password usingPort:0];=0D
>     [connection selectDB:db ];=0D
>=0D
> NSLog(@"step 1");=0D
>=0D
>     query =3D [[NSString alloc] initWithFormat: @"SELECT EVENT.ID, =
TYPE, =0D
> DESCRIPTOR, TOWN, AREACODE, DAY  FROM EVENT, TOWN"];=0D
>=0D
> NSLog(@"step 2");=0D
>=0D
>     result =3D [connection queryString: query ];=0D
>=0D
> NSLog(@"step 3");=0D
>=0D
>     while (row =3D [result fetchRowAsDictionary])=0D
>     {=0D
> NSLog(@"step 4");=0D
> 	..........=0D
>     }=0D
> NSLog(@"step 5");=0D
>=0D
>=0D
> The result is that step 1, 2 and 3 are displayed in the console, and =0D=

> then I obtain ; *** -[NSCFDictionary setObject:forKey:]: attempt to =0D=

> insert nil value=0D
>=0D
> One field in the result is null, but I can't get any field, so I can't =
=0D
> use MCPNull.=0D
>=0D
> Am I using it correctly?=0D
>=0D
> Thanks.=0D
>=0D
>=0D
> J=E9r=F4me Rabas.=0D
>=0D
>=0D
>=0D
> -------------------------------------------------------=0D
> This sf.net email is sponsored by:ThinkGeek=0D
> Welcome to geek heaven.=0D
> http://thinkgeek.com/sf=0D
> _______________________________________________=0D
> Mysql-cocoa-users mailing list=0D
> Mys...@li...=0D
> https://lists.sourceforge.net/lists/listinfo/mysql-cocoa-users=0D
>=0D
>=0D
- ----------------------------------------------------=0D
Serge Cohen=0D
=0D
GPG Key ID: 1024D/69B1D346=0D
- ----------------------------------------------------=0D
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (Darwin)
Comment: For info see http://www.gnupg.org

iD8DBQE9PW/lMygj1Wmx00YRAkUaAKCiDqsRTZGzf/F5bSSlteG6ucpc9wCgpHMT
yOmND69UeZ12RqdvqDYzYNM=3D
=3DbgJ6
-----END PGP SIGNATURE-----

Re: [Mysql-cocoa-users] hello!

[Serge C. <co...@em...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


> Hi everybody! <Hi Dr Nick!>
>
> Tripped over the site and with my new love of cocoa, mixed with my old 
> love
> on MySQL I figured I'd join the list.
>
> I assume the main advantage to this "Cocoa OBJ-C API" vs. the existing 
> and
> usable in Cocoa (I believe) "C API" is that it will look more natural 
> and be
> OO compliant?
>

You get to the point... It's just a C API wrapper to be more integrated 
with Obj-C and particularly the Cocoa API?

> Keep up the good work .. maybe I can contribute after I shake the cocoa
> newbie out of me :-)
>

Any help very useful... Do not hesitate to join the Dev.

> ~ Mike
> --
> Mike Zornek | Project Leader
> Apple Student Developers
> The Insanely Great Site with the Insanely Long URL
> http://www.applestudentdevelopers.org
>
> Personal Site:
> http://www.mikezornek.com
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Mysql-cocoa-users mailing list
> Mys...@li...
> https://lists.sourceforge.net/lists/listinfo/mysql-cocoa-users
>
>
- ----------------------------------------------------
Serge Cohen

GPG Key ID: 1024D/69B1D346
- ----------------------------------------------------
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (Darwin)
Comment: For info see http://www.gnupg.org

iD8DBQE9PWxcMygj1Wmx00YRAqt7AJ4z7tLMVOwtHDXkCZyIwUWhU5oF8ACeLW48
EOH9xYqWirX5fuamrWupDiE=
=eY3/
-----END PGP SIGNATURE-----

[Mysql-cocoa-users] Re: MySQL and Cocoa

[Serge C. <co...@em...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi;=0D
=0D
Indeed the framework is under GPL, that states only that you have to =0D
provide source an right to use it to any people using your software... =0D=

this is the definition of Free Software.=0D
=0D
To be exact that does not mean the software has to be free: the license =0D=

is free, the source are available and modifiable by users, still you can =
=0D
sale it (you can get some money for the hard support of the soft, the =0D=

installation, the maintenance).=0D
=0D
If you have any doubt about the compatibility of the license with the =0D=

'business model' of your application, the best is to read doc from Gnu =0D=

directly about there license:=0D
http://www.gnu.org/licenses/licenses.html=0D
=0D
Hope this will provides the answer to your question.=0D
=0D
Serge.=0D
=0D
=0D
Le mercredi 17 juillet 2002, =E0 05:55 , da...@un... a =E9crit=
 :=0D
=0D
> Hi.  Is it acceptable to use the MySQL-Cocoa framework with commercial=0D=

> software?=0D
>=0D
> Thank you,=0D
> 	Danny=0D
>=0D
>=0D
- ----------------------------------------------------=0D
Serge Cohen=0D
=0D
GPG Key ID: 1024D/69B1D346=0D
- ----------------------------------------------------=0D
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (Darwin)
Comment: For info see http://www.gnupg.org

iD8DBQE9PWveMygj1Wmx00YRAqm0AJ0fgkm1S5CIhPjNfqRF+yIu8v51gQCgmXzX
rRxbSvUZYncFr8Gn3lKNDmU=3D
=3DvxBq
-----END PGP SIGNATURE-----

[Mysql-cocoa-users] Inserting and getting blobs

[Jerome R. <jer...@fn...>]

Does anybody know how to insert/get blobs from the DB?

My problem is that I have a NSImage and I want to insert its content in 
the DB and, then, be able to get it.
What conversion should I do? (converting to NSData, and then?)


Thanks.


Jerome.

Re: [Mysql-cocoa-users] verbose console

[Jerome R. <jer...@fn...>]

I don't know how to stop this message with version 0.7, but it seems to 
be dispappeared in version 2.0 (on CVS).

Jerome.


On mardi, juillet 16, 2002, at 06:35 , Famille GOUREAU-SUIGNARD wrote:

> Hi folks,
>
> do somebody know how to stop SMySQL sending the message : "Query worked 
> but gives no output" to the console ?
>
> Many thanks.
>
> Camille
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by: Jabber - The world's fastest growing 
> real-time communications platform! Don't just IM. Build it in! 
> http://www.jabber.com/osdn/xim
> _______________________________________________
> Mysql-cocoa-users mailing list
> Mys...@li...
> https://lists.sourceforge.net/lists/listinfo/mysql-cocoa-users
>

[Mysql-cocoa-users] Problems with null fields in version 2

[Jerome R. <jer...@fn...>]

Hello,

I've just checked out the version-2, and all I've done with version 0.7=20=

works correctly with this version.

After this, I tried to test if NULL field problem was corrected, but I=20=

still have a problem (maybe I don't use it as it should).
The null field I try to read are dates.

Here is a part of my source code:

     MCPConnection	*connection;
     NSString		*query;
     MCPResult	*result;
     NSDictionary	*row;

     connection =3D [[MCPConnection alloc] initToHost:server=20
withLogin:login password:password usingPort:0];
     [connection selectDB:db ];

NSLog(@"step 1");

     query =3D [[NSString alloc] initWithFormat: @"SELECT EVENT.ID, =
TYPE,=20
DESCRIPTOR, TOWN, AREACODE, DAY  FROM EVENT, TOWN"];

NSLog(@"step 2");

     result =3D [connection queryString: query ];

NSLog(@"step 3");

     while (row =3D [result fetchRowAsDictionary])
     {
NSLog(@"step 4");
	..........
     }
NSLog(@"step 5");


The result is that step 1, 2 and 3 are displayed in the console, and=20
then I obtain ; *** -[NSCFDictionary setObject:forKey:]: attempt to=20
insert nil value

One field in the result is null, but I can't get any field, so I can't=20=

use MCPNull.

Am I using it correctly?

Thanks.


J=E9r=F4me Rabas.

[Mysql-cocoa-users] verbose console

[Famille GOUREAU-S. <sui...@wa...>]

Hi folks,

do somebody know how to stop SMySQL sending the message : "Query worked 
but gives no output" to the console ?

Many thanks.

Camille

[Mysql-cocoa-users] hello!

[Michael Z. <mik...@mi...>]

Hi everybody! <Hi Dr Nick!>

Tripped over the site and with my new love of cocoa, mixed with my old love
on MySQL I figured I'd join the list.

I assume the main advantage to this "Cocoa OBJ-C API" vs. the existing and
usable in Cocoa (I believe) "C API" is that it will look more natural and be
OO compliant?

Keep up the good work .. maybe I can contribute after I shake the cocoa
newbie out of me :-)

~ Mike
-- 
Mike Zornek | Project Leader
Apple Student Developers
The Insanely Great Site with the Insanely Long URL
http://www.applestudentdevelopers.org

Personal Site: 
http://www.mikezornek.com

[Mysql-cocoa-users] Version 0.7 to 1.0

[Serge C. <co...@em...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi there,

I know there is some people out there, and I was wondering if any body 
has some coment (and more precisely bug report) I should know BEFORE I 
promote the version 0.7 to version 1.0 of the framework.

The last update on the CVS server is from june 3rd (for the main 
branch), nothing came back to me since then. Is that because people are 
happy with it?


I'm currently only working/using the new version (branch version-2 or 
something alike), and I think it's ready for a beta release; but before 
I have to get the previous version out of the way.
The plan in short term is to do a branch for version 1.0, and merge the 
version is the main trunc (then version-2 will be the head), so people 
using the CVS version will automaticaly get the new version.

As usual, any remarks are very welcomed.

Serge.


- ----------------------------------------------------
Serge Cohen

GPG Key ID: 1024D/69B1D346
- ----------------------------------------------------
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (Darwin)
Comment: For info see http://www.gnupg.org

iD8DBQE9D5WRMygj1Wmx00YRAg8zAJ9VmZxTQPWwTiiEKFaDX/4WaEo9hACeKZWD
g+Vjfna9SHnKPWUgiKymrD8=
=7HUs
-----END PGP SIGNATURE-----

Re: [Mysql-cocoa-users] dyld failing

[Laurent Domenech-C. <la...@op...>]

Sorry for the late reply. Thanks it worked great. Merci Serge.

On mardi, mai 21, 2002, at 05:24 , Serge Cohen wrote:

> Hi Laurent
>
>
>
> Indeed it looks from the printout you gave from the trouble that there
> might be two problem:
>
>
>
> 1. You want to have the SMySQL target installed, that is in a place
> where it can be found by the dynamic linker. For that you have to follow
> the instruction in the TO_INSTALL file in the SMySQL directory.
>
>
>
> 2. Once the previous point is done, yo should have a version of the
> framework installed in ~/Library/Frameworks/. You want to make sure that
> the SMySQL_test application is linked with this framework (and not the
> one in the SMySQL/build/ directory), and that the path is absolute.
>

[Mysql-cocoa-users] Re: SMySQL install Q

[Serge C. <co...@em...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

For a quick (and I hope clear) answer:=0D
=0D
0. I can send you a libmysqlclient.dylib version, it should work but =0D
needs to be placed in /usr/local/lib .... (requires root access).=0D
=0D
1. Use our SMySQL framework, it's under GPL, which as far as I know just =
=0D
forces you to be free source, but you still can sell your software (as =0D=

long as it comes with source, or source be freely available and =0D
modifiable by user).=0D
=0D
2. More precisely use the SMySQL_fully_embeded target together with =0D
embdevelopment (or embdeployement) build style of the framework (which =0D=

by the way should allow you to compile without having to install any =0D
MySQL source on your machine, as sources are coming with it).=0D
=0D
=0D
Serge.=0D
=0D
PS: There is a recent branch, available only on CVS (called version-2), =0D=

which is largely extendeed from the previous version. This will be the =0D=

next "stable" version of the framework, so I recommend you use this new =0D=

version.=0D
=0D
Le mercredi 5 juin 2002, =C3=A0 10:56 PM, Mario Scarpa a =C3=A9crit :=0D
=0D
> Hi Serge,=0D
>=0D
> thanks for the prompt reply (there 're companies with loooots of =0D
> developers where=0D
> you never get a mail from so, at least at this level, your support is =0D=

> not the one of a=0D
> part time project ;-)).=0D
>=0D
> Back to us. What I want to do is pretty simple: I 've done (well, am =0D=

> doing is maybe=0D
> more appropriate) a little utility to manage a database of audio CDs =0D=

> which has MySQL=0D
> support so that the users are able to post, retrieve and search the DB =
=0D
> while being=0D
> online. I have used the C API of course but once I compile the app, =
the =0D
> dynamic lib=0D
> libmysqlclient is needed to make the app work. My wishes are:=0D
>=0D
> 1. use a more "cocoa" approach and thus find a MySQL Framework around =0D=

> the=0D
>     C API.=0D
> 2. be able to ship my app as a self-contained and self-sufficient =0D
> program with no=0D
>     need to install another dynamic lib into some special location =0D
> outside the bundle.=0D
>=0D
> Ok, I'm not a full time developer and probably the solution is silly =0D=

> but I still can't find=0D
> a definitive answer to my needs. Have you got any hint ?=0D
>=0D
> Thanks again and talk you soon,=0D
> Mario.=0D
>=0D
>=0D
- ----------------------------------------------------=0D
Serge Cohen=0D
=0D
GPG Key ID: 1024D/69B1D346=0D
- ----------------------------------------------------=0D
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (Darwin)
Comment: For info see http://www.gnupg.org

iD8DBQE8/1hSMygj1Wmx00YRAgfeAJ417DYLMUSg94OGuwrXZxq30AM3LACeJqvm
G+S/FhlTGLb0Y8nmkn3f5pI=3D
=3DAEiR
-----END PGP SIGNATURE-----