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?
Combination SQL/CF question
I posted a question in the SQL forum, but it's CF related, so it should also be in here.
A problem with converting a query into a Stored Procedure; query is using CF's "ListQualify" function which is breaking the string sent to SQL. Any suggestions?