Re: CF 8 Built in SQL Server drivers vs. MS SQL Server 2000 SP3 Driver

2008-08-13 Thread Tom Chiverton
On Monday 11 Aug 2008, Scott Stewart wrote: the main weirdness that I've found is that cfqueryparam is returning true or false which is a valid response for a boolean but not what a SQL server bit field is expecting. (IE: 1 or 0) And what value are you passing into the cfqp there ? Sounds like

RE: cfqueryparam and bit field (was:Re: CF 8 Built in SQL Server drivers vs. MS SQL Server 2000 SP3 Driver)

2008-08-12 Thread Craig Dudley
: 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

CF 8 Built in SQL Server drivers vs. MS SQL Server 2000 SP3 Driver

2008-08-11 Thread Scott Stewart
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

Re: CF 8 Built in SQL Server drivers vs. MS SQL Server 2000 SP3 Driver

2008-08-11 Thread Tom Chiverton
On Monday 11 Aug 2008, Scott Stewart wrote: 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. And what has Adobe said ? -- Tom Chiverton This email is sent for and

RE: CF 8 Built in SQL Server drivers vs. MS SQL Server 2000 SP3 Driver

2008-08-11 Thread Craig Dudley
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

Re: CF 8 Built in SQL Server drivers vs. MS SQL Server 2000 SP3 Driver

2008-08-11 Thread Scott Stewart
Nothing, I've found a couple of CF blogs that point to cfqueryparam as being the culprit... But it's in very specific cases: http://www.petefreitag.com/item/677.cfm However, mine is a basic insert statement. the error code(s) returned are: [Macromedia][SQLServer JDBC Driver][SQLServer]Line

Re: CF 8 Built in SQL Server drivers vs. MS SQL Server 2000 SP3 Driver

2008-08-11 Thread Scott Stewart
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

RE: CF 8 Built in SQL Server drivers vs. MS SQL Server 2000 SP3 Driver

2008-08-11 Thread Craig Dudley
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

Re: CF 8 Built in SQL Server drivers vs. MS SQL Server 2000 SP3 Driver

2008-08-11 Thread Scott Stewart
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

cfqueryparam and bit field (was:Re: CF 8 Built in SQL Server drivers vs. MS SQL Server 2000 SP3 Driver)

2008-08-11 Thread Scott Stewart
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