Problems converting query into SP (ColdFusion related)
I'm trying to convert queries that someone else built into Stored Procedures, and for the most part it's going smoothly. However, there is one query (pretty large and detailed) that is using some CF functions to format part of it, and I'm getting errors sending the data to the SP.
Two of the lines of the query are using CF's "ListQualify" function to put apostrophes around each list element, which (of course) breaks the string for SQL.
Any suggestions on how to preserve the string without removing the apostrophes?
Sorry for taking so long to get back to this. Actually, someone in another forum suggested that I escape the list qualifier (') so it won't break the SQL string ('').. haven't tried it, yet, but will. When I do, I'll be sure to report back, here.