[Linux-bruxelles] appel à projet Fondation Roi Baudouin

[Aldo]

On Tue, Nov 15, 2005 at 04:17:38PM +0100, Miguel Quaremme wrote:
> http://www.kbs-frb.be/code/page.cfm?id_page=125&ID=918
> 

Site très bien fait, la preuve:

   Error Occurred While Processing Request

Error Executing Database Query.

   [Macromedia][SQLServer JDBC Driver][SQLServer]Line 1: Incorrect syntax
   near `D125`.

   The error occurred in E:\www_kbs-frb\code\page.cfm: line 49
   Called from E:\www_kbs-frb\code\page.cfm: line 1
   Called from E:\www_kbs-frb\code\page.cfm: line 49
   Called from E:\www_kbs-frb\code\page.cfm: line 1
47 :
48 : <CFQUERY name="qpage" datasource="#application.DSN#">
49 :    exec dbo.qry#mode#_page1 #id_page#,'#sessLG#'
50 : </CFQUERY>
51 :
     _________________________________________________________________

   SQL                exec dbo.qry_page1 3D125,'fr'
   DATASOURCE        FRB
   VENDORERRORCODE   170
   SQLSTATE          HY000
   Please try the following:
     * Check the [1]ColdFusion documentation to verify that you are using
       the correct syntax.
     * Search the [2]Knowledge Base to find a solution to your problem.

   Browser          Lynx/2.8.4rel.1 libwww-FM/2.14 SSL-MM/1.4.1 OpenSSL/0.9.6c
   Remote Address   81.11.176.76
   Referrer      
   Date/Time        15-Nov-05 05:22 PM
   Stack Trace
   at cfpage2ecfm1256696805._factor5(E:\www_kbs-frb\code\page.cfm:49) at
   cfpage2ecfm1256696805.runPage(E:\www_kbs-frb\code\page.cfm:1) at
   cfpage2ecfm1256696805._factor5(E:\www_kbs-frb\code\page.cfm:49) at
   cfpage2ecfm1256696805.runPage(E:\www_kbs-frb\code\page.cfm:1)
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Line 1: In
correct syntax near `D125`.
        at macromedia.jdbc.base.BaseExceptions.createException(Unknown Source)
        at macromedia.jdbc.base.BaseExceptions.getException(Unknown Source)
        at macromedia.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown S
ource)
        at macromedia.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown S
ource)
        at macromedia.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source
)
        at macromedia.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(U
nknown Source)
        at macromedia.jdbc.base.BaseStatement.commonTransitionToState(Unknown S
ource)
        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 coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:
212)
        at coldfusion.sql.Executive.executeQuery(Executive.java:974)
        at coldfusion.sql.Executive.executeQuery(Executive.java:886)
        at coldfusion.sql.SqlImpl.execute(SqlImpl.java:236)
        at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:447)
        at cfpage2ecfm1256696805._factor5(E:\www_kbs-frb\code\page.cfm:49)
        at cfpage2ecfm1256696805.runPage(E:\www_kbs-frb\code\page.cfm:1)
        at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
        at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357)
        at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62)
        at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:10
7)
        at coldfusion.filter.PathFilter.invoke(PathFilter.java:80)
        at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47)
        at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePer
sistenceFilter.java:28)
        at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35)
        at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43)
        at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
        at coldfusion.CfmServlet.service(CfmServlet.java:105)
        at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
        at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
        at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java
:249)
        at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java
:527)
        at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.j
ava:192)
        at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPo
ol.java:348)
        at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.
java:451)
        at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool
.java:294)
        at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)

References sous Lynx:

   1. http://www.macromedia.com/go/proddoc_getdoc
   2. http://www.macromedia.com/support/coldfusion/