??CF7.1?CF_SQL_BLOB??

[swordsman_lszrx]

<cfset
aa="FFD8FFE000104A46494600010100000100010000FFDB00 430003020203020203030303040303
04050805050404050A070706080C0A0C0C0B0A0B0B0D0E1210 0D0E110E0B0B101610111314151515
0C0F171816141812141514FFDB004301030404050405090505 09140D0B0D14141414141414141414
14141414141414141414141414141414141414141414141414 141414141414141414141414141414
FFC00011080083005B03012200021101031101FFC4001F0000 010501010101010100000000000000
000102030405060708090A0BFFC400B5100002010303020403 050504040000017D01020300041105
122131410613516107227114328191A1082342B1C11552D1F0 2433627282090A161718191A252627
28292A3435363738393A434445464748494A53545556575859 5A636465666768696A737475767778
797A838485868788898A92939495969798999AA2A3A4A5A6A7 A8A9AAB2B3B4B5B6B7B8B9BAC2C3C4
C5C6C7C8C9CAD2D3D4D5D6D7D8D9DAE1E2E3E4E5E6E7E8E9EA F1F2F3F4F5F6F7F8F9FAFFC4001F01
00030101010101010101010000000000000102030405060708 090A0BFFC400B51100020102040403
04070504040001027700010203110405213106124151076171 1322328108144291A1B1C109233352
F0156272D10A162434E125F11718191A262728292A35363738 393A434445464748494A5354555657
58595A636465666768696A737475767778797A828384858687 88898A92939495969798999AA2A3A4
A5A6A7A8A9AAB2B3B4B5B6B7B8B9BAC2C3C4C5C6C7C8C9CAD2 D3D4D5D6D7D8D9DAE2E3E4E5E6E7E8
E9EAF2F3F4F5F6F7F8F9FAFFDA000C03010002110311003F00 FB568A28AE23A028A28A0028A28A00
28A28A0028A28A0028A28A0028A28A0028A28A0028A28A0028 A28A0028A28A0028A28A0028A28A00
28A28A0028A28A0028A28A0028A28A0028A28A0028A28A0028 A28A0028A28A0028A28A0028A28A00
28A28A0028A28A0028A28A0028A28A0028A28A0028A28A0028 A28A0028A28A0028A28A0028A28A00
28A28A0028A28A0028A28A0028A28A0028A28A0028A28A0028 A28A0028A28A0028A28A0028A28A00
28A28A0028A28A0028A28A0028A28A0028A28A0028A28A0028 A28A0028A28A0028A28A0028A28A00
28A28A00FFD9">
<cfquery datasource="#dsn#">
insert into img (content) values (<cfqueryparam cfsqltype="cf_sql_blob"
value="#aa#">)
</cfquery>
??content?image?????
cf6.1 ? cf7.1 ??????????????????
cf7.1????:
Error casting an object of type to an incompatible type. This usually
indicates a programming error in Java, although it could also mean you have
tried to use a foreign object in a different way than it was designed.
java.lang.ClassCastException
at coldfusion.sql.InParameter.setStatement(InParamete r.java:49)
at coldfusion.sql.ParameterList.setStatement(Paramete rList.java:107)
at coldfusion.sql.Executive.executeQuery(Executive.ja va:721)
at coldfusion.sql.Executive.executeQuery(Executive.ja va:652)
at coldfusion.sql.Executive.executeQuery(Executive.ja va:613)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:236)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.j ava:499)
at cftest2ecfm1998227907.runPage(D:\wwwroot\lgy.ldga1 10.com\test.cfm:12)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java :152)
at coldfusion.tagext.lang.IncludeTag.doStartTag(Inclu deTag.java:349)
at coldfusion.filter.CfincludeFilter.invoke(Cfinclude Filter.java:65)
at coldfusion.filter.ApplicationFilter.invoke(Applica tionFilter.java:210)
at coldfusion.filter.PathFilter.invoke(PathFilter.jav a:86)
at coldfusion.filter.ExceptionFilter.invoke(Exception Filter.java:69)
at
coldfusion.filter.ClientScopePersistenceFilter.inv oke(ClientScopePersistenceFilt
er.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilt er.java:38)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilt er.java:38)
at coldfusion.filter.DatasourceFilter.invoke(Datasour ceFilter.java:22)
at
coldfusion.filter.RequestThrottleFilter.invoke(Req uestThrottleFilter.java:115)
at coldfusion.CfmServlet.service(CfmServlet.java:107)
at coldfusion.bootstrap.BootstrapServlet.service(Boot strapServlet.java:78)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker. java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvok erChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequ estDispatcher.java:257)
at jrun.servlet.ServletEngineService.dispatch(Servlet EngineService.java:541)
at
jrun.servlet.jrpp.JRunProxyService.invokeRunnable( JRunProxyService.java:204)
at
jrunx.scheduler.ThreadPool$DownstreamMetrics.invok eRunnable(ThreadPool.java:318)
at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRu nnable(ThreadPool.java:426)
at
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeR unnable(ThreadPool.java:264)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java :66)

[sdittbrenner]

I'm not shure but i think that the problem is the <cfset ..>. This will create a STRING object while your <cfqueryparam ...> expect a binary object like a loaded file.

[swordsman_lszrx]

cf6.1 ok.
cf7.0.1 Error .
cf7.0.1 ?????

[sdittbrenner]

You can verifing my assumption in using the cf function "BinaryDecode".
BinaryDecode
Description
Converts a string to a binary object. Used to convert binary data that has
been encoded into string format back into binary data.

[swordsman_lszrx]

Thank you!
ok!