Re: WOCheckBoxList
fixed in future version On Jul 11, 2009, at 12:59 AM, David Holt wrote: It seems there's a bug in WO 5.4.x with this component. I've experienced and I've seen a couple of emails to the list asking about this behaviour. It shows up as input fields instead of checkboxes. At least you found a workaround! David On 10-Jul-09, at 8:21 PM, Chuck Hill wrote: On Jul 10, 2009, at 7:56 PM, Paul D Yu wrote: Greetings I'm using WOCheckBoxList component for the first time. When I use this, without type=checkbox wo:checkBoxList list=$derts item = $dertItem displayString = $dertItem.displayCode selections = $recommendations / I get normal input fields in the browser, which is not what I want. So I have to add the type=checkbox to the declaration. wo:checkBoxList list=$derts item = $dertItem displayString = $dertItem.displayCode selections = $recommendations type=checkbox / Is this correct? Seems like it should default to type=checkbox right? or did I do something wrong? Paul Which version of WO? I'd say bug as the docs do not indicate this and neither does the class name. File it, Dano. Chuck -- Chuck Hill Senior Consultant / VP Development Learn WO at WOWODC'09 East in Montréal this August! http://www.wocommunity.org/wowodc09/east http://arstechnica.com/apple/news/2009/07/webobjects-sliced-from-106but-prognosis-of-death-premature.ars ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/programmingosx%40mac.com This email sent to programming...@mac.com ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/mschrag%40mdimension.com This email sent to msch...@mdimension.com ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
WOCheckBoxList
Greetings I'm using WOCheckBoxList component for the first time. When I use this, without type=checkbox wo:checkBoxList list=$derts item = $dertItem displayString = $dertItem.displayCode selections = $recommendations / I get normal input fields in the browser, which is not what I want. So I have to add the type=checkbox to the declaration. wo:checkBoxList list=$derts item = $dertItem displayString = $dertItem.displayCode selections = $recommendations type=checkbox / Is this correct? Seems like it should default to type=checkbox right? or did I do something wrong? Paul ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: WOCheckBoxList
On Jul 10, 2009, at 7:56 PM, Paul D Yu wrote: Greetings I'm using WOCheckBoxList component for the first time. When I use this, without type=checkbox wo:checkBoxList list=$derts item = $dertItem displayString = $dertItem.displayCode selections = $recommendations / I get normal input fields in the browser, which is not what I want. So I have to add the type=checkbox to the declaration. wo:checkBoxList list=$derts item = $dertItem displayString = $dertItem.displayCode selections = $recommendations type=checkbox / Is this correct? Seems like it should default to type=checkbox right? or did I do something wrong? Paul Which version of WO? I'd say bug as the docs do not indicate this and neither does the class name. File it, Dano. Chuck -- Chuck Hill Senior Consultant / VP Development Learn WO at WOWODC'09 East in Montréal this August! http://www.wocommunity.org/wowodc09/east http://arstechnica.com/apple/news/2009/07/webobjects-sliced-from-106but-prognosis-of-death-premature.ars ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: WOCheckBoxList
It seems there's a bug in WO 5.4.x with this component. I've experienced and I've seen a couple of emails to the list asking about this behaviour. It shows up as input fields instead of checkboxes. At least you found a workaround! David On 10-Jul-09, at 8:21 PM, Chuck Hill wrote: On Jul 10, 2009, at 7:56 PM, Paul D Yu wrote: Greetings I'm using WOCheckBoxList component for the first time. When I use this, without type=checkbox wo:checkBoxList list=$derts item = $dertItem displayString = $dertItem.displayCode selections = $recommendations / I get normal input fields in the browser, which is not what I want. So I have to add the type=checkbox to the declaration. wo:checkBoxList list=$derts item = $dertItem displayString = $dertItem.displayCode selections = $recommendations type=checkbox / Is this correct? Seems like it should default to type=checkbox right? or did I do something wrong? Paul Which version of WO? I'd say bug as the docs do not indicate this and neither does the class name. File it, Dano. Chuck -- Chuck Hill Senior Consultant / VP Development Learn WO at WOWODC'09 East in Montréal this August! http://www.wocommunity.org/wowodc09/east http://arstechnica.com/apple/news/2009/07/webobjects-sliced-from-106but-prognosis-of-death-premature.ars ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/programmingosx%40mac.com This email sent to programming...@mac.com ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
Re: WOCheckBoxList
I've seen this exact thing as well. I haven't pursued it because my use of it was in a test component not seen by the rest of the World. I'm not sure though if it started with WO 5.4.3 or when I moved the app to Wonder. It could have been the former but for some reason at the time I thought it was the latter. Tim On Jul 10, 2009, at 9:59 PM, David Holt wrote: It seems there's a bug in WO 5.4.x with this component. I've experienced and I've seen a couple of emails to the list asking about this behaviour. It shows up as input fields instead of checkboxes. At least you found a workaround! David On 10-Jul-09, at 8:21 PM, Chuck Hill wrote: On Jul 10, 2009, at 7:56 PM, Paul D Yu wrote: Greetings I'm using WOCheckBoxList component for the first time. When I use this, without type=checkbox wo:checkBoxList list=$derts item = $dertItem displayString = $dertItem.displayCode selections = $recommendations / I get normal input fields in the browser, which is not what I want. So I have to add the type=checkbox to the declaration. wo:checkBoxList list=$derts item = $dertItem displayString = $dertItem.displayCode selections = $recommendations type=checkbox / Is this correct? Seems like it should default to type=checkbox right? or did I do something wrong? Paul Which version of WO? I'd say bug as the docs do not indicate this and neither does the class name. File it, Dano. Chuck -- Chuck Hill Senior Consultant / VP Development Learn WO at WOWODC'09 East in Montréal this August! http://www.wocommunity.org/wowodc09/east http://arstechnica.com/apple/news/2009/07/webobjects-sliced-from-106but-prognosis-of-death-premature.ars ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/programmingosx%40mac.com This email sent to programming...@mac.com ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/lists%40thetimmy.com This email sent to li...@thetimmy.com ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
WOCheckBoxList is not working in WO-5.4
Hi, We are trying to migrate our application deployment environment from WebObjects 5.2 to WebObjects 5.4. In some of the WOComponents, we are making use of WOCheckBoxList and WOCheckboxMatrix elements. In WO5.2, WOCheckBoxList is working fine and we are able to view the check boxes. But in WO5.4, WOCheckBoxList is displaying as a text box with values 0,1,2 etc., I came to know that some of these dynamic elements are deprecated in WebObjects 5. Is there any way to make WOCheckBoxList work in WebObjects 5.4 version? Thanks Regards, Kalpana. ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
WOCheckBoxList...what happeend?
Hi, We're using the WOCheckbox with WO 5.2, however, now that we switched to WO 5.4 the check box, looks more like a text box...has it been deprecated? I tried to use WOCheckboxMatrix, however, it does not seem to like my displayString property...am I missing something here? Thanks in advance Happy Thanksgiving! ~Mersida ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
Re: WOCheckBoxList...what happeend?
I believe that with WOCheckboxMatrix you don't use a display string as a parameter of the Matrix, you next it inside as a WOString: webobject name=MyCheckboxMatrix webobject name = DisplayString/ /webobject Dave On Nov 26, 2008, at 8:47 AM, Mersida Kurti wrote: Hi, We're using the WOCheckbox with WO 5.2, however, now that we switched to WO 5.4 the check box, looks more like a text box...has it been deprecated? I tried to use WOCheckboxMatrix, however, it does not seem to like my displayString property...am I missing something here? Thanks in advance Happy Thanksgiving! ~Mersida ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/webobjects%40avendasora.com This email sent to [EMAIL PROTECTED] ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
Re: Error on saveChanges with WOBrowser or WOCheckBoxList
Is your PK a class property? Does it need to be? I have seen problems before with PK as a class property that EOF tries to overwrite (this is not supposed to happen, but you decrease your odds by making it a non-class property). On your relationship, are you setting propagates primary key and/or owns destination? That can have an impact on how PK's are treated as well. On Feb 12, 2008, at 3:51 PM, Chuck Hill wrote: Maybe Anjo knows. :-) What are the delete rules? I have seen this sort of thing before, but I can't recall what caused it. Chuck On Feb 12, 2008, at 12:35 PM, Sennikov, Dimitri wrote: Thanks, Due to lack of other options, I have tried switching to using No Prototype and setting a custom Data Type to NSArray. I don't see much change and it still ends up trying to NULLIFY the department IDs. I have also tried now to no success passing a String departmentName from the WOBrowser. I then fetch Department EO from the database using departmentName and use addObjectToBothSidesOfRelationshipWithKey(departmentEO, departments); It still produces the SET ID = NULL erroneous sql statement. Chuck, any suggestions now that it is immutable type? Any input is appreciated. Dmitri -Original Message- From: Anjo Krank [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 12, 2008 3:04 PM To: Chuck Hill Cc: Sennikov, Dimitri; WebObjects Dev Apple Subject: Re: Error on saveChanges with WOBrowser or WOCheckBoxList Dimitri, Am 12.02.2008 um 20:47 schrieb Chuck Hill: Using mutable classes as attributes is a very, very, very bad idea. I know, I have tried it. EOF expects attributes to be immutable. Make it immutable and add cover methods to add and remove items. Until you fix this, there is no point in looking at the ID getting set to null problem. Pay no heed to Chuck's ramblings. You should be OK as long as your don't change the array directly. It would be best if you defined your accessors an returning NSArray. Cheers, Anjo -- Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems. http://www.global-village.net/products/practical_webobjects ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/mschrag%40mdimension.com This email sent to [EMAIL PROTECTED] ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
Re: Error on saveChanges with WOBrowser or WOCheckBoxList
Maybe Anjo knows. :-) What are the delete rules? I have seen this sort of thing before, but I can't recall what caused it. Chuck On Feb 12, 2008, at 12:35 PM, Sennikov, Dimitri wrote: Thanks, Due to lack of other options, I have tried switching to using No Prototype and setting a custom Data Type to NSArray. I don't see much change and it still ends up trying to NULLIFY the department IDs. I have also tried now to no success passing a String departmentName from the WOBrowser. I then fetch Department EO from the database using departmentName and use addObjectToBothSidesOfRelationshipWithKey(departmentEO, departments); It still produces the SET ID = NULL erroneous sql statement. Chuck, any suggestions now that it is immutable type? Any input is appreciated. Dmitri -Original Message- From: Anjo Krank [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 12, 2008 3:04 PM To: Chuck Hill Cc: Sennikov, Dimitri; WebObjects Dev Apple Subject: Re: Error on saveChanges with WOBrowser or WOCheckBoxList Dimitri, Am 12.02.2008 um 20:47 schrieb Chuck Hill: Using mutable classes as attributes is a very, very, very bad idea. I know, I have tried it. EOF expects attributes to be immutable. Make it immutable and add cover methods to add and remove items. Until you fix this, there is no point in looking at the ID getting set to null problem. Pay no heed to Chuck's ramblings. You should be OK as long as your don't change the array directly. It would be best if you defined your accessors an returning NSArray. Cheers, Anjo -- Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems. http://www.global-village.net/products/practical_webobjects ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
RE: Error on saveChanges with WOBrowser or WOCheckBoxList
Thanks, Due to lack of other options, I have tried switching to using No Prototype and setting a custom Data Type to NSArray. I don't see much change and it still ends up trying to NULLIFY the department IDs. I have also tried now to no success passing a String departmentName from the WOBrowser. I then fetch Department EO from the database using departmentName and use addObjectToBothSidesOfRelationshipWithKey(departmentEO, departments); It still produces the SET ID = NULL erroneous sql statement. Chuck, any suggestions now that it is immutable type? Any input is appreciated. Dmitri -Original Message- From: Anjo Krank [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 12, 2008 3:04 PM To: Chuck Hill Cc: Sennikov, Dimitri; WebObjects Dev Apple Subject: Re: Error on saveChanges with WOBrowser or WOCheckBoxList Dimitri, Am 12.02.2008 um 20:47 schrieb Chuck Hill: Using mutable classes as attributes is a very, very, very bad idea. I know, I have tried it. EOF expects attributes to be immutable. Make it immutable and add cover methods to add and remove items. Until you fix this, there is no point in looking at the ID getting set to null problem. Pay no heed to Chuck's ramblings. You should be OK as long as your don't change the array directly. It would be best if you defined your accessors an returning NSArray. Cheers, Anjo ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
Re: Error on saveChanges with WOBrowser or WOCheckBoxList
I ran into with PK's with FB -- granted it was, I believe, because of that bug in the plugin (that was my own fault to begin with) that was misconverting between Integer and Long PKs, making EOF think the PK had changed. Other than I think you are right. But I thought I'd toss it out there for the sake of science. ms On Feb 12, 2008, at 4:02 PM, Chuck Hill wrote: You mean FK? I have not seen many problems with PKs, but FKs as class properties is asking for trouble. Ask and ye shall receive. :-) Chuck On Feb 12, 2008, at 12:58 PM, Mike Schrag wrote: Is your PK a class property? Does it need to be? I have seen problems before with PK as a class property that EOF tries to overwrite (this is not supposed to happen, but you decrease your odds by making it a non-class property). On your relationship, are you setting propagates primary key and/or owns destination? That can have an impact on how PK's are treated as well. On Feb 12, 2008, at 3:51 PM, Chuck Hill wrote: Maybe Anjo knows. :-) What are the delete rules? I have seen this sort of thing before, but I can't recall what caused it. Chuck On Feb 12, 2008, at 12:35 PM, Sennikov, Dimitri wrote: Thanks, Due to lack of other options, I have tried switching to using No Prototype and setting a custom Data Type to NSArray. I don't see much change and it still ends up trying to NULLIFY the department IDs. I have also tried now to no success passing a String departmentName from the WOBrowser. I then fetch Department EO from the database using departmentName and use addObjectToBothSidesOfRelationshipWithKey(departmentEO, departments); It still produces the SET ID = NULL erroneous sql statement. Chuck, any suggestions now that it is immutable type? Any input is appreciated. Dmitri -Original Message- From: Anjo Krank [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 12, 2008 3:04 PM To: Chuck Hill Cc: Sennikov, Dimitri; WebObjects Dev Apple Subject: Re: Error on saveChanges with WOBrowser or WOCheckBoxList Dimitri, Am 12.02.2008 um 20:47 schrieb Chuck Hill: Using mutable classes as attributes is a very, very, very bad idea. I know, I have tried it. EOF expects attributes to be immutable. Make it immutable and add cover methods to add and remove items. Until you fix this, there is no point in looking at the ID getting set to null problem. Pay no heed to Chuck's ramblings. You should be OK as long as your don't change the array directly. It would be best if you defined your accessors an returning NSArray. Cheers, Anjo -- Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems. http://www.global-village.net/products/practical_webobjects ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/mschrag%40mdimension.com This email sent to [EMAIL PROTECTED] -- Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems. http://www.global-village.net/products/practical_webobjects ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
Re: Error on saveChanges with WOBrowser or WOCheckBoxList
You mean FK? I have not seen many problems with PKs, but FKs as class properties is asking for trouble. Ask and ye shall receive. :-) Chuck On Feb 12, 2008, at 12:58 PM, Mike Schrag wrote: Is your PK a class property? Does it need to be? I have seen problems before with PK as a class property that EOF tries to overwrite (this is not supposed to happen, but you decrease your odds by making it a non-class property). On your relationship, are you setting propagates primary key and/or owns destination? That can have an impact on how PK's are treated as well. On Feb 12, 2008, at 3:51 PM, Chuck Hill wrote: Maybe Anjo knows. :-) What are the delete rules? I have seen this sort of thing before, but I can't recall what caused it. Chuck On Feb 12, 2008, at 12:35 PM, Sennikov, Dimitri wrote: Thanks, Due to lack of other options, I have tried switching to using No Prototype and setting a custom Data Type to NSArray. I don't see much change and it still ends up trying to NULLIFY the department IDs. I have also tried now to no success passing a String departmentName from the WOBrowser. I then fetch Department EO from the database using departmentName and use addObjectToBothSidesOfRelationshipWithKey(departmentEO, departments); It still produces the SET ID = NULL erroneous sql statement. Chuck, any suggestions now that it is immutable type? Any input is appreciated. Dmitri -Original Message- From: Anjo Krank [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 12, 2008 3:04 PM To: Chuck Hill Cc: Sennikov, Dimitri; WebObjects Dev Apple Subject: Re: Error on saveChanges with WOBrowser or WOCheckBoxList Dimitri, Am 12.02.2008 um 20:47 schrieb Chuck Hill: Using mutable classes as attributes is a very, very, very bad idea. I know, I have tried it. EOF expects attributes to be immutable. Make it immutable and add cover methods to add and remove items. Until you fix this, there is no point in looking at the ID getting set to null problem. Pay no heed to Chuck's ramblings. You should be OK as long as your don't change the array directly. It would be best if you defined your accessors an returning NSArray. Cheers, Anjo -- Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems. http://www.global-village.net/products/practical_webobjects ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/mschrag% 40mdimension.com This email sent to [EMAIL PROTECTED] -- Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems. http://www.global-village.net/products/practical_webobjects ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
Re: Error on saveChanges with WOBrowser or WOCheckBoxList
Dimitri, Am 12.02.2008 um 20:47 schrieb Chuck Hill: Using mutable classes as attributes is a very, very, very bad idea. I know, I have tried it. EOF expects attributes to be immutable. Make it immutable and add cover methods to add and remove items. Until you fix this, there is no point in looking at the ID getting set to null problem. Pay no heed to Chuck's ramblings. You should be OK as long as your don't change the array directly. It would be best if you defined your accessors an returning NSArray. Cheers, Anjo ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
Re: Error on saveChanges with WOBrowser or WOCheckBoxList
Dimitri, On Feb 12, 2008, at 5:14 AM, Sennikov, Dimitri wrote: Brian, I only have 1-to-many, a user can be a part of several departments whereas department has no relationship with any user from its side. And contrary to your statement, the EOF is only setting ID column to NULL for the items that have been selected. If I don't select any items, the saveChanges is completed successfully. From Entity Modeler, the relationship is represented by departmentIDs column with the following settings: Prototype - mutableArray =8-0 Noo! External Type - BLOB Allows Null - is set Data Type - Custom Class - er.extensions.ERXMutableArray Factory Method - fromBlob Conversion Method - toBlob This is just in case, I'm not sure how helpful this information may be in this case. Using mutable classes as attributes is a very, very, very bad idea. I know, I have tried it. EOF expects attributes to be immutable. Make it immutable and add cover methods to add and remove items. Until you fix this, there is no point in looking at the ID getting set to null problem. Chuck -Original Message- From: Brian Lakeman [mailto:[EMAIL PROTECTED] Sent: Monday, February 11, 2008 9:16 PM To: Sennikov, Dimitri Cc: webobjects-dev@lists.apple.com Subject: Re: Error on saveChanges with WOBrowser or WOCheckBoxList Dimitri, It appears that EOF is attempt to set the ID column to null for the items that are no longer part of the selection, and the Department table doesn't allow the ID column to be null. Is there a many-to-many relationship between User and Department? Are there many users in the same department? -Brian On Feb 11, 2008, at 2:18 PM, Sennikov, Dimitri wrote: Hi, I have a 1-to-many relationship (User - Departments). With either WOBrowser or WOCheckBoxList, whenever a department is selected, an error is produced when trying to save User where WebObjects is trying to overwrite the selected department's ID (primary key), UPDATE WA_Departments SET id = NULL WHERE (id = ? AND description = ? AND managerID is NULL AND name = ?) withBindings: 1:2(id), 2:Engineering(description), 3:Engineering(name). Has anybody got same error and is there a known workaround other than creating custom WORepetition? I'm developing on Eclipse/WOLips on Windows and would like to get this to work because I have many more components to come that will require same kind of functionality, and frankly WOBrowser is much easier than WORepetition with manual item processing. Here's my WOBrowser object: DepartmentList : WOBrowser { list = departmentDisplayGroup.displayedObjects; item = department; displayString = department.name; selections = user.departments; multiple = true; size = 6; } Here's the error stack trace: Application: WebApp Error: com.webobjects.eoaccess.EOGeneralAdaptorException: EvaluateExpression failed: : Next exception:SQL State:23000 -- error code: 1048 -- msg: Column 'id' cannot be null Reason: EvaluateExpression failed: com.webobjects.jdbcadaptor.MySQLPlugIn$MySQLExpression: UPDATE WA_Departments SET id = NULL WHERE (id = ? AND description = ? AND managerID is NULL AND name = ?) withBindings: 1:2(id), 2:Engineering(description), 3:Engineering(name): Next exception:SQL State:23000 -- error code: 1048 -- msg: Column 'id' cannot be null Stack trace: File Line# Method Package - - -- EODatabaseContext.java 4500 _exceptionWithDatabaseContextInformationAdded com.webobjects.eoaccess EODatabaseContext.java 6212 performChanges com.webobjects.eoaccess EOObjectStoreCoordinator.java 371 saveChangesInEditingContext com.webobjects.eocontrol EOEditingContext.java 3176 saveChanges com.webobjects.eocontrol EditUser.java 95 SaveUser dyn.webapp.components NativeMethodAccessorImpl.java NA invoke0 sun.reflect NativeMethodAccessorImpl.java NA invoke sun.reflect DelegatingMethodAccessorImpl.java NA invoke sun.reflect Method.java NA invoke java.lang.reflect NSKeyValueCoding.java 636 methodValue com.webobjects.foundation NSKeyValueCoding.java 1134 valueInObject com.webobjects.foundation NSKeyValueCoding.java 1293 valueForKey com.webobjects.foundation WOComponent.java 1686 valueForKey com.webobjects.appserver NSKeyValueCoding.java 447 valueForKey com.webobjects.foundation NSKeyValueCodingAdditions.java 212 valueForKeyPath com.webobjects.foundation WOComponent.java 1754 valueForKeyPath com.webobjects.appserver EditUser.java 87 valueForKeyPath dyn.webapp.components WOKeyValueAssociation.java 50 valueInComponent com.webobjects.appserver._private WOSubmitButton.java 70 invokeAction com.webobjects.appserver._private WODynamicGroup.java 105 invokeChildrenAction com.webobjects.appserver._private WODynamicGroup.java 115 invokeAction com.webobjects.appserver._private WOForm.java 134 invokeAction com.webobjects.appserver._private WODynamicGroup.java 105 invokeChildrenAction
RE: Error on saveChanges with WOBrowser or WOCheckBoxList
Brian, I only have 1-to-many, a user can be a part of several departments whereas department has no relationship with any user from its side. And contrary to your statement, the EOF is only setting ID column to NULL for the items that have been selected. If I don't select any items, the saveChanges is completed successfully. From Entity Modeler, the relationship is represented by departmentIDs column with the following settings: Prototype - mutableArray External Type - BLOB Allows Null - is set Data Type - Custom Class - er.extensions.ERXMutableArray Factory Method - fromBlob Conversion Method - toBlob This is just in case, I'm not sure how helpful this information may be in this case. Thanks! Dmitri -Original Message- From: Brian Lakeman [mailto:[EMAIL PROTECTED] Sent: Monday, February 11, 2008 9:16 PM To: Sennikov, Dimitri Cc: webobjects-dev@lists.apple.com Subject: Re: Error on saveChanges with WOBrowser or WOCheckBoxList Dimitri, It appears that EOF is attempt to set the ID column to null for the items that are no longer part of the selection, and the Department table doesn't allow the ID column to be null. Is there a many-to-many relationship between User and Department? Are there many users in the same department? -Brian On Feb 11, 2008, at 2:18 PM, Sennikov, Dimitri wrote: Hi, I have a 1-to-many relationship (User - Departments). With either WOBrowser or WOCheckBoxList, whenever a department is selected, an error is produced when trying to save User where WebObjects is trying to overwrite the selected department's ID (primary key), UPDATE WA_Departments SET id = NULL WHERE (id = ? AND description = ? AND managerID is NULL AND name = ?) withBindings: 1:2(id), 2:Engineering(description), 3:Engineering(name). Has anybody got same error and is there a known workaround other than creating custom WORepetition? I'm developing on Eclipse/WOLips on Windows and would like to get this to work because I have many more components to come that will require same kind of functionality, and frankly WOBrowser is much easier than WORepetition with manual item processing. Here's my WOBrowser object: DepartmentList : WOBrowser { list = departmentDisplayGroup.displayedObjects; item = department; displayString = department.name; selections = user.departments; multiple = true; size = 6; } Here's the error stack trace: Application: WebApp Error: com.webobjects.eoaccess.EOGeneralAdaptorException: EvaluateExpression failed: : Next exception:SQL State:23000 -- error code: 1048 -- msg: Column 'id' cannot be null Reason: EvaluateExpression failed: com.webobjects.jdbcadaptor.MySQLPlugIn$MySQLExpression: UPDATE WA_Departments SET id = NULL WHERE (id = ? AND description = ? AND managerID is NULL AND name = ?) withBindings: 1:2(id), 2:Engineering(description), 3:Engineering(name): Next exception:SQL State:23000 -- error code: 1048 -- msg: Column 'id' cannot be null Stack trace: File Line# Method Package -- -- EODatabaseContext.java 4500 _exceptionWithDatabaseContextInformationAdded com.webobjects.eoaccess EODatabaseContext.java 6212 performChanges com.webobjects.eoaccess EOObjectStoreCoordinator.java 371 saveChangesInEditingContext com.webobjects.eocontrol EOEditingContext.java 3176 saveChanges com.webobjects.eocontrol EditUser.java 95 SaveUser dyn.webapp.components NativeMethodAccessorImpl.java NA invoke0 sun.reflect NativeMethodAccessorImpl.java NA invoke sun.reflect DelegatingMethodAccessorImpl.java NA invoke sun.reflect Method.java NA invoke java.lang.reflect NSKeyValueCoding.java 636 methodValue com.webobjects.foundation NSKeyValueCoding.java 1134 valueInObject com.webobjects.foundation NSKeyValueCoding.java 1293 valueForKey com.webobjects.foundation WOComponent.java 1686 valueForKey com.webobjects.appserver NSKeyValueCoding.java 447 valueForKey com.webobjects.foundation NSKeyValueCodingAdditions.java 212 valueForKeyPath com.webobjects.foundation WOComponent.java 1754 valueForKeyPath com.webobjects.appserver EditUser.java 87 valueForKeyPath dyn.webapp.components WOKeyValueAssociation.java 50 valueInComponent com.webobjects.appserver._private WOSubmitButton.java 70 invokeAction com.webobjects.appserver._private WODynamicGroup.java 105 invokeChildrenAction com.webobjects.appserver._private WODynamicGroup.java 115 invokeAction com.webobjects.appserver._private WOForm.java 134 invokeAction com.webobjects.appserver._private WODynamicGroup.java 105 invokeChildrenAction com.webobjects.appserver._private WODynamicGroup.java 115 invokeAction com.webobjects.appserver._private WOComponent.java 1078 invokeAction com.webobjects.appserver WOSession.java 1353 invokeAction com.webobjects.appserver WOApplication.java 1736 invokeAction com.webobjects.appserver WOComponentRequestHandler.java 206
Error on saveChanges with WOBrowser or WOCheckBoxList
Hi, I have a 1-to-many relationship (User - Departments). With either WOBrowser or WOCheckBoxList, whenever a department is selected, an error is produced when trying to save User where WebObjects is trying to overwrite the selected department's ID (primary key), UPDATE WA_Departments SET id = NULL WHERE (id = ? AND description = ? AND managerID is NULL AND name = ?) withBindings: 1:2(id), 2:Engineering(description), 3:Engineering(name). Has anybody got same error and is there a known workaround other than creating custom WORepetition? I'm developing on Eclipse/WOLips on Windows and would like to get this to work because I have many more components to come that will require same kind of functionality, and frankly WOBrowser is much easier than WORepetition with manual item processing. Here's my WOBrowser object: DepartmentList : WOBrowser { list = departmentDisplayGroup.displayedObjects; item = department; displayString = department.name; selections = user.departments; multiple = true; size = 6; } Here's the error stack trace: Application: WebApp Error: com.webobjects.eoaccess.EOGeneralAdaptorException: EvaluateExpression failed: : Next exception:SQL State:23000 -- error code: 1048 -- msg: Column 'id' cannot be null Reason: EvaluateExpression failed: com.webobjects.jdbcadaptor.MySQLPlugIn$MySQLExpression: UPDATE WA_Departments SET id = NULL WHERE (id = ? AND description = ? AND managerID is NULL AND name = ?) withBindings: 1:2(id), 2:Engineering(description), 3:Engineering(name): Next exception:SQL State:23000 -- error code: 1048 -- msg: Column 'id' cannot be null Stack trace: File Line# Method Package EODatabaseContext.java 4500 _exceptionWithDatabaseContextInformationAdded com.webobjects.eoaccess EODatabaseContext.java 6212 performChanges com.webobjects.eoaccess EOObjectStoreCoordinator.java 371 saveChangesInEditingContext com.webobjects.eocontrol EOEditingContext.java 3176 saveChanges com.webobjects.eocontrol EditUser.java 95 SaveUser dyn.webapp.components NativeMethodAccessorImpl.java NA invoke0 sun.reflect NativeMethodAccessorImpl.java NA invoke sun.reflect DelegatingMethodAccessorImpl.java NA invoke sun.reflect Method.java NA invoke java.lang.reflect NSKeyValueCoding.java 636 methodValue com.webobjects.foundation NSKeyValueCoding.java 1134 valueInObject com.webobjects.foundation NSKeyValueCoding.java 1293 valueForKey com.webobjects.foundation WOComponent.java 1686 valueForKey com.webobjects.appserver NSKeyValueCoding.java 447 valueForKey com.webobjects.foundation NSKeyValueCodingAdditions.java 212 valueForKeyPath com.webobjects.foundation WOComponent.java 1754 valueForKeyPath com.webobjects.appserver EditUser.java 87 valueForKeyPath dyn.webapp.components WOKeyValueAssociation.java 50 valueInComponent com.webobjects.appserver._private WOSubmitButton.java 70 invokeAction com.webobjects.appserver._private WODynamicGroup.java 105 invokeChildrenAction com.webobjects.appserver._private WODynamicGroup.java 115 invokeAction com.webobjects.appserver._private WOForm.java 134 invokeAction com.webobjects.appserver._private WODynamicGroup.java 105 invokeChildrenAction com.webobjects.appserver._private WODynamicGroup.java 115 invokeAction com.webobjects.appserver._private WOComponent.java 1078 invokeAction com.webobjects.appserver WOSession.java 1353 invokeAction com.webobjects.appserver WOApplication.java 1736 invokeAction com.webobjects.appserver WOComponentRequestHandler.java 206 _dispatchWithPreparedPage com.webobjects.appserver._private WOComponentRequestHandler.java 298 _dispatchWithPreparedSession com.webobjects.appserver._private WOComponentRequestHandler.java 332 _dispatchWithPreparedApplication com.webobjects.appserver._private WOComponentRequestHandler.java 369 _handleRequest com.webobjects.appserver._private WOComponentRequestHandler.java 442 handleRequest com.webobjects.appserver._private WOApplication.java 1678 dispatchRequest com.webobjects.appserver WOWorkerThread.java 144 runOnce com.webobjects.appserver._private WOWorkerThread.java 226 run com.webobjects.appserver._private Thread.java NA run java.lang ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
Re: Error on saveChanges with WOBrowser or WOCheckBoxList
Dimitri, It appears that EOF is attempt to set the ID column to null for the items that are no longer part of the selection, and the Department table doesn't allow the ID column to be null. Is there a many-to-many relationship between User and Department? Are there many users in the same department? -Brian On Feb 11, 2008, at 2:18 PM, Sennikov, Dimitri wrote: Hi, I have a 1-to-many relationship (User - Departments). With either WOBrowser or WOCheckBoxList, whenever a department is selected, an error is produced when trying to save User where WebObjects is trying to overwrite the selected department's ID (primary key), UPDATE WA_Departments SET id = NULL WHERE (id = ? AND description = ? AND managerID is NULL AND name = ?) withBindings: 1:2(id), 2:Engineering(description), 3:Engineering(name). Has anybody got same error and is there a known workaround other than creating custom WORepetition? I'm developing on Eclipse/WOLips on Windows and would like to get this to work because I have many more components to come that will require same kind of functionality, and frankly WOBrowser is much easier than WORepetition with manual item processing. Here's my WOBrowser object: DepartmentList : WOBrowser { list = departmentDisplayGroup.displayedObjects; item = department; displayString = department.name; selections = user.departments; multiple = true; size = 6; } Here's the error stack trace: Application: WebApp Error: com.webobjects.eoaccess.EOGeneralAdaptorException: EvaluateExpression failed: : Next exception:SQL State:23000 -- error code: 1048 -- msg: Column 'id' cannot be null Reason: EvaluateExpression failed: com.webobjects.jdbcadaptor.MySQLPlugIn$MySQLExpression: UPDATE WA_Departments SET id = NULL WHERE (id = ? AND description = ? AND managerID is NULL AND name = ?) withBindings: 1:2(id), 2:Engineering(description), 3:Engineering(name): Next exception:SQL State:23000 -- error code: 1048 -- msg: Column 'id' cannot be null Stack trace: File Line# Method Package -- -- EODatabaseContext.java 4500 _exceptionWithDatabaseContextInformationAdded com.webobjects.eoaccess EODatabaseContext.java 6212 performChanges com.webobjects.eoaccess EOObjectStoreCoordinator.java 371 saveChangesInEditingContext com.webobjects.eocontrol EOEditingContext.java 3176 saveChanges com.webobjects.eocontrol EditUser.java 95 SaveUser dyn.webapp.components NativeMethodAccessorImpl.java NA invoke0 sun.reflect NativeMethodAccessorImpl.java NA invoke sun.reflect DelegatingMethodAccessorImpl.java NA invoke sun.reflect Method.java NA invoke java.lang.reflect NSKeyValueCoding.java 636 methodValue com.webobjects.foundation NSKeyValueCoding.java 1134 valueInObject com.webobjects.foundation NSKeyValueCoding.java 1293 valueForKey com.webobjects.foundation WOComponent.java 1686 valueForKey com.webobjects.appserver NSKeyValueCoding.java 447 valueForKey com.webobjects.foundation NSKeyValueCodingAdditions.java 212 valueForKeyPath com.webobjects.foundation WOComponent.java 1754 valueForKeyPath com.webobjects.appserver EditUser.java 87 valueForKeyPath dyn.webapp.components WOKeyValueAssociation.java 50 valueInComponent com.webobjects.appserver._private WOSubmitButton.java 70 invokeAction com.webobjects.appserver._private WODynamicGroup.java 105 invokeChildrenAction com.webobjects.appserver._private WODynamicGroup.java 115 invokeAction com.webobjects.appserver._private WOForm.java 134 invokeAction com.webobjects.appserver._private WODynamicGroup.java 105 invokeChildrenAction com.webobjects.appserver._private WODynamicGroup.java 115 invokeAction com.webobjects.appserver._private WOComponent.java 1078 invokeAction com.webobjects.appserver WOSession.java 1353 invokeAction com.webobjects.appserver WOApplication.java 1736 invokeAction com.webobjects.appserver WOComponentRequestHandler.java 206 _dispatchWithPreparedPage com.webobjects.appserver._private WOComponentRequestHandler.java 298 _dispatchWithPreparedSession com.webobjects.appserver._private WOComponentRequestHandler.java 332 _dispatchWithPreparedApplication com.webobjects.appserver._private WOComponentRequestHandler.java 369 _handleRequest com.webobjects.appserver._private WOComponentRequestHandler.java 442 handleRequest com.webobjects.appserver._private WOApplication.java 1678 dispatchRequest com.webobjects.appserver WOWorkerThread.java 144 runOnce com.webobjects.appserver._private WOWorkerThread.java 226 run com.webobjects.appserver._private Thread.java NA run java.lang ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/brian% 40lakeman.org This email sent to [EMAIL PROTECTED