www.webdeveloper.com
Results 1 to 4 of 4

Thread: Problems converting query into SP (ColdFusion related)

  1. #1
    Join Date
    Dec 2002
    Location
    St. Louis, MO, USA
    Posts
    1,582

    Red face Problems converting query into SP (ColdFusion related)

    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,

    ^_^

  2. #2
    Join Date
    Dec 2002
    Location
    St. Louis, MO, USA
    Posts
    1,582

    Combination SQL/CF question

    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,

    ^_^

  3. #3
    Join Date
    Feb 2006
    Posts
    520
    can you post the whole query

  4. #4
    Join Date
    Dec 2002
    Location
    St. Louis, MO, USA
    Posts
    1,582
    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,

    ^_^

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles