Hi, I'm having problems with the length of SQL statements.
I have a string of xml that can be very long - the problem is that the xml string is getting cut off at the 64000th character when I create the SQL statement.
The following is ColdFusion code. For those not familiar with ColdFusion - the wddx method changes an array into xml (this is not the problem, I've checked), and the cfqueryparam just strips out apostrophies and whatever (but I also doubt that that is the problem).
-----------
<cfwddx action="cfml2wddx" input='#this.arevisions#' output="xmlrevisions">
<cfquery name="qSaveWorkflow" datasource="#request.stdsn.content#">
update tWorkflow
set xmlrevisions = <cfqueryparam value="#xmlrevisions#" cfsqltype="cf_sql_longvarchar" null="NO">
where Workflowuuid = '#this.workflowuuid#'
</cfquery>
------------
Is there some kind of size limit on SQL statements?
I have a string of xml that can be very long - the problem is that the xml string is getting cut off at the 64000th character when I create the SQL statement.
The following is ColdFusion code. For those not familiar with ColdFusion - the wddx method changes an array into xml (this is not the problem, I've checked), and the cfqueryparam just strips out apostrophies and whatever (but I also doubt that that is the problem).
-----------
<cfwddx action="cfml2wddx" input='#this.arevisions#' output="xmlrevisions">
<cfquery name="qSaveWorkflow" datasource="#request.stdsn.content#">
update tWorkflow
set xmlrevisions = <cfqueryparam value="#xmlrevisions#" cfsqltype="cf_sql_longvarchar" null="NO">
where Workflowuuid = '#this.workflowuuid#'
</cfquery>
------------
Is there some kind of size limit on SQL statements?