New CF_SQL_BIT error?

[Cedric Villat]

The datetype in the db is defined as a "bit".

Here is the stack trace:

java.sql.SQLException: Unknown Types value
        at org.gjt.mm.mysql.PreparedStatement.setObject(Unknown Source)
        at org.gjt.mm.mysql.PreparedStatement.setObject(Unknown Source)
        at jrun.sql.JRunPreparedStatement.setObject(JRunPreparedStatement.java:267)
        at coldfusion.sql.InParameter.setStatement(Unknown Source)
        at coldfusion.sql.ParameterList.setStatement(Unknown Source)
        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 
cflist2ecfm26091753._factor14(D:\Dev_sites\mycfticket\modules\main\list.cfm:8)
        at 
cflist2ecfm26091753.runPage(D:\Dev_sites\mycfticket\modules\main\list.cfm:398)
        at coldfusion.runtime.CfJspPage.invoke(Unknown Source)
        at coldfusion.tagext.lang.IncludeTag.doStartTag(Unknown Source)
        at coldfusion.runtime.CfJspPage._emptyTag(Unknown Source)
        at cfmain2ecfm671157880.runPage(D:\Dev_sites\mycfticket\main.cfm:13)
        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.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:226)
        at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
        at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:198)
        at 
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.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)

Thanks.

Cedric

>Cedric Villat wrote:
>
>> I am getting an error when using <cfqueryparam> and MySQL 4.0.13. Whenever I
>> specify the <cfqueryparam> type to CF_SQL_BIT I get the following error:
>> 
>> Unknown Types value
>
>How does the stack trace look?
>
>> The value I am passing is just 1, and it is hard-coded. If I change the type
>> to CF_SQL_INTEGER it works just fine. Interestingly, this works fine on CF5,
>> but gives the above error when using CFMX.
>
>How is the datatype defined in MySQL?
>
>Jochem
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

                                Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4