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/

Reply via email to