Status/Resolution/Reason: Closed/Withdrawn/
Reporter/Name(from Bugbase): Harry Klein / Harry Klein (Harry Klein)
Created: 02/01/2010
Versions: 9.0
Failure Type: Unspecified
Found In Build/Fixed In Build: 0000 /
Priority/Frequency: Normal / Unknown
Locale/System: English / Win All
Vote Count: 0
Problem:
ListQualify should return a string - not a complex value?
Method:
<cfset lTables = "cm_oifilters,cm_oisettings,cm_oitags,cm_xmlprofiles,cm_xmlprofiles_contents_rel,co_channel_formats_rel,co_objecttriggers,co_publishqueue"><!--- delete tablefield entries ---><cfquery datasource="#stContens.sDatasource#" name="qDelTablefieldEntries">DELETEFROM co_tablefieldsWHERE tablename IN (#PreserveSingleQuotes(ListQualify(lTables, "'"))#)</cfquery>Delete tablefield entries => successful<br>Complex constructs are not supported with function PreserveSingleQuotes.Use simple variable instead.The CFML compiler was processing: * The body of a cfquery tag beginning on line 324, column 2.
Result:
Complex constructs are not supported with function PreserveSingleQuotes.Use simple variable instead.The CFML compiler was processing: * The body of a cfquery tag beginning on line 324, column 2.
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 3040875
External Customer Info:
External Company:
External Customer Name: Harry Klein
External Customer Email: 10050DCB445F83AF9920157F
External Test Config: 02/01/2010Attachments:
Comments: