I've seen a lot of posting regarding JDBC instability in CFMX. The issue
I've run across (using CFMX with SQL Server) is where a query passes a blank
where a number is expected. I get the following error:
For example, if #Field2# is an empty string then
<cfquery>
sp_UpdTable '#Field1#', #Field2#, '#Field3#'
</cfquery>
becomes
<cfquery>
sp_UpdTable 'Test1', , 'Test3'
</cfquery>
and ColdFusion throws the following error:
Error Occurred While Processing Request
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver]Syntax error at token , , line 0 offset
31.
Once this occurs, all queries will throw this error until coldfusion is
restarted. I've tested this on several servers with identical results on
each. The only solution I've found so far is to simply make sure that this
doesn't happen. This can be a difficult error to debug since you don't
necessarily know which template actually caused the error in the first
place, and that's the only error that matters... all errors after the first
probably had nothing wrong with them. I usually look in the application.log
file to see where a string of error began popping up.
Hope this is useful to someone.
-Nelson
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
