MySQL Forums
Forum List  »  General

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>

Options: ReplyQuote


Subject
Written By
Posted
CFMX 6.1 and MySQL query problem
February 06, 2005 10:38AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.