Hello All, Just a short note to see if anyone has some SimpleORM/Java consulting opportunities that could be addressed remotely from my rain forrest retreat in...
Anthony & Melissa Ber...
berglas@...
Aug 4, 2004 4:05 am
897
Hi there. My wife gave birth to our second child and I have been somewhat lacking wrt simpleorm these past few months. 1) The recordset thing with MSSQL is...
Hi, congratulations to your newborn! Thanks for the reply to my queries. Rg. .NET implementation of SimpleORM what would the possible goals be that justify the...
1) Multiple Recordsets This is a point often misunderstood so I will re-explain it. In ADO.NET there are 2 ways of gettings records from a database : ...
Hello Sylvain, Congratulations on your baby! I have my second due in November. To your points below:- 1. Multiple Recordsets Wow! That is a pretty heavy...
Anthony & Melissa Ber...
berglas@...
Aug 6, 2004 7:35 am
901
Let me start by saying that I too would hate to fork beeing lazy and all. ;-) 1. Multiple Recordsets Carefull there. I dont want to spread misinformation. You...
Hello Bartek, ... Thanks for this. A secondary issue is that the JDBC drievers used to have bugs involved with this. ... .Net does not use toString either,...
Anthony & Melissa Ber...
berglas@...
Sep 2, 2004 6:07 am
903
Hello All, I am in the process of cutting a new version of SimpleORM, integrating many features from Bartek Muszynski and others. One change that has been...
Anthony & Melissa Ber...
berglas@...
Sep 14, 2004 11:56 pm
904
Hello Bartek, Thanks again for your contribution. I have been running your code, adding joins etc. to the examples etc. The biggest thing that you have done...
Anthony & Melissa Ber...
berglas@...
Sep 15, 2004 4:11 am
905
Hi, no objections to SCon. The changes required in our code are quite straight forward. Another idea: I have been struggling to get an array of Integers or...
Hello Alexander, I'm not sure what you want with the IN methods. I don't think that JDBC properly supports IN at all, at least not in a standard way. You can...
Anthony & Melissa Ber...
berglas@...
Sep 16, 2004 5:35 am
907
There will be two methods. getReference(field) will query the database if necessary to provide the referenced value. getReferenceNoQuery(field) // new will...
Anthony & Melissa Ber...
berglas@...
Sep 16, 2004 7:45 am
908
I don't quite understand either query. But I have added test cases to check isDirty and references. It all seems to work for me. Anthony...
Anthony & Melissa Ber...
berglas@...
Sep 16, 2004 7:49 am
909
Hi, here is another help I use quite extensively when building table search forms. The function takes in a string to search for and the type of search. ...
Hi Anthony, maybe you can add these function to SQuery class to help with the IN operator. (feel free to remove or keep @author). This function can be ...
Hello All, I have put up a draft of a new version of SimpleORM. It incorporates many changes proposed by others, but is not finished. But any initial ...
Anthony & Melissa Ber...
berglas@...
Sep 18, 2004 11:34 am
912
Done in upcomming release. For some reason that I am unclear of Bartek implemented this using ORs. I've changed it to use IN. But are there any known problems...
Anthony & Melissa Ber...
berglas@...
Sep 18, 2004 11:36 am
913
Hello Joseph, I have added the code, having uncopied the create table stuff. It looks OK but I have not tested it on MySQL. I'm wondering if it would be a ...
Anthony & Melissa Ber...
berglas@...
Sep 18, 2004 11:36 am
914
Hello Philippe, I'll look at this. Issues:- 1. The semantics of OFFSET (in a different transaction) are not that well defined. You could miss records that...
Anthony & Melissa Ber...
berglas@...
Sep 18, 2004 11:36 am
915
Hello Sylvain, I think that Bartek's new join code will address this problem nicely. But to be clear I would expect your code to generate something like ...
Anthony & Melissa Ber...
berglas@...
Sep 18, 2004 11:36 am
916
Added....
Anthony & Melissa Ber...
berglas@...
Sep 18, 2004 11:36 am
917
Done, thanks. Sylvain, is my use of java.util.Iterator.remove() break .Net? It is Java2. Regards, Anthony...
Anthony & Melissa Ber...
berglas@...
Sep 18, 2004 11:36 am
918
Hello Sylvain, ne, isNull and isNotNull now can all take reference arguments. Anthony...
Anthony & Melissa Ber...
berglas@...
Sep 18, 2004 11:36 am
919
Done, the methods are deprecated and renamed *DB*. Anthony...
Anthony & Melissa Ber...
berglas@...
Sep 18, 2004 11:36 am
920
Hello Joe, Thanks for this, I've gone through and incorporated most of the changes. Not sure about the TestUte. Anthony...
Anthony & Melissa Ber...
berglas@...
Sep 18, 2004 11:36 am
921
Hello Sylvain, I have added SJSharp.newInteger, isInteger etc. so that you could have the J# version use native .Net data types. Could you please send me the...
Anthony & Melissa Ber...
berglas@...
Sep 18, 2004 11:36 am
922
In SQL NULL = NULL. I could automatically convert this to an IS NOT NULL test but felt that that might be getting a bit to clever. What do people think? IS...
Anthony & Melissa Ber...
berglas@...
Sep 18, 2004 11:37 am
923
I have uploaded this to www.groups.yahoo.com/simpleorm. Did remove the extends SConstants/SCon, decided not to wait for Java 1.5. Added a parameter mechanism...
Anthony & Melissa Ber...
berglas@...
Sep 20, 2004 10:53 am
924
Hello Anthony, yes, we're using MS SQL Server with SimpleORM extensively (I'm going to repond to some of your messages in the next few days, I just don't have...