WordPress.org

Ready to get started?Download WordPress

Forums

ABASE
[resolved] Search return 404 error? (4 posts)

  1. ruimacdonald
    Member
    Posted 9 months ago #

    I have created a page for search the database with the following code:

    #1. [abase form="search,1" table="calls" elements="name,entity,description,notes,link,year,month,day" columns="name,entity,description,notes!'75',year!'50',month!'25',day!'25'$Search Calls" echo="blue" ack="green"]

    #2. [abase table="calls" columns="name,entity,description,notes,link,year,month,day" echo=blue" ack="green"]

    And the result I have is a 404 error.

    You can see it here: http://noticiasongs.org/pesquisa-de-calls/

    Can you help, please?

    Rui Oliveira
    UN Online Volunteer

    http://wordpress.org/plugins/abase/

  2. ruimacdonald
    Member
    Posted 9 months ago #

    Ok, I have done some experiences and I found:

    1st the SEARCH is for the intire content of a field.

    2nd when I try to search a int field like the Year it gives a 404 error.

    Can't we change the Search for "like"?

    Please help to solve this issue.

    Regards

    Rui Oliveira
    UN Online Volunteer

  3. kellmb
    Member
    Posted 9 months ago #

    I also really need the search to be 'LIKE' not exact. It would make your plugin work for me. Unfortunately it's not going to be usable for me as it is. It's a great plug in by the way, and with this change on the search it'd be 5 stars all the way :)

  4. Richard Halverson
    Member
    Plugin Author

    Posted 8 months ago #

    Please update to version 2.2.1. LIKE is used when you specify the operand in the field specification for the column. For example, [abase table="table1" form="1,search" columns="name"] will produce an SQL statement with a WHERE clause that searches name exactly: name='<name_value>'. [abase table="table1" form="1,search" columns="name=%name%"] will produce a WHERE clause that will search name='%<name_value>%'

Reply

You must log in to post.

About this Plugin

About this Topic

Tags

No tags yet.