On 9/7/06, Robert Dobbs <[EMAIL PROTECTED]> wrote:

>From: "Brandon Black" <[EMAIL PROTECTED]>
>Date: Thu, 7 Sep 2006 12:49:17 -0500
>
>::DBI::Sybase::MSSQL handles the ? placeholder problem already.  The whole
>reason it exists is to solve your problem, as other have had this problem
>before, but ODBC/JDBC might be better alternatives for a whole host of
>other
>reasons, if you can figure out how to set them up correctly.

As per an earlier message from me:

>Ugh!  Yes, I tried that (to '::DBI::Sybase::MSSQL' and '::DBI::MSSQL') but
>then this happens on a 'create':
>
>ct_send(CS_DESCRIBE_INPUT) returned 0 at /usr/lib/perl5/DBD/Sybase.pm line
>124.
>Segmentation fault
>
>However, if I set it to '::DBI::Sybase' it works correctly to save!  I get
>back the ID.  Weird, since I am using MSSQL.

I see how the storage code is supposed to work, but I had hacked DBD::Sybase
to show me the SQL statement it was preparing an sth for.  It did work as
far as creating, and substituted correctly, but when I tried an
$obj->update, the SQL came through to DBD::Sybase with ? placeholders, so I
assumed it wouldn't ever work.

What does that mean?  Are you saying that there's a bug when using DBIx::Class::Storage::DBI::Sybase::MSSQL, or that there was a problem with your hacked copy of DBD::Sybase?  If there is, it would be nice to track it down and make some patches to fix it.

ODBC works fine.

Great :)

-- Brandon


_______________________________________________
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]/

Reply via email to