Re: [Dbix-class] Dynamically removing an auto-increment column

2009-12-08 Thread Steve Bertrand
Peter Rabbitson wrote: > Steve Bertrand wrote: >> (Un)fortunately, this was a case of reading from a stale replicated >> MySQL server... > > Are you doing the reading manually or are you using the Replicated > storage driver? If the former - take a look at Replicated. If the > later - make sure yo

Re: [Dbix-class] Dynamically removing an auto-increment column

2009-12-08 Thread Peter Rabbitson
Steve Bertrand wrote: > (Un)fortunately, this was a case of reading from a stale replicated > MySQL server... Are you doing the reading manually or are you using the Replicated storage driver? If the former - take a look at Replicated. If the later - make sure you wrap your inserts in a transactio

Re: [Dbix-class] MSSQL - problem sorting by joined column while limiting rows

2009-12-08 Thread Peter Rabbitson
Alan Humphrey wrote: >> -Original Message- >> From: Peter Rabbitson [mailto:rabbit+d...@rabbit.us] >> Sent: Saturday, December 05, 2009 1:35 AM >> To: DBIx::Class user and developer list >> Subject: Re: [Dbix-class] MSSQL - problem sorting by joined column >> while limiting rows >> >> Alan

Re: [Dbix-class] Dynamically removing an auto-increment column

2009-12-08 Thread Steve Bertrand
Dermot wrote: > 2009/12/8 Steve Bertrand : >> Hi everyone, > > Hi Steve, > >> I've just began using DBIx::Class late last week. Although I've got it >> doing pretty well everything I want, I'm quite overwhelmed by the amount >> of documentation, and hence, I'm having a hard time locating the >> s

RE: [Dbix-class] MSSQL - problem sorting by joined column while limiting rows

2009-12-08 Thread Alan Humphrey
> -Original Message- > From: Peter Rabbitson [mailto:rabbit+d...@rabbit.us] > Sent: Saturday, December 05, 2009 1:35 AM > To: DBIx::Class user and developer list > Subject: Re: [Dbix-class] MSSQL - problem sorting by joined column > while limiting rows > > Alan Humphrey wrote: > > Hi - >

Re: [Dbix-class] Dynamically removing an auto-increment column

2009-12-08 Thread Dermot
2009/12/8 Steve Bertrand : > Hi everyone, Hi Steve, > I've just began using DBIx::Class late last week. Although I've got it > doing pretty well everything I want, I'm quite overwhelmed by the amount > of documentation, and hence, I'm having a hard time locating the > solution to a specific issue

Re: [Dbix-class] Dynamically removing an auto-increment column

2009-12-08 Thread Steve Bertrand
Peter Rabbitson wrote: > Steve Bertrand wrote: >> For MySQL, I have to have the 'id' field populated with a null value >> when calling create() > > Why? Please explain. Well, I can explain that I've been at this for hours on end, and when I went to dig up the code so I could explain, I realized t

Re: [Dbix-class] Dynamically removing an auto-increment column

2009-12-08 Thread Peter Rabbitson
Steve Bertrand wrote: > For MySQL, I have to have the 'id' field populated with a null value > when calling create() Why? Please explain. ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev

[Dbix-class] Dynamically removing an auto-increment column

2009-12-08 Thread Steve Bertrand
Hi everyone, I've just began using DBIx::Class late last week. Although I've got it doing pretty well everything I want, I'm quite overwhelmed by the amount of documentation, and hence, I'm having a hard time locating the solution to a specific issue. In normal mode, my software uses a MySQL Repl