[Plugin: Participants Database] Zero management

  • Resolved Sev

    (@severindauvergne)


    12 years, 8 months ago

    Hello Roland,

    Again me ??
    I have 2 points related to the management of blanks and/or zero.

    First : I created some text fields in which I need to store some 0. But the plugin don’t register that data, it converts it to a blank. I my case it is already an information to know that it is 0, so I would like that this information is kept and not erased. Do you think it comes from your plugin or from a more general configuration of MySQL ?

    Second : I try to use pdb_list with a filter looking at blank fields :

    [pdb_list fields=”last_name, first_name, paiement” filter=’paiement=””‘]

    This filter does not work. What is strange is that the contrary works :

    [pdb_list fields=”last_name, first_name, paiement” filter=’paiement!””‘]

    Is there something I missed in the understanding of the filter or is it a bug ?

    Thanks for your help
    Sev

    https://www.ads-software.com/extend/plugins/participants-database/

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author xnau webdesign

    (@xnau)

    Sev,

    You shouldn’t have any trouble working with zeros if you’re using a text-line field. A date field wont work, because it will think it’s an invalid date.

    The list filtering on the shortcode won’t work, that’s right. I don’t know what you’re trying to do, but perhaps instead of looking for blank fields, put a default value into the field, then filter for that.

    Thread Starter Sev

    (@severindauvergne)

    OK understood.
    In fact it is the upload which cannot handle zero, again this CSV format !

    The plugin manages well the zero, I just add to manually re-enter the missing zero that were not imported.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘[Plugin: Participants Database] Zero management’ is closed to new replies.