It worked well for FrontBase and H2, but I guess it should use EOF to create
the role instead of using SQL.
> Interesting, I downloaded, imported the source, and switched the database to
> postgresql. I could not add another 'role' because of a pk violation.
>
> when i examined the tables I found that the role_seq listed a last_value of
> 1. it should have been 2. so I did a:
>
> select setval('role_seq', 2);
>
> and voila, I can create roles.
>
> the error was in the migrations (for postgresql)
> ERXJDBCUtilities.executeUpdate(database.adaptorChannel(), "INSERT INTO Role
> (roleDescription, id) VALUES ('Admin', 1)", true);
>
> when you specify the id's value, it prevents the value from incrementing the
> sequence. so either remove the explicit id or do the setval.
>
> ERXJDBCUtilities.executeUpdate(database.adaptorChannel(), "INSERT INTO Role
> (roleDescription) VALUES ('Admin')", true);
>
> I don't know the implications for other databases.
>
> Ted
>
> --- On Thu, 12/15/11, David Holt <[email protected]> wrote:
>
>> From: David Holt <[email protected]>
>> Subject: Re: stumbling around with D2W
>> To: "Theodore Petrosky" <[email protected]>
>> Cc: "Ramsey Gurley" <[email protected]>, [email protected]
>> Date: Thursday, December 15, 2011, 12:25 PM
>> This example is in the SimpleBlog
>> rules for assigning roles to a Person with checkboxes. It's
>> not exactly the same as you've asked for, but it was handy
>> :-)
>>
>> https://github.com/daveeed/SimpleBlog
>>
>> 50 : (task = 'edit' and entity.name = 'Person' and
>> propertyKey = 'roles') => toManyUIStyle = "checkbox"
>> [com.webobjects.directtoweb.Assignment]
>> 80 : (task = 'edit' and entity.name = 'Person' and
>> propertyKey = 'roles') => componentName =
>> "ERD2WEditToManyRelationship"
>> [com.webobjects.directtoweb.Assignment]
>> 100 : (entity.name = 'Person' and propertyKey = 'roles')
>> => keyWhenRelationship = "roleDescription"
>> [com.webobjects.directtoweb.Assignment]
>>
>> The propertyKey 'roles' could be a relationship or a method
>> such as that you have below on your EmploymentTitle EO.
>>
>> David
>>
>>
>> On 2011-12-15, at 8:41 AM, Theodore Petrosky wrote:
>>
>>> Is there an example out there? I feel totally lost, I
>> don't understand where to begin.
>>>
>>> I hesitate asking for this kind of low level help.
>>>
>>> I feel like a fish out of water.
>>>
>>> Ted
>>>
>>> --- On Thu, 12/15/11, Ramsey Gurley <[email protected]>
>> wrote:
>>>
>>>> From: Ramsey Gurley <[email protected]>
>>>> Subject: Re: stumbling around with D2W
>>>> To: "Theodore Petrosky" <[email protected]>
>>>> Cc: [email protected]
>>>> Date: Thursday, December 15, 2011, 10:28 AM
>>>> Hi Ted,
>>>>
>>>> componentName = ERD2WEditToOneRelationship
>>>> restrictedChoiceKey = object.currentTitles
>>>>
>>>> Then create a method on your object returning an
>> array of
>>>> current employment titles like you have below.
>>>>
>>>> Ramsey
>>>>
>>>> On Dec 15, 2011, at 8:03 AM, Theodore Petrosky
>> wrote:
>>>>
>>>>> OK so this is a real newbie thing.
>>>>>
>>>>> In my Wonder app, I would:
>>>>>
>>>>> create a list of entries to populate a popup
>>>>>
>>>>> employmentTitleList =
>>>>
>> EmploymentTitle.fetchEmploymentTitles(newEmployeeEC,
>>>> EmploymentTitle.IS_CURRENT.eq(true),
>>>> EmploymentTitle.ORDERING_INT.ascs());
>>>>>
>>>>> I don't understand how to do this in an Edit
>> page in
>>>> D2W.
>>>>>
>>>>> Is there anything like this in an example?
>>>>>
>>>>> Ted
>>>>>
>> _______________________________________________
>>>>> Do not post admin requests to the list. They
>> will be
>>>> ignored.
>>>>> Webobjects-dev mailing list
>> ([email protected])
>>>>> Help/Unsubscribe/Update your Subscription:
>>>>> http://lists.apple.com/mailman/options/webobjects-dev/ramseygurley%40gmail.com
>>>>>
>>>>> This email sent to [email protected]
>>>>
>>>>
>>> _______________________________________________
>>> Do not post admin requests to the list. They will be
>> ignored.
>>> Webobjects-dev mailing list ([email protected])
>>> Help/Unsubscribe/Update your Subscription:
>>> http://lists.apple.com/mailman/options/webobjects-dev/programmingosx%40mac.com
>>>
>>> This email sent to [email protected]
>>
>>
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list ([email protected])
> Help/Unsubscribe/Update your Subscription:
> http://lists.apple.com/mailman/options/webobjects-dev/probert%40macti.ca
>
> This email sent to [email protected]
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
