[Sysadmin] error trying to submit a grrr...
aardvark
roselli at earthlink.net
Tue Apr 29 21:16:01 CDT 2003
from attempting to grrr last comment at:
http://www.evolt.org/evolt/index.cfm?section=comment&subsection=view&a
ction=grrr&tid=22&aid=3631&cid=60303
--------------------
Error Occurred While Processing Request
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]'to_char' is not a
recognized function name.
The error occurred in
F:\inetpub\wwwroot\_evolt_\wwwroot\evolt\comment\act_process.cfm:
line 160
Called from F:\inetpub\wwwroot\_evolt_\wwwroot\evolt\app_comment.cfm:
line 9
Called from F:\inetpub\wwwroot\_evolt_\wwwroot\evolt\app_chooser.cfm:
line 14
Called from F:\inetpub\wwwroot\_evolt_\wwwroot\evolt\home_design.cfm:
line 53
Called from F:\inetpub\wwwroot\_evolt_\wwwroot\evolt\index.cfm: line
21
Called from
F:\inetpub\wwwroot\_evolt_\wwwroot\evolt\comment\act_process.cfm:
line 160
Called from F:\inetpub\wwwroot\_evolt_\wwwroot\evolt\app_comment.cfm:
line 9
Called from F:\inetpub\wwwroot\_evolt_\wwwroot\evolt\app_chooser.cfm:
line 14
Called from F:\inetpub\wwwroot\_evolt_\wwwroot\evolt\home_design.cfm:
line 53
Called from F:\inetpub\wwwroot\_evolt_\wwwroot\evolt\index.cfm: line
21
158 : </cfquery>
159 :
160 : <cfquery name="getcomment" datasource="#data#">
161 : SELECT replies.contentid
162 : , (SELECT who
----------------------------------------------------------------------
----------
SQL SELECT replies.contentid , (SELECT who FROM users WHERE userid
= replies.userid ) AS commentauthor , (SELECT who FROM users WHERE
userid = content.userid ) AS articleauthor , replies.messagename ,
replies.message , replies.grrrs , to_char(replies.datemod,
'mm/dd/yyyy HH:mi:ss') AS datemod , content.contentname ,
content.categoryid FROM replies , content WHERE content.contentid =
replies.contentid AND commentid = 60303
DATASOURCE evolt
VENDORERRORCODE 195
SQLSTATE HY000
Please try the following:
Check the CFML Reference Manual to verify that you are using the
correct syntax.
Search the Knowledge Base to find a solution to your problem.
Browser I'm a Web Browser! Serve Me! (completely incompatible; 300
Trained Monkeys; Runs on Yo' Momma)
Remote Address 65.177.169.41
Referrer
http://www.evolt.org/evolt/index.cfm?section=comment&subsection=view&a
ction=grrr&tid=22&aid=3631&cid=60303
Date/Time 29-Apr-03 07:03 PM
Stack Trace
at
cfact_process2ecfm1269456279.runPage(F:\inetpub\wwwroot\_evolt_\wwwroo
t\evolt\comment\act_process.cfm:160) at
cfapp_comment2ecfm138993171.runPage(F:\inetpub\wwwroot\_evolt_\wwwroot
\evolt\app_comment.cfm:9) at
cfapp_chooser2ecfm667961807.runPage(F:\inetpub\wwwroot\_evolt_\wwwroot
\evolt\app_chooser.cfm:14) at
cfhome_design2ecfm1077247409.runPage(F:\inetpub\wwwroot\_evolt_\wwwroo
t\evolt\home_design.cfm:53) at
cfindex2ecfm348465346.runPage(F:\inetpub\wwwroot\_evolt_\wwwroot\evolt
\index.cfm:21) at
cfact_process2ecfm1269456279.runPage(F:\inetpub\wwwroot\_evolt_\wwwroo
t\evolt\comment\act_process.cfm:160) at
cfapp_comment2ecfm138993171.runPage(F:\inetpub\wwwroot\_evolt_\wwwroot
\evolt\app_comment.cfm:9) at
cfapp_chooser2ecfm667961807.runPage(F:\inetpub\wwwroot\_evolt_\wwwroot
\evolt\app_chooser.cfm:14) at
cfhome_design2ecfm1077247409.runPage(F:\inetpub\wwwroot\_evolt_\wwwroo
t\evolt\home_design.cfm:53) at
cfindex2ecfm348465346.runPage(F:\inetpub\wwwroot\_evolt_\wwwroot\evolt
\index.cfm:21)
java.sql.SQLException: [Macromedia][SQLServer JDBC
Driver][SQLServer]'to_char' is not a recognized function
name.
at macromedia.jdbc.base.BaseExceptions.createException(Unknown
Source)
at macromedia.jdbc.base.BaseExceptions.getException(Unknown Source)
at
macromedia.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown
Source)
at
macromedia.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown
Source)
at macromedia.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown
Source)
at
macromedia.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unk
nown Source)
at
macromedia.jdbc.base.BaseStatement.commonTransitionToState(Unknown
Source)
at macromedia.jdbc.base.BaseStatement.postImplExecute(Unknown
Source)
at macromedia.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at macromedia.jdbc.base.BaseStatement.executeInternal(Unknown
Source)
at macromedia.jdbc.base.BaseStatement.execute(Unknown Source)
at jrun.sql.JRunStatement.execute(JRunStatement.java:333)
at coldfusion.sql.Executive.executeQuery(Unknown Source)
at coldfusion.sql.Executive.executeQuery(Unknown Source)
at coldfusion.sql.SqlImpl.execute(Unknown Source)
at coldfusion.tagext.sql.QueryTag.doEndTag(Unknown Source)
at
cfact_process2ecfm1269456279.runPage(F:\inetpub\wwwroot\_evolt_\wwwroo
t\evolt\comment\act_process.cfm:160)
at coldfusion.runtime.CfJspPage.invoke(Unknown Source)
at coldfusion.tagext.lang.IncludeTag.doStartTag(Unknown Source)
at coldfusion.runtime.CfJspPage._emptyTag(Unknown Source)
at
cfapp_comment2ecfm138993171.runPage(F:\inetpub\wwwroot\_evolt_\wwwroot
\evolt\app_comment.cfm:9)
at coldfusion.runtime.CfJspPage.invoke(Unknown Source)
at coldfusion.tagext.lang.IncludeTag.doStartTag(Unknown Source)
at coldfusion.runtime.CfJspPage._emptyTag(Unknown Source)
at
cfapp_chooser2ecfm667961807.runPage(F:\inetpub\wwwroot\_evolt_\wwwroot
\evolt\app_chooser.cfm:14)
at coldfusion.runtime.CfJspPage.invoke(Unknown Source)
at coldfusion.tagext.lang.IncludeTag.doStartTag(Unknown Source)
at coldfusion.runtime.CfJspPage._emptyTag(Unknown Source)
at
cfhome_design2ecfm1077247409.runPage(F:\inetpub\wwwroot\_evolt_\wwwroo
t\evolt\home_design.cfm:53)
at coldfusion.runtime.CfJspPage.invoke(Unknown Source)
at coldfusion.tagext.lang.IncludeTag.doStartTag(Unknown Source)
at coldfusion.runtime.CfJspPage._emptyTag(Unknown Source)
at
cfindex2ecfm348465346.runPage(F:\inetpub\wwwroot\_evolt_\wwwroot\evolt
\index.cfm:21)
at coldfusion.runtime.CfJspPage.invoke(Unknown Source)
at coldfusion.tagext.lang.IncludeTag.doStartTag(Unknown Source)
at coldfusion.filter.CfincludeFilter.invoke(Unknown Source)
at coldfusion.filter.ApplicationFilter.invoke(Unknown Source)
at coldfusion.filter.PathFilter.invoke(Unknown Source)
at coldfusion.filter.ExceptionFilter.invoke(Unknown Source)
at coldfusion.filter.BrowserDebugFilter.invoke(Unknown Source)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(Unknown
Source)
at coldfusion.filter.BrowserFilter.invoke(Unknown Source)
at coldfusion.filter.GlobalsFilter.invoke(Unknown Source)
at coldfusion.filter.DatasourceFilter.invoke(Unknown Source)
at coldfusion.CfmServlet.service(Unknown Source)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at
jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:2
26)
at
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:5
27)
at
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.jav
a:198)
at
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool
.java:348)
at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.ja
va:451)
at
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.j
ava:294)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
--
my latest book project:
Web Graphics for Non-Designers
http://amazon.com/exec/obidos/ASIN/1904151159/evoltorg02-20
ISBN: 1904151159
More information about the Sysadmin
mailing list