2 Replies Latest reply on May 15, 2008 5:29 AM by nif

    escaping single quotes of query...

    nif
      hi there,

      i am working on my first flex 3 php project and have come up against a bit of a bump.
      i have a php file which basically takes a string parameter from flex which is the sql statement i want to run, it runs it and returns the data.

      my problem arises whenever i use single quotes in a query e.g. select CONCAT(firstname,' ',lastname) as name from users
      if i pass this in i get this error:
      Error #1088: The markup in the document following the root element must be well-formed.

      i have tested and found this happens whenever i try passing single quotes as part of any parameter to the php page.

      i have also tried to escape the ways i know how (\' or ''), but this isn't working and i can't seem to find any info on how to do this.

      does anyone know how i can go about doing this?

      thanks a mil',
      nikki