Announcement

Collapse
No announcement yet.

pass array into select field

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

  • pass array into select field

    Hi to everybody!
    I have a problem: i have to extract data from database, process them and then pass them into a select field.
    Can i do that with scriptcase 8?

    Thanks

    Michele

  • #2
    I think is not possible, You must create a sql for your Select Field.

    Comment


    • #3
      explain a bit more please, why do you need to do so?, what kind of process?.

      Regards

      Comment


      • #4
        If you can get that processing done in an sql query then it is just basic scriptcase stuff. If it is a bit harder you can create a procedure in your database that processes it.
        Of course there are other solutions so more info would be usefull.

        Comment


        • #5
          Thanks for your answers!
          I explain my problem: i have about 50 rows in a table; i have to select that rows, edit that with a php script and put them in a select field.
          I thought about another solution with a temporary table but there is another problem: if i have a select sql with a lot of rows result, how can i pass to the next row?

          Thanks to everybody

          Comment


          • #6
            something tells me that you are overthinking this... try to do the same you do with php in mysql or mssql (dont know your db) maybe you can do it that way.

            Regards

            Comment


            • #7
              I solve the problem using this code:

              sc_select(rs, $check_sql);

              while(!$rs->EOF)
              {
              $valore_campo_zero = $rs->fields[0];
              $valore_campo_uno = $rs->fields[1];
              $rs->MoveNext();
              }
              $rs->Close();

              Regards

              Comment

              Working...
              X