Re: Primary keys

2014-10-02 Thread Chuck Hill
On 2014-10-02, 10:45 AM, "Mark Wardle" wrote: Thanks Ted, that is interesting. Unfortunately, the existing primary key is used in joins from other tables so I think it will need to be a multi-step procedure. Take home message for me is never ever have primary keys with any kind of meaning, e

Re: Primary keys

2014-10-02 Thread Mark Wardle
Thanks Ted, that is interesting. Unfortunately, the existing primary key is used in joins from other tables so I think it will need to be a multi-step procedure. Take home message for me is never ever have primary keys with any kind of meaning, even if coming from an external reputable third-pa

Re: Primary keys

2014-10-02 Thread Theodore Petrosky
if there is already a primary key, then I think the correct thing to do is to drop the first and add what you want. I have no experience doing this, but it seems logical. ERXMigrationTable theTable = database.existingTableNamed(“yourTable”); theTable.dropPrimaryKey(columns); theTable.setPrimar

Re: Primary keys

2014-10-02 Thread Mark Wardle
Thanks Fabian. Can one use ERXMigration to add a serial column? I don’t think it is a JDBC column type? I can create an integer column and then add the serial default value in SQL presumably. I suspect there isn’t a database agnostic way to do this. I’ll try that. Thank you again, Mark > On

Re: Static resources in CSS file while using Linux as dev platform

2014-10-02 Thread CHRISTOPH WICK | i4innovation GmbH, Bonn
Hi Johann, hi list. Thx again. I missed, that the css and the jpg were in different folders. Now it works like a charm :-) C.U.CW P.S.: Just out of curiosity: has anybody an answer to my original question? How did this work, when Windows was an officially supported platform? -- What are the t

Re: Primary keys

2014-10-02 Thread Fabian Peters
Hi Mark, For postgresql you could add a column "serial". When the column is added, it is populated with values by postgres. You could then use migration's "setPrimaryKey" and "dropPrimaryKey". This is totally untested… Fabian Am 02.10.2014 um 11:00 schrieb Mark Wardle : > Dear all, > > I ne

Re: Static resources in CSS file while using Linux as dev platform

2014-10-02 Thread Johann Werner
Hi Christoph, as Ralf said "use a path relative to the css file“ so you should try: body { background: url("../gfx/background.jpg") repeat; } jw Am 02.10.2014 um 10:58 schrieb Christoph Wick : > Hi Ralf, hi list, > > thanks for your answer. > > Of course, I'm using wonder. > > But it do

Primary keys

2014-10-02 Thread Mark Wardle
Dear all, I need to add a new primary key to a table that already contains data. Is it possible to use migrations to add this and have the column auto-populated with a serial number? My other plan was to create an integer column and then, in code, iterate through the objects manually setting

Re: Static resources in CSS file while using Linux as dev platform

2014-10-02 Thread Christoph Wick
Hi Ralf, hi list, thanks for your answer. Of course, I'm using wonder. But it doesn't work the way you suggest. If I replace > body { > background: > url("/WebObjects/OurApp.woa/Contents/WebServerResources/gfx/background.jpg") > repeat; > } with > body { > background: url("gfx/bac

Re: Static resources in CSS file while using Linux as dev platform

2014-10-02 Thread Ralf Schuchardt
When you are using Wonder, you can simply use a path relative to the css file in the WebSeverResources directory (e.g. url(gfx/background.jpg) ) and it should work in development and deployment. Ralf Am 02.Okt. 2014 um 10:17 schrieb CHRISTOPH WICK | i4innovation GmbH, Bonn : > Hi List, > >

Static resources in CSS file while using Linux as dev platform

2014-10-02 Thread CHRISTOPH WICK | i4innovation GmbH, Bonn
Hi List, I have a question because a colleague of mine wants to test Linux as development platform. Background: --- I the css file of OurApp.woa we refer to background images like e.g. #a-div { background: url("/WebObjects/OurApp.woa/Contents/WebServerResources/gfx/background.jpg")