Announcement

Collapse
No announcement yet.

How to clean a double select field and update it

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

  • How to clean a double select field and update it

    Hi all,

    I'm doing a bulk mailing application.
    One of fields in the form is the list of possible e-mail addresses to sent to the email.
    That is a double select field that is filtered on a previous select field i.e. section_ID.
    Everthing works nicely.
    The problem I have, once populated the form and sended the mass mailing, when the application come back to form.
    All form field are cleaned like it would be a new clean insert but the double select field that remains with the previous selected email addresses.
    Is there a way to reset it and run the original select query ?

    Original query of double select field.
    SELECT e_mail FROM members WHERE e_mail <> ''
    AND IF('[glo_section_ID]' <> 0, section_ID = '[glo_section_ID]',section_ID >= 0)
    ORDER BY e_mail

    See image for different three step mentioned.
    1. first access
    2. selected email based on previous section field
    3. once finished the bulk mailing sending

    OnAfterSuccess I've tried to insert the following lines but nothing happens ;-(( :

    $sql_reset_email_to = "SELECT e_mail FROM members WHERE e_mail <> '' ORDER BY e_mail";
    sc_select(reset_email_to, $sql_reset_email_to);

    {email_to} = {reset_email_to};
    Attached Files
    Last edited by giovannino; 01-24-2013, 09:08 AM.

  • #2
    Hello,

    What happens if you refresh the page? Does it gets back to the original list?

    regards,
    Bernhard Bernsmann

    Comment


    • #3
      Hi Bartho,

      only if I do a couple of reselect (in order to make the ONCHANGE activated) it comes to the original right situation.

      Comment


      • #4
        Hello Giovannino,

        I recommend you to contact our support regarding this issue. Our chat is active on workdays from 8:00am to 6:00pm, and our ticket system is always available.

        regards,
        Bernhard Bernsmann

        Comment


        • #5
          Hi Bertho,
          I'm just waiting for more than a week a resolutive reply but until today no news.
          Bye
          Giovannino

          Comment


          • #6
            Hello Giovannino,

            Please send me more info regarding this ticket via PM.

            regards,
            Bernhard Bernsmann

            Comment


            • #7
              Hi Bartho,
              a part from the reset problem I've tested the bulk mail with a pdf attachment .
              I've tried for only one email-address.
              It was incredibly slow (more or less 1,5 minute) to send the message and attachment.
              See on ticket too.

              Comment


              • #8
                Hello gioavnnino,

                The entire process to send an email, will depend on your web server configurations and internet bandwidth.

                regards,
                Bernhard Bernsmann

                Comment

                Working...
                X