[Catalyst] Auto_increment in MS SQL

[J. Shirley]

On Fri, May 29, 2009 at 12:48 PM, Ascii King <tech at 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 ta=
ble
> accessed, I get an error with the Identity locking. It wants me to lock t=
he
> 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 at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/catalyst/attachments/20090529/a84d2=
60c/attachment.htm