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
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
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
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
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
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
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
>
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
8 matches
Mail list logo