CFMX 6.1 and MySQL query problem
Posted by:
cjgomez65
Date: February 06, 2005 10:38AM
I'm trying to run the following sql query using cfmx 6.1 and a mysql db. I'm new to MySQL, so I may be missing something on that side. I'm using MySQL 4.1.9.
The curious thing is that when I use the sql portion in the MySQL Query Browser, it works just fine. When I put it in a cfquery tag and run it on a .cfm page, I get a ' [MERANT][SequeLink JDBC Driver]An internal error occurred.' message with no other details.
the only error codes are these:
DATASOURCE chaos
VENDORERRORCODE 7368
SQLSTATE HY000
I have installed the jdbc 3.1.6 drivers and added the path to the jar in the Java & JVM area of the CF Administrator.
Ultimately, I am trying to build a cfc that will use this code to perform a number of queries. All I need to do change a few variables.
Any Ideas?
<cfquery name="nameList" datasource="chaos">
SELECT
t.fldFaction,
t.fldName,
t.fldClass,
t.fldVType,
t.fldWeight,
t.fldUnitID,
m.fldMass,
t.fldMass,
t.fldFaction,
t.fldEra
FROM tbltro t, tblWeightClass w, tblVType v, tblMass m, tblFactions f, tblEra e, tblClass c
WHERE f.fldFactionID = t.fldFaction AND
w.fldWeightID = t.fldWeight AND
m.fldMassID = t.fldMass AND
c.fldClassID = t.fldClass AND
v.fldVTypeID = t.fldVType AND
e.fldEraID = t.fldEra AND
t.fldWeight = 4 AND
t.fldEra = 2 AND
t.fldVType = 1 AND t.fldFaction = 1
ORDER BY t.fldMass, t.fldName
</cfquery>