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 !!
-~----------~----~----~----~------~----~------~--~---
