• Resolved ruimacdonald

    (@ruimacdonald)


    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: https://noticiasongs.org/pesquisa-de-calls/

    Can you help, please?

    Rui Oliveira
    UN Online Volunteer

    https://www.ads-software.com/plugins/abase/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter ruimacdonald

    (@ruimacdonald)

    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

    kellmb

    (@kellmb)

    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 ??

    Plugin Author Richard Halverson

    (@richhalverson)

    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>%’

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Search return 404 error?’ is closed to new replies.