[Catalyst] MSSQL and Catalyst

[Brandon Black]

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 >
> 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 

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.rawmode.org/pipermail/catalyst/attachments/20060823/c140b771/attachment-0001.htm