On 8/23/06, Alan Humphrey <[EMAIL PROTECTED]> wrote:
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
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
_______________________________________________ List: [email protected] Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/[email protected]/ Dev site: http://dev.catalyst.perl.org/
