[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

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 that I

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

2009-12-08 Thread Dermot
2009/12/8 Steve Bertrand st...@ibctech.ca: 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

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 - If I

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

2009-12-08 Thread Steve Bertrand
Dermot wrote: 2009/12/8 Steve Bertrand st...@ibctech.ca: 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

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 Humphrey wrote:

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 transaction

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 you wrap