I thought PK::Auto supported running a query on unique constraints to get the primary key after an insert? I suppose if you don't have any unique constraints, then you're up a certain creek without a paddle.
Robert Dobbs wrote: > > >> > "It is not possible to retrieve the last IDENTITY value after an >> insert done >> > with ?-style placeholders. This is a Sybase limitation/bug, not a >> > DBD::Sybase problem. " >> > >> > Ergh. Anyone know a work-around for this? I searched the list >> archives a >> > bit but didn't find anything recent. >> >> Somewhat related to this: >> https://rt.cpan.org/Ticket/Display.html?id=21260 >> >> If the DBB being used or the DB doesn't support it, what should DBIC >> really do? >> >> Personally, I think failing is the only sane answer. I'd much rather >> find out something isn't going to work that way, rather than 2 hours >> later when the data is bogon. >> >> That's assuming there isn't another way to fix this issue... > > Merp... from DBI manpage under the explicit function "last_insert_id": > > * For some drivers the value may only be available if placeholders > have not been used (e.g., Sybase, MS SQL). In this case the value > returned would be from the last non-placeholder insert statement. > > Bleah. I guess I have to use SQL and be very careful about > de-sqlifying input. > > Mark > > _________________________________________________________________ > Windows Live Spaces is here! It’s easy to create your own personal Web > site. http://spaces.live.com/signup.aspx > > > ------------------------------------------------------------------------ > > _______________________________________________ > List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class > Wiki: http://dbix-class.shadowcatsystems.co.uk/ > IRC: irc.perl.org#dbix-class > SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/ > Searchable Archive: http://www.mail-archive.com/[email protected]/ _______________________________________________ List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class Wiki: http://dbix-class.shadowcatsystems.co.uk/ IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/ Searchable Archive: http://www.mail-archive.com/[email protected]/
