Re: [Catalyst] MSSQL and Catalyst

[Alan Humphrey]

-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> 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

_______________________________________________
List: Catalyst@lists.rawmode.org
Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst@lists.rawmode.org/
Dev site: http://dev.catalyst.perl.org/