Re: [Mysql-cocoa-users] Problems with null fields in version 2
Brought to you by:
sergecohen
|
From: Serge C. <co...@em...> - 2002-07-23 15:01:26
|
-----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-----
|