Announcement

Collapse
No announcement yet.

Help problems with cs_exec_sql

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

  • Help problems with cs_exec_sql

    I do not recognize the code

    $cadena = {Estudios};

    $sql = "SELECT INSTR('$cadena',',')";

    $prueba = sc_exec_sql ($sql);


    appreciate your help
    Last edited by Estirpe; 01-27-2015, 12:13 PM.

  • #2
    $sql = "SELECT INSTR('".$cadena."',',')";
    /Giuseppe

    Professional Scriptcase Services
    Some Customers opinions

    Comment


    • #3
      You do not get a result from the sc_exec_sql() macro, instead use either sc_lookup() or sc_select().

      http://www.scriptcase.net/docs/en_us...cros#sc_lookup
      http://www.scriptcase.net/docs/en_us...cros#sc_select

      $cadena = {Estudios};

      $sql = "SELECT INSTR('$cadena',',')";
      sc_lookup(rs,$sql);
      //check for errors
      $prueba = {rs[0][0]};

      jsb

      Comment

      Working...
      X