[Catalyst] MSSQL and Catalyst

[Alan Humphrey]

-----Original Message-----
From: catalyst-bounces at lists.rawmode.org
[mailto:catalyst-bounces at lists.rawmode.org] On Behalf Of Brandon Black
Sent: Wednesday, August 23, 2006 7:54 PM
To: The elegant MVC web framework
Subject: Re: [Catalyst] MSSQL and Catalyst

 

 

On 8/23/06, Alan Humphrey <alan.humphrey at comcast.net> wrote:

I had some time so I decided to upgrade my app and see if I could take
advantage of all this.  No joy.  I'm still getting bind parameters.  Info
below.  Any ideas?

Thank you!

- Alan

Version:
~/birdweb/trunk/BirdWeb-Admin > perldoc -l DBIx::Class | xargs cat | grep -i
'$version'
use vars qw($VERSION);
$VERSION = '0.07001';

Output:
~/birdweb/trunk/BirdWeb-Admin >  perl test.pl
SELECT me.id, me.genus_id, me.species_name_id, me.image_id,
me.north_america_map_id, me.washington_map_id, me.default_sound_id,
me.default_bird_common_name_id, me.generic_bird_common_name_id,
me.taxonomic_order, me.identification, me.voice, me.habitat, me.behavior,
me.diet, me.nesting, me.migration, me.where_found, me.conservation_status,
me.breeding, me.notes FROM birds me WHERE ( ( me.id = ? ) ): '56'


Can you test the DBI_TRACE (not DBIC_TRACE) output?  I think in 0.07001 the
DBIC_TRACE output for ::DBI::Sybase::MSSQL would give debug output that
looks like bind vars are being used even if they aren't.  The code in
::DBI::NoBindVars is what should be executing the query.  Toss some debug
statements in there of your own and verify sanity? 

-- Brandon 

 

Ding ding ding!  We have a winner!  Absolutely right. DBI_TRACE shows (among
other things):

 

    <- prepare('SELECT me.id, me.genus_id, me.species_name_id, me.image_id,
me.north_america_map_id, me.washington_map_id, me.default_sound_id,
me.default_bird_common_name_id, me.generic_bird_common_name_id,
me.taxonomic_order, me.identification, me.voice, me.habitat, me.behavior,
me.diet, me.nesting, me.migration, me.where_found, me.conservation_status,
me.breeding, me.notes FROM birds me WHERE ( ( me.id = ...')=
DBI::st=HASH(0x858475c) at NoBindVars.pm line 28

 

All is well.

 

Thanks again Brandon!

 

- Alan

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.rawmode.org/pipermail/catalyst/attachments/20060823/797fa7c8/attachment.htm