Anyone ever returned a .jnlp from a wocomponet?

2011-11-09 Thread Klaus Berkling
Anyone ever returned a .jnlp from a wocomponet? I need to create a dynamic .jnlp. Anything tricky about that? I image I need to change the header like mime type and file name... kib "The era of procrastination, of half-measures, of soothing and baffling expedients, of delays, is coming to its

Re: Delete rules on flattened relationships

2011-11-09 Thread Paul Hoadley
On 10/11/2011, at 8:25 AM, Ramsey Gurley wrote: >> Say I have two entities, User and Role, and a joining entity UserRole to >> create a many-to-many relationship between them. So I have a relationship >> 'userRoles' from User to UserRole (and a relationship 'userRoles' from Role >> back to Use

Re: [SOLVED]: Is JDBCAdaptor generating the wrong SQL for fixed length character columns?

2011-11-09 Thread Chuck Hill
Hi Lars, Can you check your connection URL? It should not be using that file, that is mostly for Entity Modeler to generate the schema in the absence of a database connection. See: /** * This method returns true if the connection URL for the * database has a special flag on it which i

Re: [SOLVED]: Is JDBCAdaptor generating the wrong SQL for fixed length character columns?

2011-11-09 Thread John Huss
> > You need to create a pull request on github. > > I never did that, I never used git and I currently have no time to acquire > that knowledge. Can somebody else please do that instead? > You could create a JIRA and attach a patch instead then. ___ Do

Re: [SOLVED]: Is JDBCAdaptor generating the wrong SQL for fixed length character columns?

2011-11-09 Thread Lars Sonchocky-Helldorf
Am 09.11.2011 um 22:45 schrieb John Huss: > You need to create a pull request on github. I never did that, I never used git and I currently have no time to acquire that knowledge. Can somebody else please do that instead? > > On Wed, Nov 9, 2011 at 1:41 PM, Lars Sonchocky-Helldorf > wrote:

Re: Delete rules on flattened relationships

2011-11-09 Thread Ramsey Gurley
On Nov 9, 2011, at 2:34 PM, Paul Hoadley wrote: > Hi Ramsey, > > On 10/11/2011, at 4:24 AM, Ramsey Gurley wrote: > >> On Nov 8, 2011, at 8:34 PM, Paul Hoadley wrote: >> >>> So the advice is that the intended delete rule(s) should operate on the >>> real relationship chain, not shortcut via th

Re: [SOLVED]: Is JDBCAdaptor generating the wrong SQL for fixed length character columns?

2011-11-09 Thread John Huss
You need to create a pull request on github. On Wed, Nov 9, 2011 at 1:41 PM, Lars Sonchocky-Helldorf < lars.sonchocky-helld...@hamburg.de> wrote: > > Am 08.11.2011 um 20:56 schrieb Lars Sonchocky-Helldorf: > > > Hi folks! > > > > > > For reason not to be discussed here my coworker has created a P

Re: Delete rules on flattened relationships

2011-11-09 Thread Paul Hoadley
Hi Ramsey, On 10/11/2011, at 4:24 AM, Ramsey Gurley wrote: > On Nov 8, 2011, at 8:34 PM, Paul Hoadley wrote: > >> So the advice is that the intended delete rule(s) should operate on the real >> relationship chain, not shortcut via the flattened relationship. That's >> fine, but are Nullify an

[SOLVED]: Is JDBCAdaptor generating the wrong SQL for fixed length character columns?

2011-11-09 Thread Lars Sonchocky-Helldorf
Am 08.11.2011 um 20:56 schrieb Lars Sonchocky-Helldorf: > Hi folks! > > > For reason not to be discussed here my coworker has created a PostgreSQL 9 > database table like follows: > > CREATE TABLE systemmessagecontent > ( > id integer NOT NULL, > "language" character(2) NOT NULL, > message

Re: Raw SQL with bindings

2011-11-09 Thread Michael Gargano
I actually was instantiating PostgresqlExpression in my code, but I cleaned it up for the e-mail. This is nifty to keep it database agnostic though. Thanks! -Mike On Nov 9, 2011, at 1:38 PM, Mike Schrag wrote: EODatabaseContext dbc = EOUtilities.databaseContextForModelNamed(ec, model.name

Re: Raw SQL with bindings

2011-11-09 Thread Mike Schrag
EODatabaseContext dbc = EOUtilities.databaseContextForModelNamed(ec, model.name()); EOSQLExpressionFactory sqlFactory = dbc.adaptorContext().adaptor().expressionFactory(); (adaptor().expressionFactory just calls plugIn().expressionFactory() for JDBC) ms On Nov 9, 2011, at 1:34 PM, Mike Schrag

Re: Raw SQL with bindings

2011-11-09 Thread Mike Schrag
that's not exactly right ... you want to get an expression from an expressionfactory from your jdbcplugin implementation. ms On Nov 9, 2011, at 1:30 PM, Michael Gargano wrote: > So, for future posterity and to help myself again when I need it... > > EOEntity entity = EOUtilities.entityForC

Found the rule… turn of Click to Open! Re: Cheat sheet for D2W to EXCEL?

2011-11-09 Thread James Cicenia
Pretty slick stuff here. That took me all of half hour to whip up a fantastic export to excel! Great Stuff. On Nov 9, 2011, at 11:39 AM, David Holt wrote: > There's a screencast. ERExcelLook > > > On 2011-11-09, at 9:38 AM, James Cicenia wrote: > >> Hello - >> >> I am trying to cobble all

Re: Raw SQL with bindings

2011-11-09 Thread Michael Gargano
So, for future posterity and to help myself again when I need it... EOEntity entity = EOUtilities.entityForClass(cdw, YourEntity.class); JDBCExpression exp = new JDBCExpression(entity); exp.setUseBindVariables(true); exp.setStatement(sqlStatement); exp.addBindVariableDictio

Re: D2W and rule controlled visibleEntityNames

2011-11-09 Thread Ramsey Gurley
It should still work. The QueryAllPage is the page component. The MenuHeader is a child component of the QueryAllPage. All D2W pages have a session. So, in your deployment properties located at /etc/WebObject/[ApplicationName]/Properties add a property like com.mydomain.application.region=eu

Re: Cheat sheet for D2W to EXCEL… AND ERModernLook?

2011-11-09 Thread James Cicenia
Must be missing one last piece of the puzzle? So I add another navigation item and method. I fire off the action which dutifully exports the spreadsheet. However, I get all fubar'd formatting It looks as though it is sending down some formatting info? Do I need a style sheet rule? Or Some

Re: Delete rules on flattened relationships

2011-11-09 Thread Ramsey Gurley
On Nov 8, 2011, at 8:34 PM, Paul Hoadley wrote: > Hello, > > I was recently reviewing an EO model of mine and noticed a flattened > relationship with a Nullify delete rule. I recalled part of an exchange > between Davids Avendasora and LeBer earlier this year: > And what should those be

Re: Cheat sheet for D2W to EXCEL?

2011-11-09 Thread James Cicenia
!!! I just found the motherlode over at WOCommunity.org! ERREST was going to be next so this screencast page is just in time for me to discover. Each wiki page should have a reference to this site. Regards, James PS: This find alone will make me buy a membership now! On Nov 9, 2011, at 11:

Re: Cheat sheet for D2W to EXCEL?

2011-11-09 Thread David Holt
There's a screencast. ERExcelLook On 2011-11-09, at 9:38 AM, James Cicenia wrote: > Hello - > > I am trying to cobble all the questions/answers and wikis to figure > out how to export one of my D2WList views to Excel? > > I have done this years ago in a custom app with no wonder or D2W. > > D

Cheat sheet for D2W to EXCEL?

2011-11-09 Thread James Cicenia
Hello - I am trying to cobble all the questions/answers and wikis to figure out how to export one of my D2WList views to Excel? I have done this years ago in a custom app with no wonder or D2W. Does anyone have such a cheat sheet? 1) Import this framework (POI?) 2) Use this wrapper (EGWrapper

Re: Boolean bindings in API files

2011-11-09 Thread Kieran Kelleher
Try this: On Nov 9, 2011, at 8:52 AM, Pascal Robert wrote: > I have a question about boolean bindings in API files. If I add a binding > with a Boolean type, when I call the component with that binding, the binding > should not have quotes, e.g.: > > > > If I add quotes, I get: > > Whil

Boolean bindings in API files

2011-11-09 Thread Pascal Robert
I have a question about boolean bindings in API files. If I add a binding with a Boolean type, when I call the component with that binding, the binding should not have quotes, e.g.: If I add quotes, I get: While trying to set the field "isSubPart" on an object of type com.obzerv.fragme

Re: D2W and rule controlled visibleEntityNames

2011-11-09 Thread Markus Ruggiero
On 08.11.2011, at 17:33, Ramsey Gurley wrote: > If it is a per application setting, then it should be on your application > class. You could set this value through your properties file, so you could > supply a different value per deployment. > > You're right, it doesn't belong in the page w