Problems converting query into SP (ColdFusion related)

[WolfShade]

Hello, all.

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?

Thanks,

^_^

[WolfShade]

I posted a question in the SQL forum, but it's CF related, so it should also be in here.

http://www.webdeveloper.com/forum/sh...d.php?t=210525

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?

Thanks,

^_^

[TiGGi]

can you post the whole query

[WolfShade]

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.

Thanks,

^_^