This error looks to me like it's coming from the mysql driver directly. Did you say this code worked somewhere? Are the databases the same version? Are the drivers the same version?
Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ Open BlueDragon Steering Committee Adobe Solution Provider J.B. Mentzer wrote: > Andy Wu wrote: >> Hi JB, >> >> Can you show us the stacktrace that comes with the Internal Server Error? >> >> Thanks >> Andy >> > > In the error screen, "18: SELECT * FROM parts" is in red type. > > Thank you! > > * JB * > > Type Internal > Tag Context CFINCLUDE: Line=20; Column=1 > | > +-- cf_tag_gm_current_parts: Line=106; Column=23 > | > +-- CFQUERY: Line=18; Column=1 > > Source > 15: --> > 16: > 17: <cfquery datasource="#SESSION.dsn#" name="CALLER.gm_parts"> > 18: SELECT * FROM parts > 19: > > ^ Snippet from underlying CFML source > > > Stack Trace > > java.lang.NullPointerException > at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1103) > at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5531) > at com.mysql.jdbc.Field.getCollation(Field.java:469) > at > com.mysql.jdbc.ResultSetMetaData.isCaseSensitive(ResultSetMetaData.java:558) > at com.naryx.tagfusion.cfm.engine.cfQueryResultSetMetaData.(Unknown > Source) > at com.naryx.tagfusion.cfm.engine.cfQueryResultData.populate(Unknown > Source) > at > com.naryx.tagfusion.cfm.sql.cfSQLQueryData.executeAsStatement(Unknown > Source) > at com.naryx.tagfusion.cfm.sql.cfSQLQueryData.execute(Unknown Source) > at com.naryx.tagfusion.cfm.sql.cfSQLQueryData.runQuery(Unknown Source) > at com.naryx.tagfusion.cfm.sql.cfQUERY.executeStatement(Unknown Source) > at com.naryx.tagfusion.cfm.sql.cfQueryImplSQL.render(Unknown Source) > at com.naryx.tagfusion.cfm.sql.cfQUERY.render(Unknown Source) > at com.naryx.tagfusion.cfm.tag.cfTag.coreRender(Unknown Source) > at com.naryx.tagfusion.cfm.tag.cfTag.render(Unknown Source) > at com.naryx.tagfusion.cfm.file.cfFile.render(Unknown Source) > at com.naryx.tagfusion.cfm.tag.cfMODULE.renderCustomTagStart(Unknown > Source) > at com.naryx.tagfusion.cfm.tag.cfMODULE.realCustomRender(Unknown Source) > at com.naryx.tagfusion.cfm.tag.cfMODULE.customRender(Unknown Source) > at com.naryx.tagfusion.cfm.tag.cfCustomTag.render(Unknown Source) > at com.naryx.tagfusion.cfm.tag.cfTag.coreRender(Unknown Source) > at com.naryx.tagfusion.cfm.tag.cfTag.render(Unknown Source) > at com.naryx.tagfusion.cfm.file.cfFile.render(Unknown Source) > at com.naryx.tagfusion.cfm.tag.cfINCLUDE.renderTemplate(Unknown Source) > at com.naryx.tagfusion.cfm.tag.cfINCLUDE.render(Unknown Source) > at com.naryx.tagfusion.cfm.tag.cfTag.coreRender(Unknown Source) > at com.naryx.tagfusion.cfm.tag.cfTag.render(Unknown Source) > at com.naryx.tagfusion.cfm.file.cfFile.render(Unknown Source) > at com.naryx.tagfusion.cfm.engine.cfSession.onRequest(Unknown Source) > at com.naryx.tagfusion.cfm.engine.cfEngine.service(Unknown Source) > at com.naryx.tagfusion.cfm.cfServlet.service(Unknown Source) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) > at > org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502) > at > org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:363) > at > org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) > at > org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181) > at > org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:757) > at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:416) > at > org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114) > at > org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) > at org.mortbay.jetty.Server.handle(Server.java:324) > at > org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:502) > at > org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:826) > at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:523) > at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211) > at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:377) > at > org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409) > at > org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:497) > > >> J.B. Mentzer wrote: >> >>> Hi all, >>> >>> Trying to get one of my websites to work on my Mac running BlueDragon >>> ... and have run into an error I can't resolve. Here's the query in >>> question: >>> >>> <cfquery datasource="#SESSION.dsn#" name="CALLER.gm_parts"> >>> SELECT >>> parts_ID, >>> reference_pn, >>> category, >>> img_med, >>> img_lg, >>> part_name, >>> part_desc, >>> price_each, >>> price_100 >>> >>> FROM >>> parts >>> >>> WHERE >>> product_line = '#SESSION.product_line#' >>> >>> ORDER BY '#ATTRIBUTES.order_by#'; >>> </cfquery> >>> >>> >>> As written, the page generates an "Open BD Internal Server Error" >>> complete with Stack Trace and a verbose dump of variables. >>> >>> When I include an equals sign in the Order By Clause, this error is >>> generated: >>> >>> Query Error You have an error in your SQL syntax; check the manual >>> that corresponds to your MySQL server version for the right syntax to >>> use near '= 'reference_pn'' at line 18. >>> >>> What do I need to do to resolve this? >>> >>> Thank you, >>> >>> * JB * >>> >>> >>> >>> >>> >>> >> >> >> > > > > > > --~--~---------~--~----~------------~-------~--~----~ Open BlueDragon Public Mailing List http://groups.google.com/group/openbd?hl=en official site @ http://www.openbluedragon.org/ !! save a network - trim replies before posting !! -~----------~----~----~----~------~----~------~--~---
