On Fri, May 29, 2009 at 12:48 PM, Ascii King <t...@swattermatter.com> wrote:
> I have my Catalyst system hooked up to a MS SQL Server (thanks Johannes), > but I am running into a problem with the auto_increment system. > > It seems that MS SQL server uses something called an IDENTITY column to do > it's auto incrementing. This is fine and I have it set up and working. > However, when I try to write something to a table other then the first table > accessed, I get an error with the Identity locking. It wants me to lock the > table, then write to it and then unlock it. > > How do you guys get around this problem? Should I just give up on the > auto_increment and write a function to do it myself? Is there a proper way > to do it? > > _______________________________________________ > List: Catalyst@lists.scsys.co.uk > Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst > Searchable archive: > http://www.mail-archive.com/catalyst@lists.scsys.co.uk/ > Dev site: http://dev.catalyst.perl.org/ > Catalyst can't talk to a database. Are you using DBIx::Class, if so there is a separate list for that. Thanks, -Jay
_______________________________________________ List: Catalyst@lists.scsys.co.uk Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/ Dev site: http://dev.catalyst.perl.org/