Use of an ampersand (&) in Data Field

  • Resolved Rich

    (@rpm765)


    5 months, 3 weeks ago

    The author involved with this record uses the name “C&O Allan” for his “Forum_Name.” If I use the ampersand in the data field holding this person’s forum_name, a search using this code
    [wpdataaccess pub_id=”1″ filter_field_name=”forum_name” filter_field_value=”C&O Allan”] returns no results. If I eliminate the ampersand in the database and the query, it works.

    How can I use an Ampersand in this context?

    • This topic was modified 5 months, 3 weeks ago by Rich.

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Contributor Kim L

    (@kimmyx)

    Hi @rpm765,

    The filter_field_value parameter performs a LIKE.

    Could you try the following:

    [wpdataaccess pub_id="1" filter_field_name="forum_name" filter_field_value="%C&O Allan%"]

    Let us know if that works. ??

    Thread Starter Rich

    (@rpm765)

    Kim,

    Unfortunately it did not work. Same result when using the “%” signs in the query.

    Plugin Contributor Kim L

    (@kimmyx)

    Hi @rpm765,

    Thanks for letting us know.

    I’ve forwarded your question to Peter so he can provide a clarification.

    Peter or I will send an update.

    We appreciate your patience. ??

Viewing 3 replies - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.