Re: SQL errors in CF by not in MySQL

2006-05-17 Thread Joelle Tegwen
I did find the problem (at least with this particular query. I'm thinking I should still figure out this driver thing.) I had a column percentEffort DECIMAL(4,1) and that was causing problems. I changed it to FLOAT and it all works now. I did go through and check all of my "output"s though and

Re: SQL errors in CF by not in MySQL

2006-05-16 Thread Denny Valliant
On 5/16/06, Joelle Tegwen <[EMAIL PROTECTED]> wrote: > > Are you talking about the MySQL JDBC driver or a CF driver? I couldn't > find any reference to a driver higher than 3.51 the searches brought up > older stuff. Yeah, the numbering is sorta confusing. I still haven't quite figured it out, b

Re: SQL errors in CF by not in MySQL

2006-05-16 Thread rhymes with 'loud'
Joelle, If you subsitute in a known good ID instead of the variable values for project ID, does your cfquery work then? I'm suspecting that perhaps the getProjectID() method in the cfc may not have its "output" attribute set to false, thus possibly returning some extra space with your actual pro

Re: SQL errors in CF by not in MySQL

2006-05-16 Thread Joelle Tegwen
Are you talking about the MySQL JDBC driver or a CF driver? I couldn't find any reference to a driver higher than 3.51 the searches brought up older stuff. I use MySQLs ODBC driver should I be using JDBC? I have server access so none of that is a problem. Thanks Joelle Cutter (CFRelated) wrot

Re: SQL errors in CF by not in MySQL

2006-05-15 Thread Marty Johll
FWIW: I'm using the 3.0.17-ga driver also. Haven't had any problems. On 5/15/06, Denny Valliant <[EMAIL PROTECTED]> wrote: > > You'll probably want to run the 3.0.17-ga driver if you're using 5. > > I didn't have any troubles with 3.1.7 and MySQL 4.1, but it was > slow as molasses with MySQL 5. D

Re: SQL errors in CF by not in MySQL

2006-05-15 Thread Denny Valliant
You'll probably want to run the 3.0.17-ga driver if you're using 5. I didn't have any troubles with 3.1.7 and MySQL 4.1, but it was slow as molasses with MySQL 5. Downgrading seems to have sped things up considerably. Newer driver versions (than 3.1.7) seem to have the same problem. :De On 5/1

Re: SQL errors in CF by not in MySQL

2006-05-15 Thread Cutter (CFRelated)
Which JDBC driver are you running? If you're running the default CF7 install then you're only working with a 3.51 driver. There are Adobe Technotes on how to upgrade and specify (but you will require server access). Cutter Joelle Tegwen wrote: > I'm running CFMX 7 with MySQL 5.0 on Windows >

SQL errors in CF by not in MySQL

2006-05-15 Thread Joelle Tegwen
I'm running CFMX 7 with MySQL 5.0 on Windows I've got this query: SELECT * FROM assignment WHERE projectID=#arguments.project.getProjectID()# ORDER BY x500, startDate DESC the dsn has full CRUD privileges on this table When I run