Announcement

Collapse
No announcement yet.

Select string with " character in a select field

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Select string with " character in a select field

    Hi to everybody,
    i have e problem with the select field.
    How can i select a string with " character? if i select that it shows the error invalid data.

    Thanks and regards.

  • #2
    Which select do you use?

    Comment


    • #3
      Thanks for your answer!

      I use the select field of scriptcase but, if there are " charachters in the string (for example: the name of the book is "hello") i need to select, scriptcase shows me the error invalid data.
      Why can't i select its?

      Thanks and regards!

      Comment


      • #4
        There is a query behind the select. What is the query behind it?
        Of course you can always use the QUOTE mysql function.. http://www.w3resource.com/mysql/stri...e-function.php

        That was assuming you use mysql for another database you should use another function with similar working method.

        Comment


        • #5
          Yes, there is this query: select project_name from projects where user='[user_name]' order by project_name.
          I use postgreSQL database.

          Thanks a lot!

          Comment

          Working...
          X