mysql-cocoa-users Mailing List for MySQL Objective C API for Cocoa (Page 9)
Brought to you by:
sergecohen
Menu
▾
▴
mysql-cocoa-users — The mysql-cocoa users mailing list
You can subscribe to this list here.
| 2002 |
Jan
(2) |
Feb
|
Mar
(14) |
Apr
(5) |
May
(23) |
Jun
(8) |
Jul
(13) |
Aug
(5) |
Sep
|
Oct
(1) |
Nov
(11) |
Dec
(4) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2003 |
Jan
(9) |
Feb
(6) |
Mar
(13) |
Apr
(2) |
May
(3) |
Jun
|
Jul
(5) |
Aug
(11) |
Sep
(18) |
Oct
(1) |
Nov
(15) |
Dec
(2) |
| 2004 |
Jan
(3) |
Feb
(3) |
Mar
(8) |
Apr
(1) |
May
(2) |
Jun
(3) |
Jul
(15) |
Aug
(36) |
Sep
(5) |
Oct
|
Nov
(6) |
Dec
(2) |
| 2005 |
Jan
(1) |
Feb
(11) |
Mar
(1) |
Apr
(6) |
May
|
Jun
(7) |
Jul
(3) |
Aug
|
Sep
|
Oct
(2) |
Nov
|
Dec
|
| 2006 |
Jan
(9) |
Feb
(5) |
Mar
(2) |
Apr
(1) |
May
(9) |
Jun
(2) |
Jul
(1) |
Aug
(4) |
Sep
|
Oct
(1) |
Nov
|
Dec
(2) |
| 2007 |
Jan
(23) |
Feb
(1) |
Mar
(1) |
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(1) |
Nov
|
Dec
|
| 2008 |
Jan
(1) |
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: John G. <jo...@jl...> - 2003-09-24 23:40:46
|
sounds like you have not init'ed your object so you have a garbage object. ie you have done myConnection = [MCPConnect alloc]; instead of myConnection = [[MCPConnect alloc] init:...]; in the first case you have simply allocated space for the object, in the second case you have allocated space AND initialised (instantiated) it. I'm guessing, but post the relevant bit of your code if you are having trouble still. JOhn On Wednesday, September 24, 2003, at 08:15 PM, Ezat Hashim wrote: > Thanks for the previous message. Could anyone tell me how to reply to > a list posting? I am not familiar with the system... > > > The compile seems to work fine but when I launch my app it crashes > when I try to instantiate MCPConnect. Using the debugger I see on the > thread: > > #0 0x08807f60 in mysql_character_set_name > > and the debugger states that "Program recieved signal: "EXC_BAD_ACCESS" > > > > Any ideas on what I could be doing wrong? > > Ezat > > > > ------------------------------------------------------- > 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 > |
|
From: Ezat H. <eza...@vi...> - 2003-09-24 20:03:44
|
Thanks for the previous message. Could anyone tell me how to reply to a list posting? I am not familiar with the system... The compile seems to work fine but when I launch my app it crashes when I try to instantiate MCPConnect. Using the debugger I see on the thread: #0 0x08807f60 in mysql_character_set_name and the debugger states that "Program recieved signal: "EXC_BAD_ACCESS" Any ideas on what I could be doing wrong? Ezat |
|
From: Serge C. <ser...@us...> - 2003-09-24 15:40:43
|
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, Just to clarify something first (My apologise if this paragraph comes=20 in because I wrongly understand your message): The error lines that you report are not contradictory with the content=20= of the SMySQL_bundled/SMySQL.h file... it is indeed the contrary: Through SMySQL.h you've asked to import other header files, and the=20 compilers (preprocessor indeed) get this info. Rather the problem is=20 that for some reason it is not able to find them (in other word: it's=20 not complaining that you have not tried to import them but indeed that=20= it does not manage to import them). So the problem is that the preprocessor is not able to find the headers=20= that are called by SMySQL_bundled/SMySQL.h This is because of MY error... you have to edit SMySQL_bundled/SMySQL.h=20= so that is reads something like (replacing SMySQL/... by=20 SMySQL_bundled/...): #import <Foundation/Foundation.h> #import <SMySQL_bundled/SMySQLConstants.h> #import <SMySQL_bundled/MCPNull.h> #import <SMySQL_bundled/MCPResult.h> #import <SMySQL_bundled/MCPConnection.h> #import <SMySQL_bundled/MCPResultPlus.h> #import <SMySQL_bundled/MCPFastQueries.h> #import "mysql.h" That should do the trick. Last thing, I find it bizarre that you placed the SMySQL_bundled=20 framework in /Library/Frameworks (if you intend to use the framework=20 this way, then you should better use the SMySQL_static flavour of the=20 framework). When I'm using the bundled version of the framework I=20 usually put it somewhere in the project folder. Hope that helps. Serge. Le mercredi, 24 sep 2003, =E0 05:09 Europe/Amsterdam, Ezat Hashim a = =E9crit=20 : > I am trying to use the 'bundled' flavour of SMySQL with some problems.=20= > In my main header file I have placed the following: > > #import <SMySQL_bundled/SMySQL.h> > > which seems ok to me. However, when I compile I get the following: > > /Library/Frameworks/SMySQL_bundled.framework/Headers/SMySQL.h:30:35:=20= > SMySQL/SMySQLConstants.h: No such file or directory > /Library/Frameworks/SMySQL_bundled.framework/Headers/SMySQL.h:31:27:=20= > SMySQL/MCPNull.h: No such file or directory > /Library/Frameworks/SMySQL_bundled.framework/Headers/SMySQL.h:32:29:=20= > SMySQL/MCPResult.h: No such file or directory > /Library/Frameworks/SMySQL_bundled.framework/Headers/SMySQL.h:33:33:=20= > SMySQL/MCPConnection.h: No such file or directory > /Library/Frameworks/SMySQL_bundled.framework/Headers/SMySQL.h:34:33:=20= > SMySQL/MCPResultPlus.h: No such file or directory > /Library/Frameworks/SMySQL_bundled.framework/Headers/SMySQL.h:35:34:=20= > SMySQL/MCPFastQueries.h: No such file or directory > > I don't get it. It should be included in the framework. If I look at=20= > SMySQL.h I see: > > #import <SMySQL/SMySQLConstants.h> > #import <SMySQL/MCPNull.h> > #import <SMySQL/MCPResult.h> > #import <SMySQL/MCPConnection.h> > #import <SMySQL/MCPResultPlus.h> > #import <SMySQL/MCPFastQueries.h> > #import "mysql.h" > //#import <SMySQL/mysql.h> > > Any ideas on what I am doing wrong. Is there a different search path=20= > that I should be using? > > Ezat > > - ---------------------------------------------------- Serge Cohen GPG Key ID: 9CBB58FB - ---------------------------------------------------- -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (Darwin) iD8DBQE/cbrN5EPeG5y7WPsRArSWAKDG0p14AB5c1xKeVV+RjXOJm+iZMACgiMQ4 vj7jqDZfu89DEL7tLZxucrQ=3D =3D4gpK -----END PGP SIGNATURE----- |
|
From: Ezat H. <eza...@vi...> - 2003-09-24 11:24:09
|
I am trying to use the 'bundled' flavour of SMySQL with some problems. In my main header file I have placed the following: #import <SMySQL_bundled/SMySQL.h> which seems ok to me. However, when I compile I get the following: /Library/Frameworks/SMySQL_bundled.framework/Headers/SMySQL.h:30:35: SMySQL/SMySQLConstants.h: No such file or directory /Library/Frameworks/SMySQL_bundled.framework/Headers/SMySQL.h:31:27: SMySQL/MCPNull.h: No such file or directory /Library/Frameworks/SMySQL_bundled.framework/Headers/SMySQL.h:32:29: SMySQL/MCPResult.h: No such file or directory /Library/Frameworks/SMySQL_bundled.framework/Headers/SMySQL.h:33:33: SMySQL/MCPConnection.h: No such file or directory /Library/Frameworks/SMySQL_bundled.framework/Headers/SMySQL.h:34:33: SMySQL/MCPResultPlus.h: No such file or directory /Library/Frameworks/SMySQL_bundled.framework/Headers/SMySQL.h:35:34: SMySQL/MCPFastQueries.h: No such file or directory I don't get it. It should be included in the framework. If I look at SMySQL.h I see: #import <SMySQL/SMySQLConstants.h> #import <SMySQL/MCPNull.h> #import <SMySQL/MCPResult.h> #import <SMySQL/MCPConnection.h> #import <SMySQL/MCPResultPlus.h> #import <SMySQL/MCPFastQueries.h> #import "mysql.h" //#import <SMySQL/mysql.h> Any ideas on what I am doing wrong. Is there a different search path that I should be using? Ezat |
|
From: Serge C. <ser...@us...> - 2003-09-24 08:36:33
|
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi; You have to use the following import statement: #import <SMySQL_bundled/SMySQL.h> Concerning you proposition for documentation, I've been hoping that=20 someone volunteer for some time... So you are very welcome. I'll come back to your on that this evening. Serge. Le mardi, 23 sep 2003, =E0 23:01 Europe/Amsterdam, Ezat Hashim a =E9crit = : > Serge: > > I have signed up for the mailing list with regards to the excellent=20 > Cocoa MySQL framework that you have been working on. My apologies but=20= > I have a question with regards to using the SMySQL_bundled framework=20= > which I downloaded from your site. I have it grafted to my app but I=20= > seem to be getting an error with regards to what to "#import". In my=20= > app, I have the following in my main header file: > > #import <SMySQL_bundled/SMySQL_bundled.h> > > However, I think that it is not correct. What would be the correct=20 > format to import? Would I have to change the name of the framework? > > My apologies again but I am a bit old and unfamiliar with how to use=20= > the mailing list. I will try to figure it out and post questions in=20 > the future... > > Ezat > > PS I would not be able to help you with the programming side, but if=20= > you need someone to help out with the documentation I would be more=20 > than glad to volunteer. > - ---------------------------------------------------- Serge Cohen GPG Key ID: 9CBB58FB - ---------------------------------------------------- -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (Darwin) iD8DBQE/cVdk5EPeG5y7WPsRAlsYAKDj3fQ4gFqN28rapGMhS/TzNDuKCwCgu/VA nPp9tHxnLjjBJ98G92ziu7A=3D =3Dpolg -----END PGP SIGNATURE----- |
|
From: Serge C. <ser...@us...> - 2003-09-22 20:56:34
|
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi; I'm afraid I can hardly provide you with what you're asking for...=20 Indeed the only 'code example' so far is the one in the CLI_Test=20 application (included in the sources of the framework), and it's=20 neither well documented nor very standard of how one can benefit from=20 the framework. Indeed, I'm trying now to write a small sample application with the=20 framework, together with documentataion to make it a kind of tutorial,=20= the problem is that I'd like to enhance the framework a bit before=20 that... and I have time for none of that (well indeed a bit framework=20 enhancement). Maybe, you would be more successful getting sample source codes on the=20= mailing list of the framework users=20 (mys...@li...), to which I've CCied this=20 answer. The other solution I can propose is that you start with the CLI_test=20 application sources as a startup, and that you ask me question when it=20= comes to usage which is not covered by this example. Looking forward to read you. Serge. Le lundi, 22 sep 2003, =E0 03:59 Europe/Amsterdam, Ezat Hashim a =E9crit = : > Serge: > > I am very interested in using the framework/wrapper on which you have=20= > been working hard. I am just a novice programmer so I simply=20 > downloaded the binary of the framework. I have been looking at the=20 > documentation and I would need small snippets of example code to get=20= > me started.More specifically, it would be nice to have example code on=20= > using insert/update and also on how to treat BLOBs (insert/retrieve). > > In the binaries I don't think that I saw any sample code. Would there=20= > be any out there? > > Ezat > > > - ---------------------------------------------------- Serge Cohen GPG Key ID: 9CBB58FB - ---------------------------------------------------- -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (Darwin) iD8DBQE/b2Hv5EPeG5y7WPsRAm6nAKDpk3or7vZXCd1wkJQVAsvfM7IseACdHAd1 NA3+7GyjmqB9e0LJerS2exk=3D =3DSDvO -----END PGP SIGNATURE----- |
|
From: Lorenz T. <lo...@te...> - 2003-09-21 11:36:45
|
Hi Serge,
I have noticed that the framework has some problems with dates like
0000-00-00 or 0000-01-01, or times like 222:12:10. I have changed some
lines in the fetchRow methods, so that it tries to initialize a
NSCalendarDate object, and if that isn't possible, it just returns the
value as a string.
Maybe you want to implement that in your version.
Best Regards,
Lorenz
// changes in fetchRow methods to fix problems with "unexisting" dates
and times
case FIELD_TYPE_DATE:
theCurrentObj = [NSCalendarDate
dateWithString:[NSString stringWithUTF8String:theData]
calendarFormat:@"%Y-%m-%d"];
if ( !theCurrentObj ) {
theCurrentObj = [NSString
stringWithUTF8String:theData];
}
break;
case FIELD_TYPE_TIME:
theCurrentObj = [NSCalendarDate
dateWithString:[NSString stringWithUTF8String:theData]
calendarFormat:@"%H:%M:%S"];
if ( !theCurrentObj ) {
theCurrentObj = [NSString
stringWithUTF8String:theData];
}
break;
case FIELD_TYPE_DATETIME:
theCurrentObj = [NSCalendarDate
dateWithString:[NSString stringWithUTF8String:theData]
calendarFormat:@"%Y-%m-%d %H:%M:%S"];
if ( !theCurrentObj ) {
theCurrentObj = [NSString
stringWithUTF8String:theData];
}
break;
case FIELD_TYPE_YEAR:
theCurrentObj = [NSCalendarDate
dateWithString:[NSString stringWithUTF8String:theData]
calendarFormat:@"%Y"];
if ( !theCurrentObj ) {
theCurrentObj = [NSString
stringWithUTF8String:theData];
}
break;
|
|
From: John G. <jo...@jl...> - 2003-09-13 15:09:54
|
>> >> PS: Maybe, I'm mislead , and some other developers are using still >> version 1.0 of the framework (and does not want to update to 2.0), if >> this is the case, I'd be happy to get some feed back to know : >> 1. If I should still spent some effort to try keep 'old' API updated >> (for each bugs found, should I still correct both versions of the >> framework)? > Definitely NO! Developers who are using an old version should make the > changes themself! > Yep, agree here, you've done plenty to keep the old version up to date, so time to upgrade for everybody now who needs bug fixes and updates. >> 2. What can I do, to make the 'jump' easier for you? > I think it's perfect as it is now. It's just because of my laziness > that I haven't made the jump yet ;-) > Exactly the same here, sheer laziness on my part, now I suppose the time is right to make the jump to the next version of the framework, and besides the class names are shorter now anyway. > Thanks for your work on the framework, > Lorenz > Same thanks from here, just having this Framework round at the right time made my life a lot easier (even if my product hasn't got anywhere yet). BTW, I keep plugging the framework whenever appropriate, like on Macslash today :) |
|
From: Lorenz T. <lo...@te...> - 2003-09-13 09:50:21
|
Hi Serge, Thank you very much for taking the time to answer! > Hi Lorentz; > > I was wondering if this is not a good time to go for the 2.0 API of=20 > the framework. > This will mainly mean that you have a to a 'Massive' Query/Replace=20 > (for changing the SMySQL prefix by MCP). > The name of the methods are unchanged, so only the class names have to=20= > be changed. I plan to switch to the new version for the next release of CocoaMySQL.=20= If only the class names changed, it's really not a great deal to make=20 the necessary changes. > > In this respect (and also, because CocaoMySQL is the main reason for=20= > me to keep distributing the old version of the framework), I'm ready=20= > to help you as much as possible if there is anything I can do for=20 > making it easier for you to go from version 1.0 to 2.0 of the=20 > framework. Thanks for that! I'll send you a mail if I have problems using the new=20= framework. > > The nice thing about the new version is that it uses the=20 > libmysqlclient (instead of having its sources in the project), so it=20= > is much easier to get it to work with a specific version of the=20 > library. The one distributed is 4.0, but in the context of the=20 > previous paragraph, I can make a target using 4.1 version of the=20 > libmyslqclient. A version using MySQL 4.1 would be great. I think this would work well=20= with MySQL <4.1, but would add the possibility to connect to servers=20 running 4.1. I hope that it's not too much work to make this changes.=20 Please tell me if I can help! > > > Tell me what you think of this proposal... > > Serge. > > PS: Maybe, I'm mislead , and some other developers are using still=20 > version 1.0 of the framework (and does not want to update to 2.0), if=20= > this is the case, I'd be happy to get some feed back to know : > 1. If I should still spent some effort to try keep 'old' API updated=20= > (for each bugs found, should I still correct both versions of the=20 > framework)? Definitely NO! Developers who are using an old version should make the=20= changes themself! > 2. What can I do, to make the 'jump' easier for you? I think it's perfect as it is now. It's just because of my laziness=20 that I haven't made the jump yet ;-) Thanks for your work on the framework, Lorenz > > Le dimanche, 7 sep 2003, =E0 18:01 Europe/Amsterdam, Lorenz Textor a=20= > =E9crit : > >> Hi, >> >> Since MySQL 4.1 uses a new encryption for the account passwords, it=20= >> seems that the framework can connect to the server only when no=20 >> password is set for the given user. >> Does anybody know how to build the framework so that the new password=20= >> format is supported? I have tried replacing the password.c file and=20= >> other MySQL source files with the new files in the MySQL 4.1=20 >> distribution, but that gives only a lot or errors when compiling the=20= >> framework. It seems that there have to be bigger changes... >> >> Thanks a lot for your help, >> Lorenz >> >> -- >> CococaMySQL - A Mac OS X MySQL GUI >> http://cocoamysql.sourceforge.net >> >> >> >> ------------------------------------------------------- >> 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: 9CBB58FB > - ---------------------------------------------------- > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.2.1 (Darwin) > > iD8DBQE/XI9Y5EPeG5y7WPsRAofMAKDsyv6Yz59Ezvh0sldIyybyZ2PrugCgt0Fq > vNHQN9HAkTu1su1X1L38BgM=3D > =3D4cBD > -----END PGP SIGNATURE----- > > > > > --=20 lorenz textor ** sh ** eigerstrasse 21 8200 schaffhausen tf 052 - 624 27 91 ** ticino ** via delle scuole 41 6963 pregassona tf 091 - 940 20 57 ** mobile 076 - 531 71 74 email lo...@te... |
|
From: Serge C. <ser...@us...> - 2003-09-11 21:04:28
|
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 For some reasons, I've sent this mail few days ago... and it's still=20 not appearing on the mailing list. So here it is again. Hi Lorentz; I was wondering if this is not a good time to go for the 2.0 API of the=20= framework. This will mainly mean that you have a to a 'Massive' Query/Replace (for=20= changing the SMySQL prefix by MCP). The name of the methods are unchanged, so only the class names have to=20= be changed. In this respect (and also, because CocaoMySQL is the main reason for me=20= to keep distributing the old version of the framework), I'm ready to=20 help you as much as possible if there is anything I can do for making=20 it easier for you to go from version 1.0 to 2.0 of the framework. The nice thing about the new version is that it uses the libmysqlclient=20= (instead of having its sources in the project), so it is much easier to=20= get it to work with a specific version of the library. The one=20 distributed is 4.0, but in the context of the previous paragraph, I can=20= make a target using 4.1 version of the libmyslqclient. Tell me what you think of this proposal... Serge. PS: Maybe, I'm mislead , and some other developers are using still=20 version 1.0 of the framework (and does not want to update to 2.0), if=20 this is the case, I'd be happy to get some feed back to know : 1. If I should still spent some effort to try keep 'old' API updated=20 (for each bugs found, should I still correct both versions of the=20 framework)? 2. What can I do, to make the 'jump' easier for you? Le dimanche, 7 sep 2003, =E0 18:01 Europe/Amsterdam, Lorenz Textor a=20 =E9crit : > Hi, > > Since MySQL 4.1 uses a new encryption for the account passwords, it=20 > seems that the framework can connect to the server only when no=20 > password is set for the given user. > Does anybody know how to build the framework so that the new password=20= > format is supported? I have tried replacing the password.c file and=20 > other MySQL source files with the new files in the MySQL 4.1=20 > distribution, but that gives only a lot or errors when compiling the=20= > framework. It seems that there have to be bigger changes... > > Thanks a lot for your help, > Lorenz > > -- > CococaMySQL - A Mac OS X MySQL GUI > http://cocoamysql.sourceforge.net > > > > ------------------------------------------------------- > 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: 9CBB58FB - ---------------------------------------------------- -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (Darwin) iD8DBQE/YOND5EPeG5y7WPsRAuT3AKCga/QB3VdFEZETFxmMDMn+vL80XgCfdTLE CgeCE4ZLjVpqz8v7ivMA/No=3D =3D+CR/ -----END PGP SIGNATURE----- ---------------------------------------------------- Serge Cohen GPG Key ID: 9CBB58FB ----------------------------------------------------= |
|
From: Lorenz T. <lo...@te...> - 2003-09-07 16:01:49
|
Hi, Since MySQL 4.1 uses a new encryption for the account passwords, it seems that the framework can connect to the server only when no password is set for the given user. Does anybody know how to build the framework so that the new password format is supported? I have tried replacing the password.c file and other MySQL source files with the new files in the MySQL 4.1 distribution, but that gives only a lot or errors when compiling the framework. It seems that there have to be bigger changes... Thanks a lot for your help, Lorenz -- CococaMySQL - A Mac OS X MySQL GUI http://cocoamysql.sourceforge.net |
|
From: Serge C. <ser...@us...> - 2003-09-07 03:09:32
|
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi Rob;=0D =0D First thanks to point me an error in my distribution (the SMySQL/ =0D instead of SMySQL_static/ ... and the same for the _bundled).=0D I'll try to fix that as soon as possible.=0D =0D Then the second point:=0D Since version 2.0 of the framework, the prefix of classes is no more =0D SMySQL but MCP (for MySQL Cocoa Project... and mainly because it is =0D shorter and I was finally lazy to type 5 letter prefixes instead of 3).=0D= =0D So basically, you just have to query/replace=0D SMySQLConnection -> MCPConnection=0D SMySQLResult -> MCPResult=0D =0D And that should do.=0D Cheers.=0D =0D =0D Serge.=0D =0D Le dimanche, 7 sep 2003, =E0 04:34 Europe/Amsterdam, Rob Payne a =E9crit = :=0D =0D > Hello Serge,=0D >=0D > Thank you for taking the time to reply, I really appreciate it.=0D >=0D > I am attempting to connect to a remote MySQL server, not localhost. So = =0D > I'm assuming I shouldn't use the "SMySQL.framework" flavor. (I am a =0D= > newbie to Cocoa, but I've worked with other programming languages.)=0D >=0D > I have copied the _static frameworks to "/Library/Frameworks", and =0D > changed my header file in Project Builder to "#import =0D > <SMySQL_static/SMySQL.h>". Then when building, I received the =0D > following errors:=0D >=0D > /Library/Frameworks/SMySQL_static.framework/Headers/SMySQL.h:30: =0D > header file 'SMySQL/SMySQLConstants.h' not found=0D > /Library/Frameworks/SMySQL_static.framework/Headers/SMySQL.h:31: =0D > header file 'SMySQL/MCPNull.h' not found=0D > /Library/Frameworks/SMySQL_static.framework/Headers/SMySQL.h:32: =0D > header file 'SMySQL/MCPResult.h' not found=0D > /Library/Frameworks/SMySQL_static.framework/Headers/SMySQL.h:33: =0D > header file 'SMySQL/MCPConnection.h' not found=0D > /Library/Frameworks/SMySQL_static.framework/Headers/SMySQL.h:34: =0D > header file 'SMySQL/MCPResultPlus.h' not found=0D > /Library/Frameworks/SMySQL_static.framework/Headers/SMySQL.h:35: =0D > header file 'SMySQL/MCPFastQueries.h' not found=0D > appController.h:10: undefined type, found `SMySQLConnection'=0D > <built-in>:1:1: no macro name given in #define directive=0D >=0D > I simply changed the file paths from "SMySQL/" to "SMySQL_static/". =0D= > That got rid of those problems. However, now I get these errors:=0D >=0D > appController.h:10: undefined type, found `SMySQLConnection'=0D > In file included from appController.m:2:=0D > appController.h:10: parse error before "SMySQLConnection"=0D > appController.m:7: `mySQLConnection' undeclared (first use in this =0D > function)=0D > appController.m:7: (Each undeclared identifier is reported only once=0D= > appController.m:7: for each function it appears in.)=0D > appController.m:7: `SMySQLConnection' undeclared (first use in this =0D= > function)=0D >=0D > How can I fix this?=0D >=0D > Thanks,=0D >=0D > Rob P.=0D >=0D >=0D - ----------------------------------------------------=0D Serge Cohen=0D =0D GPG Key ID: 9CBB58FB=0D - ----------------------------------------------------=0D -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (Darwin) iD8DBQE/WqFH5EPeG5y7WPsRArigAKDyr4NqfI4xQ1VkJV08LQIO4FTd3QCeOs73 gXDT9kw6Rom57KU4kBQ+jmQ=3D =3DsvT1 -----END PGP SIGNATURE----- |
|
From: Rob P. <ro...@in...> - 2003-09-07 02:35:01
|
Hello Serge, Thank you for taking the time to reply, I really appreciate it. I am attempting to connect to a remote MySQL server, not localhost. So=20= I'm assuming I shouldn't use the "SMySQL.framework" flavor. (I am a=20 newbie to Cocoa, but I've worked with other programming languages.) I have copied the _static frameworks to "/Library/Frameworks", and=20 changed my header file in Project Builder to "#import=20 <SMySQL_static/SMySQL.h>". Then when building, I received the following=20= errors: /Library/Frameworks/SMySQL_static.framework/Headers/SMySQL.h:30: header=20= file 'SMySQL/SMySQLConstants.h' not found /Library/Frameworks/SMySQL_static.framework/Headers/SMySQL.h:31: header=20= file 'SMySQL/MCPNull.h' not found /Library/Frameworks/SMySQL_static.framework/Headers/SMySQL.h:32: header=20= file 'SMySQL/MCPResult.h' not found /Library/Frameworks/SMySQL_static.framework/Headers/SMySQL.h:33: header=20= file 'SMySQL/MCPConnection.h' not found /Library/Frameworks/SMySQL_static.framework/Headers/SMySQL.h:34: header=20= file 'SMySQL/MCPResultPlus.h' not found /Library/Frameworks/SMySQL_static.framework/Headers/SMySQL.h:35: header=20= file 'SMySQL/MCPFastQueries.h' not found appController.h:10: undefined type, found `SMySQLConnection' <built-in>:1:1: no macro name given in #define directive I simply changed the file paths from "SMySQL/" to "SMySQL_static/".=20 That got rid of those problems. However, now I get these errors: appController.h:10: undefined type, found `SMySQLConnection' In file included from appController.m:2: appController.h:10: parse error before "SMySQLConnection" appController.m:7: `mySQLConnection' undeclared (first use in this=20 function) appController.m:7: (Each undeclared identifier is reported only once appController.m:7: for each function it appears in.) appController.m:7: `SMySQLConnection' undeclared (first use in this=20 function) How can I fix this? Thanks, Rob P. On Saturday, September 6, 2003, at 08:35 PM, Serge Cohen wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Hi Rob; > > First let me mention one resource that you can use when you have such=20= > a problem; the mailing list mys...@li... > = ... > The advantages are two fold: > - - First (for you), you might get there faster and better support=20 > (because I'm not the only one to answer, and someone is likely to=20 > already have to confront the problem you're facing and knows the way=20= > around) > - - Second (for others), the list is archived, so if anything=20 > interesting comes out of the exchange, it can be found by future users=20= > of the framework. > > .... that's said, I'm very happy to receive your feedback, and be=20 > assured I'll try my best to help you with getting the framework to=20 > work. > > As far as I can understand, you are using the binary distribution. And=20= > from this you are trying to use the SMySQL.framework (and not the=20 > _static nor the _bundled version)... please tell me if I'm wrong here=20= > (in which case you can ignore the following of the mail). > > If you are using SMySQL.framework, you need to have=20 > libmysqlclient.dylib installed in /usr/local/lib/mysql, and the=20 > corresponding headers (one of which is mysql.h) in=20 > /usr/local/include/mysql/. These files are NOT part of my=20 > distribution, you have to install MySQL to get them. > > If you don't have MySQL installed, and are only interested by the=20 > client side of MySQL, the easiest is then to use the=20 > SMySQL_static.framework, which comes with it's own libmysqlclient=20 > library and the appropriate headers. Place it in /Library/Frameworks=20= > for example and use it by importing the header: > #import <SMySQL_static/SMySQL.h> > > Last, if you are developing a GUI application, I would strongly=20 > encourage you to use the SMySQL_bundled version of the framework. > > > I hope, my message is clear (I'm not a native English speaker, and I'm=20= > afraid to have been more confusing than helping). > DO NOT hesitate to go on mailing me (or even better : the list). > > Serge. > > Le samedi, 6 sep 2003, =E0 22:24 Europe/Amsterdam, Rob Payne a =E9crit = : > >> Hello Serge, >> >> I am trying to develop a personal Cocoa application which requires=20 >> MySQL. I understand that I need to use the SMySQL frameworks to do=20 >> this. However, when I try to use the standard "SMySQL.framework"=20 >> flavor, I get a bunch of errors saying "header file 'mysql.h' not=20 >> found". I was not able to find the mysql.h file in framework folder.=20= >> I have SMySQL.framework stored in /Library/Frameworks. >> >> Honestly, I've spent hours reading through files and documentations=20= >> trying to fix this, and contacting you is my last resort. I have a=20 >> feeling I'm missing something obvious. Any suggestions? >> >> Regards, >> >> Rob P. >> ro...@in... >> >> >> > - ---------------------------------------------------- > Serge Cohen > > GPG Key ID: 9CBB58FB > - ---------------------------------------------------- > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.2.1 (Darwin) > > iD8DBQE/Wn1Z5EPeG5y7WPsRAj5OAKDKgoqtp/QfNKXviV/VVvJGdj4WxQCg/O6K > F2t38AXtqqMLSQc8wgVfUhs=3D > =3D0uxq > -----END PGP SIGNATURE----- > > > > |
|
From: Serge C. <ser...@us...> - 2003-09-07 00:39:35
|
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi Rob; First let me mention one resource that you can use when you have such a=20= problem; the mailing list mys...@li... ... The advantages are two fold: - - First (for you), you might get there faster and better support=20 (because I'm not the only one to answer, and someone is likely to=20 already have to confront the problem you're facing and knows the way=20 around) - - Second (for others), the list is archived, so if anything=20 interesting comes out of the exchange, it can be found by future users=20= of the framework. .... that's said, I'm very happy to receive your feedback, and be=20 assured I'll try my best to help you with getting the framework to work. As far as I can understand, you are using the binary distribution. And=20= from this you are trying to use the SMySQL.framework (and not the=20 _static nor the _bundled version)... please tell me if I'm wrong here=20 (in which case you can ignore the following of the mail). If you are using SMySQL.framework, you need to have=20 libmysqlclient.dylib installed in /usr/local/lib/mysql, and the=20 corresponding headers (one of which is mysql.h) in=20 /usr/local/include/mysql/. These files are NOT part of my distribution,=20= you have to install MySQL to get them. If you don't have MySQL installed, and are only interested by the=20 client side of MySQL, the easiest is then to use the=20 SMySQL_static.framework, which comes with it's own libmysqlclient=20 library and the appropriate headers. Place it in /Library/Frameworks=20 for example and use it by importing the header: #import <SMySQL_static/SMySQL.h> Last, if you are developing a GUI application, I would strongly=20 encourage you to use the SMySQL_bundled version of the framework. I hope, my message is clear (I'm not a native English speaker, and I'm=20= afraid to have been more confusing than helping). DO NOT hesitate to go on mailing me (or even better : the list). Serge. Le samedi, 6 sep 2003, =E0 22:24 Europe/Amsterdam, Rob Payne a =E9crit : > Hello Serge, > > I am trying to develop a personal Cocoa application which requires=20 > MySQL. I understand that I need to use the SMySQL frameworks to do=20 > this. However, when I try to use the standard "SMySQL.framework"=20 > flavor, I get a bunch of errors saying "header file 'mysql.h' not=20 > found". I was not able to find the mysql.h file in framework folder. I=20= > have SMySQL.framework stored in /Library/Frameworks. > > Honestly, I've spent hours reading through files and documentations=20 > trying to fix this, and contacting you is my last resort. I have a=20 > feeling I'm missing something obvious. Any suggestions? > > Regards, > > Rob P. > ro...@in... > > > - ---------------------------------------------------- Serge Cohen GPG Key ID: 9CBB58FB - ---------------------------------------------------- -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (Darwin) iD8DBQE/Wn1Z5EPeG5y7WPsRAj5OAKDKgoqtp/QfNKXviV/VVvJGdj4WxQCg/O6K F2t38AXtqqMLSQc8wgVfUhs=3D =3D0uxq -----END PGP SIGNATURE----- |
|
From: Lorenz T. <lo...@te...> - 2003-08-22 10:18:46
|
Hi Serge,
>
> I've fixed the BIGINT issue.
Thanks so much for fixing it so fast!
> Thanks for your testing perseverance. I'll join the diff on the latest=20=
> version of the sources:
> All version branches are corrected in CVS (version 1. -> 1.0.1, 2.1.0=20=
> - - -> 2.1.1 and 2.2.0 -> 2.2.1).
>
> I will shortly release the sources and binary package for the=20
> corrected version 2.2.1.
> Unless you're using version 1. for yourself, I will not release file=20=
> package of this one (version 2.2. has a script to make the packages...=20=
> I have to do things by hand for version 1 + I'm really hoping nobody=20=
> uses version 1 anymore).
>
> Still, if you use version 1, and not using CVS, I can send you the=20
> corrected sources for it.
Unfortunately I'm still having v1, because I'm using only the basic=20
features of the framework and I am sure that by now everything works=20
fine (I don't have the time by now for testing CocoaMySQL to be sure it=20=
works with the new framework).
I can download the source from CVS, thanks. Or I take the changes from=20=
the code attached at the end of the email (these are all changes=20
necesary, right?).
By the way, I have added some lines to the fetchRow methods which fixes=20=
problems with:
- timestamps other than default representation
- dates in formats like 0000-00-00 (which gives an error when trying to=20=
initialize a cocoa date object with a "null"-date)
If you want the diffs, just tell me!
>
> Serge.
>
> PS: I've tried both strtoll and strtoq.... despite its name strtoll is=20=
> NOT ok for long long (make a 32bit truncation of the result), so at=20
> the end only strtoq can do what we wanted.
Thanks again for fixing that. I have not much experience with C, so it=20=
would take me much time to solve such a problem...
> PPS: I'll try to check if their is a way to know if the field=20
> retrieved is unsigned, in which case I will adapt the code to also=20
> handle the unsigned int and bigint. If someone knows how to do that...=20=
> please spear me the search by myself (enlighten me... :-).
Can't you use the C API function mysql_fetch_fields() to get the=20
MYSQL_FIELD structure and then check if the flag UNSIGNED_FLAG is set?
Best Regards,
Lorenz
>
> diff --context=3D3 -r1.3 MCPResult.m
> *** MCPResult.m 16 Jan 2003 12:18:23 -0000 1.3
> - - --- MCPResult.m 21 Aug 2003 06:25:51 -0000
> ***************
> *** 257,272 ****
> }
> else {
> char *theData =3D =
calloc(sizeof(char),theLengths[i]+1);
> memcpy(theData, theRow[i],theLengths[i]);
> theData[theLengths[i]] =3D '\0';
>
> switch (theField[i].type) {
> case FIELD_TYPE_TINY:
> case FIELD_TYPE_SHORT:
> - - - case FIELD_TYPE_LONG:
> case FIELD_TYPE_INT24:
> case FIELD_TYPE_LONGLONG:
> ! theCurrentObj =3D [NSNumber=20
> numberWithLong:atol(theData)];
> break;
> case FIELD_TYPE_DECIMAL:
> case FIELD_TYPE_FLOAT:
> - - --- 257,275 ----
> }
> else {
> char *theData =3D =
calloc(sizeof(char),theLengths[i]+1);
> + char *theUselLess;
> memcpy(theData, theRow[i],theLengths[i]);
> theData[theLengths[i]] =3D '\0';
>
> switch (theField[i].type) {
> case FIELD_TYPE_TINY:
> case FIELD_TYPE_SHORT:
> case FIELD_TYPE_INT24:
> + case FIELD_TYPE_LONG:
> + theCurrentObj =3D =
[NSNumber numberWithLong:atol(theData)];
> + break;
> case FIELD_TYPE_LONGLONG:
> ! theCurrentObj =3D [NSNumber=20
> numberWithLongLong:strtoq(theData, &theUselLess, 0)];
> break;
> case FIELD_TYPE_DECIMAL:
> case FIELD_TYPE_FLOAT:
>
>
> Le mercredi, 20 ao=FB 2003, =E0 22:18 Europe/Amsterdam, Lorenz Textor =
a=20
> =E9crit :
>
>> Hi Serge,
>>
>> Thank you for your quick answer!
>>
>> I'm using an old version, but I have checked the current version and=20=
>> it seems to use the same method to get the numeric values.
>>
>> The field is of type BigInt and not unsigned, and the value is showed=20=
>> correctly in other tools. If I open the table in my app, it shows=20
>> always 2147483647 for values greater than this. I've tested it also=20=
>> with your MySQL Display app to be sure that it it is not an error of=20=
>> my app - with the same result.
>>
>> Please tell me if I should test it with the newest version of the=20
>> framework too! It's not that important, so look at it only if you=20
>> have the time... I'll also look at it, but I don't understand enough=20=
>> of this things (can it be a problem of the method numberWithLong: ?).
>>
>> Thanks very much for your work on the framework, it's really great!
>> Cheers,
>> Lorenz
>>
>>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.2.1 (Darwin)
>
> iD8DBQE/RKNB5EPeG5y7WPsRAi1iAJ980/xBi3PiJajwPaLJwBDMeSwXggCdEhPk
> BHkmv05uMQ5w9/VCIOTODV0=3D
> =3DhSlo
> -----END PGP SIGNATURE-----
>
>
>
--=20
lorenz textor
** sh **
eigerstrasse 21
8200 schaffhausen
tf 052 - 624 27 91
** ticino **
via delle scuole 41
6963 pregassona
tf 091 - 940 20 57
**
mobile 076 - 531 71 74
email lo...@te...
|
|
From: Serge C. <ser...@us...> - 2003-08-22 08:26:25
|
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
For some reasons... it looks like it did not get through this morning...
Repost
Hi Lorenz;
I've fixed the BIGINT issue.
Thanks for your testing perseverance. I'll join the diff on the latest=20=
version of the sources:
All version branches are corrected in CVS (version 1. -> 1.0.1, 2.1.0 -=20=
- -> 2.1.1 and 2.2.0 -> 2.2.1).
I will shortly release the sources and binary package for the corrected=20=
version 2.2.1.
Unless you're using version 1. for yourself, I will not release file=20
package of this one (version 2.2. has a script to make the packages...=20=
I have to do things by hand for version 1 + I'm really hoping nobody=20
uses version 1 anymore).
Still, if you use version 1, and not using CVS, I can send you the=20
corrected sources for it.
Serge.
PS: I've tried both strtoll and strtoq.... despite its name strtoll is=20=
NOT ok for long long (make a 32bit truncation of the result), so at the=20=
end only strtoq can do what we wanted.
PPS: I'll try to check if their is a way to know if the field retrieved=20=
is unsigned, in which case I will adapt the code to also handle the=20
unsigned int and bigint. If someone knows how to do that... please=20
spear me the search by myself (enlighten me... :-).
diff --context=3D3 -r1.3 MCPResult.m
*** MCPResult.m 16 Jan 2003 12:18:23 -0000 1.3
- - --- MCPResult.m 21 Aug 2003 06:25:51 -0000
***************
*** 257,272 ****
}
else {
char *theData =3D =
calloc(sizeof(char),theLengths[i]+1);
memcpy(theData, theRow[i],theLengths[i]);
theData[theLengths[i]] =3D '\0';
switch (theField[i].type) {
case FIELD_TYPE_TINY:
case FIELD_TYPE_SHORT:
- - - case FIELD_TYPE_LONG:
case FIELD_TYPE_INT24:
case FIELD_TYPE_LONGLONG:
! theCurrentObj =3D [NSNumber=20
numberWithLong:atol(theData)];
break;
case FIELD_TYPE_DECIMAL:
case FIELD_TYPE_FLOAT:
- - --- 257,275 ----
}
else {
char *theData =3D =
calloc(sizeof(char),theLengths[i]+1);
+ char *theUselLess;
memcpy(theData, theRow[i],theLengths[i]);
theData[theLengths[i]] =3D '\0';
switch (theField[i].type) {
case FIELD_TYPE_TINY:
case FIELD_TYPE_SHORT:
case FIELD_TYPE_INT24:
+ case FIELD_TYPE_LONG:
+ theCurrentObj =3D =
[NSNumber numberWithLong:atol(theData)];
+ break;
case FIELD_TYPE_LONGLONG:
! theCurrentObj =3D [NSNumber=20
numberWithLongLong:strtoq(theData, &theUselLess, 0)];
break;
case FIELD_TYPE_DECIMAL:
case FIELD_TYPE_FLOAT:
Le mercredi, 20 ao=FB 2003, =E0 22:18 Europe/Amsterdam, Lorenz Textor a=20=
=E9crit :
> Hi Serge,
>
> Thank you for your quick answer!
>
> I'm using an old version, but I have checked the current version and=20=
> it seems to use the same method to get the numeric values.
>
> The field is of type BigInt and not unsigned, and the value is showed=20=
> correctly in other tools. If I open the table in my app, it shows=20
> always 2147483647 for values greater than this. I've tested it also=20
> with your MySQL Display app to be sure that it it is not an error of=20=
> my app - with the same result.
>
> Please tell me if I should test it with the newest version of the=20
> framework too! It's not that important, so look at it only if you have=20=
> the time... I'll also look at it, but I don't understand enough of=20
> this things (can it be a problem of the method numberWithLong: ?).
>
> Thanks very much for your work on the framework, it's really great!
> Cheers,
> Lorenz
>
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (Darwin)
iD8DBQE/RKNB5EPeG5y7WPsRAi1iAJ980/xBi3PiJajwPaLJwBDMeSwXggCdEhPk
BHkmv05uMQ5w9/VCIOTODV0=3D
=3DhSlo
-----END PGP SIGNATURE-----
|
|
From: Serge C. <ser...@us...> - 2003-08-21 10:52:50
|
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi Lorenz;
I've fixed the BIGINT issue.
Thanks for your testing perseverance. I'll join the diff on the latest=20=
version of the sources:
All version branches are corrected in CVS (version 1. -> 1.0.1, 2.1.0 -=20=
-> 2.1.1 and 2.2.0 -> 2.2.1).
I will shortly release the sources and binary package for the corrected=20=
version 2.2.1.
Unless you're using version 1. for yourself, I will not release file=20
package of this one (version 2.2. has a script to make the packages...=20=
I have to do things by hand for version 1 + I'm really hoping nobody=20
uses version 1 anymore).
Still, if you use version 1, and not using CVS, I can send you the=20
corrected sources for it.
Serge.
PS: I've tried both strtoll and strtoq.... despite its name strtoll is=20=
NOT ok for long long (make a 32bit truncation of the result), so at the=20=
end only strtoq can do what we wanted.
PPS: I'll try to check if their is a way to know if the field retrieved=20=
is unsigned, in which case I will adapt the code to also handle the=20
unsigned int and bigint. If someone knows how to do that... please=20
spear me the search by myself (enlighten me... :-).
diff --context=3D3 -r1.3 MCPResult.m
*** MCPResult.m 16 Jan 2003 12:18:23 -0000 1.3
- --- MCPResult.m 21 Aug 2003 06:25:51 -0000
***************
*** 257,272 ****
}
else {
char *theData =3D =
calloc(sizeof(char),theLengths[i]+1);
memcpy(theData, theRow[i],theLengths[i]);
theData[theLengths[i]] =3D '\0';
switch (theField[i].type) {
case FIELD_TYPE_TINY:
case FIELD_TYPE_SHORT:
- - case FIELD_TYPE_LONG:
case FIELD_TYPE_INT24:
case FIELD_TYPE_LONGLONG:
! theCurrentObj =3D [NSNumber=20
numberWithLong:atol(theData)];
break;
case FIELD_TYPE_DECIMAL:
case FIELD_TYPE_FLOAT:
- --- 257,275 ----
}
else {
char *theData =3D =
calloc(sizeof(char),theLengths[i]+1);
+ char *theUselLess;
memcpy(theData, theRow[i],theLengths[i]);
theData[theLengths[i]] =3D '\0';
switch (theField[i].type) {
case FIELD_TYPE_TINY:
case FIELD_TYPE_SHORT:
case FIELD_TYPE_INT24:
+ case FIELD_TYPE_LONG:
+ theCurrentObj =3D =
[NSNumber numberWithLong:atol(theData)];
+ break;
case FIELD_TYPE_LONGLONG:
! theCurrentObj =3D [NSNumber=20
numberWithLongLong:strtoq(theData, &theUselLess, 0)];
break;
case FIELD_TYPE_DECIMAL:
case FIELD_TYPE_FLOAT:
Le mercredi, 20 ao=FB 2003, =E0 22:18 Europe/Amsterdam, Lorenz Textor a=20=
=E9crit :
> Hi Serge,
>
> Thank you for your quick answer!
>
> I'm using an old version, but I have checked the current version and=20=
> it seems to use the same method to get the numeric values.
>
> The field is of type BigInt and not unsigned, and the value is showed=20=
> correctly in other tools. If I open the table in my app, it shows=20
> always 2147483647 for values greater than this. I've tested it also=20
> with your MySQL Display app to be sure that it it is not an error of=20=
> my app - with the same result.
>
> Please tell me if I should test it with the newest version of the=20
> framework too! It's not that important, so look at it only if you have=20=
> the time... I'll also look at it, but I don't understand enough of=20
> this things (can it be a problem of the method numberWithLong: ?).
>
> Thanks very much for your work on the framework, it's really great!
> Cheers,
> Lorenz
>
>
- ----------------------------------------------------
Serge Cohen
GPG Key ID: 9CBB58FB
- ----------------------------------------------------
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (Darwin)
iD8DBQE/RGsx5EPeG5y7WPsRAhdVAKDSofXJ7ALF3a1Jqv3nwykO70baOACfTYJf
US/yzmBcwXEsCZturGRIrXE=3D
=3DOtYY
-----END PGP SIGNATURE-----
|
|
From: Serge C. <ser...@us...> - 2003-08-21 02:17:13
|
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi Lorenz;
Following your last mail, I just tried to understand what I was=20
missing... and I found it (meaning we might be halfway to solving the=20
problem)...
I've wrote a small program to check the size of the different integer=20
types on MacOSX :
#include <stdio.h>
int main(int argc, char **argv)
{
printf("short : %d, int : %d, long : %d, long* : %d, long long : %d,=20=
void* : %d\n",
sizeof(short),sizeof(int), sizeof(long), sizeof(long *),=20
sizeof(long long), sizeof(void*));
return 0;
}
if you compile it (gcc -o sizetst sizes.c), and run it (sizetst), you=20
get the memory size of these types:
short : 2, int : 4, long : 4, long* : 4, long long : 8, void* : 4
^^^^^^^^
And then I realised that long was indeed (as int) a 32 bit integer, to=20=
have a 64bit integer one need to use long long...
SO to correct the list I've sent in my last time, one should have=20
indeed:
* SMALLINT : 16 bits (short int in C).
* MEDIUMINT : 24 bits (inexistent in C).
* INT or INTEGER : 32 bits (int in C).
* BIGINT : 64 bits (long long in C) -- was long int in the previous=20
(wrong) list --.
So now that I've understand what the problem is, I still have to find a=20=
way to correct that... The problem being that I don't know any function=20=
in C which is able to parse an integer into a long long... (and I don't=20=
manage to find my Kernigam & Richie in my library...).
As soon as I find the solution, I'll post it here, and correct the=20
framework.
Serge.
PS: indeed I also have to thank you for the MySQL front-end you are=20
maintaining, it is very useful.
Le mercredi, 20 ao=FB 2003, =E0 22:18 Europe/Amsterdam, Lorenz Textor a=20=
=E9crit :
> Hi Serge,
>
> Thank you for your quick answer!
>
> I'm using an old version, but I have checked the current version and=20=
> it seems to use the same method to get the numeric values.
>
> The field is of type BigInt and not unsigned, and the value is showed=20=
> correctly in other tools. If I open the table in my app, it shows=20
> always 2147483647 for values greater than this. I've tested it also=20
> with your MySQL Display app to be sure that it it is not an error of=20=
> my app - with the same result.
>
> Please tell me if I should test it with the newest version of the=20
> framework too! It's not that important, so look at it only if you have=20=
> the time... I'll also look at it, but I don't understand enough of=20
> this things (can it be a problem of the method numberWithLong: ?).
>
> Thanks very much for your work on the framework, it's really great!
> Cheers,
> Lorenz
>
- ----------------------------------------------------
Serge Cohen
GPG Key ID: 9CBB58FB
- ----------------------------------------------------
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (Darwin)
iD8DBQE/Q/z05EPeG5y7WPsRApFTAKCoydRlZ15rAI2S1hxL3qK1aCmlvwCggJas
QIf/mOa9xU17KgI4agoewHE=3D
=3DR9n2
-----END PGP SIGNATURE-----
|
|
From: Lorenz T. <lo...@te...> - 2003-08-20 20:34:59
|
Hi Serge, Thank you for your quick answer! I'm using an old version, but I have checked the current version and it=20= seems to use the same method to get the numeric values. The field is of type BigInt and not unsigned, and the value is showed=20 correctly in other tools. If I open the table in my app, it shows=20 always 2147483647 for values greater than this. I've tested it also=20 with your MySQL Display app to be sure that it it is not an error of my=20= app - with the same result. Please tell me if I should test it with the newest version of the=20 framework too! It's not that important, so look at it only if you have=20= the time... I'll also look at it, but I don't understand enough of this=20= things (can it be a problem of the method numberWithLong: ?). Thanks very much for your work on the framework, it's really great! Cheers, Lorenz On Tuesday, Aug 19, 2003, at 13:27 Europe/Rome, Serge Cohen wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Hi > > If I understand properly the MySQL documentation, we have the=20 > following sizes for integer storage: > > - - SMALLINT : 16 bits (short int in C). > - - MEDIUMINT : 24 bits (inexistent in C). > - - INT or INTEGER : 32 bits (int in C). > - - BIGINT : 64 bits (long int in C). > > So I don't see why the atol function should not work properly for=20 > integers in the range -9223372036854775808 to 9223372036854775807=20 > (though I guess it will not be happy if you use UNSIGNED BIGINT, which=20= > are corresponding to unsigned long int... which atol can not produce,=20= > you will get unexepected result with UNSIGNED BIGINT >=20 > 9223372036854775807)... > > So from the documentation of both MySQL, atol (from stdlib) and=20 > NSNumber, I don't understand why there should be a problem for=20 > integers in the 2147483647 to 9223372036854775807 range. > Maybe I'm also missing something here??? > > > I'm sorry to be a bit untrusty... but can you confirm the problem=20 > (then I'll know for sure that I am missing something): > - - You have a BIGINT column type in you retrieved table. > - - It contains a number in the range 2147483647 to=20 > 9223372036854775807. > - - When you look at it using ie. mysql it appears Ok. > - - BUT if you retrieve the exact same information using the SMySQL=20 > framework you get a wrong number. > > If you can confirm that I properly (or not) understand your remark,=20 > I'll try my best to fix the problem (and if I did not understand your=20= > bug report, can you try to explain it in a different way). > > Thanks for the feedback. > > Serge. > > PS: Can you also tell me which version of the framework you are using. > > Le mardi, 19 ao=FB 2003, =E0 11:45 Europe/Amsterdam, Lorenz Textor a = =E9crit=20 > : > >> Hi everybody, >> >> It seems that in the SMySQL framework BigInt data types are limited=20= >> to a max value of 2147483647, while MySQL allows 64 (63) bit integer=20= >> values. Does anybody know how to fix that? I think that the=20 >> [NSNumber numberWithLong:atol(theData)]; isn't appropriate for BigInt=20= >> values, but I'm not sure what would be right here... >> >> Thanks for your help >> Lorenz >> >> >> Mysql-cocoa-users mailing list >> Mys...@li... >> https://lists.sourceforge.net/lists/listinfo/mysql-cocoa-users >> >> > - ---------------------------------------------------- > Serge Cohen > > GPG Key ID: 9CBB58FB > - ---------------------------------------------------- > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.2.1 (Darwin) > > iD8DBQE/QgmO5EPeG5y7WPsRAtmJAJwMZ0xRFJoSbe0OfyiQxjs6uvzanwCgjWIm > OPsZh3HkJ6dU+58v+mQf7Ck=3D > =3D4BO1 > -----END PGP SIGNATURE----- > > --=20 lorenz textor ** sh ** eigerstrasse 21 8200 schaffhausen tf 052 - 624 27 91 ** ticino ** via delle scuole 41 6963 pregassona tf 091 - 940 20 57 ** mobile 076 - 531 71 74 email lo...@te... |
|
From: Serge C. <ser...@us...> - 2003-08-19 11:26:55
|
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi=0D =0D If I understand properly the MySQL documentation, we have the following =0D= sizes for integer storage:=0D =0D - - SMALLINT : 16 bits (short int in C).=0D - - MEDIUMINT : 24 bits (inexistent in C).=0D - - INT or INTEGER : 32 bits (int in C).=0D - - BIGINT : 64 bits (long int in C).=0D =0D So I don't see why the atol function should not work properly for =0D integers in the range -9223372036854775808 to 9223372036854775807 =0D (though I guess it will not be happy if you use UNSIGNED BIGINT, which =0D= are corresponding to unsigned long int... which atol can not produce, =0D= you will get unexepected result with UNSIGNED BIGINT > =0D 9223372036854775807)...=0D =0D So from the documentation of both MySQL, atol (from stdlib) and =0D NSNumber, I don't understand why there should be a problem for integers =0D= in the 2147483647 to 9223372036854775807 range.=0D Maybe I'm also missing something here???=0D =0D =0D I'm sorry to be a bit untrusty... but can you confirm the problem (then =0D= I'll know for sure that I am missing something):=0D - - You have a BIGINT column type in you retrieved table.=0D - - It contains a number in the range 2147483647 to 9223372036854775807.=0D= - - When you look at it using ie. mysql it appears Ok.=0D - - BUT if you retrieve the exact same information using the SMySQL =0D framework you get a wrong number.=0D =0D If you can confirm that I properly (or not) understand your remark, =0D I'll try my best to fix the problem (and if I did not understand your =0D= bug report, can you try to explain it in a different way).=0D =0D Thanks for the feedback.=0D =0D Serge.=0D =0D PS: Can you also tell me which version of the framework you are using.=0D= =0D Le mardi, 19 ao=FB 2003, =E0 11:45 Europe/Amsterdam, Lorenz Textor a = =E9crit :=0D =0D > Hi everybody,=0D >=0D > It seems that in the SMySQL framework BigInt data types are limited to = =0D > a max value of 2147483647, while MySQL allows 64 (63) bit integer =0D > values. Does anybody know how to fix that? I think that the [NSNumber = =0D > numberWithLong:atol(theData)]; isn't appropriate for BigInt values, =0D= > but I'm not sure what would be right here...=0D >=0D > Thanks for your help=0D > Lorenz=0D >=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: 9CBB58FB=0D - ----------------------------------------------------=0D -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (Darwin) iD8DBQE/QgmO5EPeG5y7WPsRAtmJAJwMZ0xRFJoSbe0OfyiQxjs6uvzanwCgjWIm OPsZh3HkJ6dU+58v+mQf7Ck=3D =3D4BO1 -----END PGP SIGNATURE----- |
|
From: Lorenz T. <lo...@te...> - 2003-08-19 09:45:16
|
Hi everybody, It seems that in the SMySQL framework BigInt data types are limited to a max value of 2147483647, while MySQL allows 64 (63) bit integer values. Does anybody know how to fix that? I think that the [NSNumber numberWithLong:atol(theData)]; isn't appropriate for BigInt values, but I'm not sure what would be right here... Thanks for your help Lorenz |
|
From: Jerome R. <jer...@fn...> - 2003-08-18 21:18:52
|
Are you sure you can connect to your database from outside? Verty often, when domains are hosted by providers (with packages such =20= as PHP+MySQL), it is not possible to connect except from the localhost. On Monday, August 18, 2003, at 05:45 PM, ken penn wrote: > Can someone help me conenct to mySQL databse over the net? > > I have use the domain name and ip numebr and still cant connect..i =20 > must be > doing something wrong. > > I don=92t need http:// for the domain name do I? > > Please help > > > > ------------------------------------------------------- > This SF.Net email sponsored by: Free pre-built ASP.NET sites including > Data Reports, E-commerce, Portals, and Forums are available now. > Download today and enter to win an XBOX or Visual Studio .NET. > http://aspnet.click-url.com/go/psa00100003ave/=20 > direct;at.aspnet_072303_01/01 > _______________________________________________ > Mysql-cocoa-users mailing list > Mys...@li... > https://lists.sourceforge.net/lists/listinfo/mysql-cocoa-users > |
|
From: ken p. <ke...@mo...> - 2003-08-18 16:00:38
|
Can someone help me conenct to mySQL databse over the net? I have use the domain name and ip numebr and still cant connect..i must be doing something wrong. I don=B9t need http:// for the domain name do I? Please help |
|
From: Serge C. <ser...@us...> - 2003-08-18 14:05:23
|
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 A new version of the framework is now available on the mysql-cocoa web site (http://sourceforge.net/projects/mysql-cocoa/), under version 2.2.0. The main difference is not the sources (indeed very little changes on this side, if any), but rather the organisation of the project (in Project Builder), together with a redefinition of the targets. I'll try to comment a bit on that later (and also to update the website).... If you were happy with the version 2.0.0 (fully API compatible with 2.2.0) and never build it yourself (or only the very first time), you can forget about this release. If, on the other you had problems to use the version 2.0.0 for problems in the documentation, or understanding how the project (Project Builder) was organised, than you might find this new release much more friendly (at least I hope so). Last, the binaries coming in the version 2.2.0 is much easier to use than the previous distribution. You get directly the 3 flavours of the framework: 1. System-Wide framework, linked to libmysqlclient.dylib (you have to have the library yourself). 2. System-wide but statically linked to libmysqlclient.a (you don't need any library preinstalled, runs outside of the .dmg). 3. Framework version to be bundled with a Cocoa application. It also contains a small CLI program testing the framework, which in turn requires that MySQL server is running on localhost (and you have to run a mysql script to generate/populate the DB used by the CLI_Test program). I also hope the readme files are a bit easier to read.... More on all that later. Serge. PS: Soon also new features in the frameworks!!!! - ---------------------------------------------------- Serge Cohen GPG Key ID: 9CBB58FB - ---------------------------------------------------- -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (Darwin) iD8DBQE/QNIH5EPeG5y7WPsRAnwoAJ9gFxwJ0lUVCIBSkFXrEW3U2Es5dQCdGH5o SghOB9zcdf1UeT8oDXjLmQ8= =39vV -----END PGP SIGNATURE----- |
|
From: Serge C. <ser...@us...> - 2003-08-16 16:32:20
|
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi Jonathan; I'm working on a new packaging of the SMySQL framework. Hopefully it=20 should be ready and available by the end of the WE. I hope that you can wait these fews days of delay, then the package=20 will be really strait forward to use (and binaries will also be=20 available, which much easier installation). The main problems you are encountering comes from the fact that the=20 package you are using (and the documentation coming with it) are quite=20= old, and I had no time recently (past 8 month or so) to update all=20 this. This is what I've planned for my WE, and I think it is reasonable=20= to think that I'll managed to finish by then. Sorry not to give you the immediate remedy, but that would take half of=20= the time I need to fix the packages in order to have it easy to install=20= for every body. Last but not least, can you please subscribe to the mysql-cocoa user=20 list (http://lists.sourceforge.net/lists/listinfo/mysql-cocoa-users)=20 for any further questions? There are on the list a couple of person=20 which are also able to help you, so that you might get better/faster=20 answer (and also the mails are archived, so new users having same=20 question/problems as you do could benefit of past exchanges). Note that the list anyhow has low/very low traffic and is a good way to=20= get informed when a new version of the framework is ready. Thanks for using (soon?) SMySQL, do not hesitate to send=20 question/demands.... to the list. Serge. Le vendredi, 15 ao=FB 2003, =E0 22:49 Europe/Amsterdam, Jonathan McGuire = a=20 =E9crit : > Hi Serge, > > I'd like to try out your MySQL frame work but I'm not sure how to get=20= > the libmysqlclient.dylib file compiled properly. I took a look at=20 > http://mysql-cocoa.sourceforge.net/Doc/HowTo_Build_MySQL.rtf but I=20 > already have MySQL installed. I used the package provided by the mysql=20= > site <http://www.mysql.com/downloads/mysql-4.0.html> I'd like to get=20= > your framework working on my system using that package. I was hopeful=20= > that it would be very simple to get installed since you provided a=20 > package installer but then I hit the libmysqlclient.dylib stumbling=20 > block. > > Any help would be appreciated. > > Jonathan > > > > - ---------------------------------------------------- Serge Cohen GPG Key ID: 9CBB58FB - ---------------------------------------------------- -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (Darwin) iD8DBQE/PlyP5EPeG5y7WPsRAmhgAJwLCmF2iYlvauuZtDiQimiBNgi/jQCgqUOP sZXrTYRkcIK1BN1tIsrmN5Y=3D =3DLZlK -----END PGP SIGNATURE----- |
