Set your queryparam to sqltype 'CF_SQL_TINYINT' ? It's cheating I know, but should work.
To be honest I have a bad habit of using tinyint's in the database too instead of bit fields, just so I can group by that field if I really have to. Hope that helps. Craig. -----Original Message----- From: Scott Stewart [mailto:[EMAIL PROTECTED] Sent: 11 August 2008 19:14 To: CF-Talk Subject: cfqueryparam and bit field (was:Re: CF 8 Built in SQL Server drivers vs. MS SQL Server 2000 SP3 Driver) The cfqueryparam tags work fine with the character fields, but they're returning true or false as opposed to 1 or 0, even though 1 or 0 is passed to it from the form. Any ideas? Scott Stewart wrote: > That's cool, I appreciate the input. > > thanks > > sas > > Craig Dudley wrote: > >> Had a good look but can't find the examples, it's fairly easy to set up >> anyway. >> >> The MS SQL Server JDBC driver is three/jar fiels I think? Just drop them >> into \ColdFusion8\runtime\jre\lib\ext and restart CF, the .jar should then >> appear in the big CF Server Java Class Path box in settings summary in CF >> Admin. >> >> When you add a datasource, elect other from the driver dropdown it will ask >> you for a JDBC URL, Driver Class and Driver Name. All of which is standard >> JDBC stuff but there are docs in the MS download package I think, it's not >> complex either way but sorry I couldn't find my examples as it might have >> saved some time. >> >> Craig. >> >> -----Original Message----- >> From: Scott Stewart [mailto:[EMAIL PROTECTED] >> Sent: 11 August 2008 17:14 >> To: CF-Talk >> Subject: Re: CF 8 Built in SQL Server drivers vs. MS SQL Server 2000 SP3 >> Driver >> >> Thanks Craig.... >> >> The higher ups have deemed this a "last resort"... so if it comes to >> this I'll put up some results. >> I'm pursuing what could be an issue with cfqueryparam >> >> Craig Dudley wrote: >> >> >>> Not for a while, from memory you just drop the three MS .jar's somewhere >>> >>> >> in >> >> >>> CF's classpath and restart CF to install and creating datasources becomes >>> >>> >> a >> >> >>> bit more dificult, I'll see if I can dig up an example for you. >>> >>> I seem to remember that performance wasn't all that great, in fact, CF7's >>> built in drivers were faster in most of my test cases. Sorry I haven't >>> >>> >> tried >> >> >>> them on CF8. >>> >>> The MS drivers don't cause any issues with CF's built in drivers though so >>> why not give it a try on your dev box? >>> >>> Craig. >>> >>> -----Original Message----- >>> From: Scott Stewart [mailto:[EMAIL PROTECTED] >>> Sent: 11 August 2008 15:10 >>> To: CF-Talk >>> Subject: CF 8 Built in SQL Server drivers vs. MS SQL Server 2000 SP3 >>> >>> >> Driver >> >> >>> Hey all, >>> >>> I've run into an issue that I need opinions on. We've run into some SQL >>> server issues, where MS is saying "patch the driver". >>> Has anyone used the MS SQL Server 2000 SP3 JDBC driver in place of the >>> one shipped with CF8? >>> Has it cleared up 8180 errors? >>> Any performance gains/losses? >>> Any "gotchas"? >>> >>> thanks >>> >>> sas >>> >>> >>> >>> >> >> > > -- -- Scott Stewart ColdFusion Developer Office of Research Information Systems Research & Economic Development University of North Carolina at Chapel Hill Phone:(919)843-2408 Fax: (919)962-3600 Email: [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310850 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
