sc_lookup macro "ID" instead number

Scriptcase 8 Discussion
#1

$check_sql = “SELECT field01, field02, field03, field04, … from sometable;”;
sc_lookup(rs, $check_sql);

How can i get the value of “field02” by acessing it by its index name?

 $field02 = {rs[0][[B]"field02"[/B]]};

instead of this?

$field02 = {rs[0][1]};

Like in this php exemple


http://www.w3schools.com/php/php_mysql_select.asp

while($row = $result->fetch_assoc()) {
        echo "id: " . $row["[B]id[/B]"]. " - Name: " . $row["[B]firstname[/B]"]. " " . $row["[B]lastname[/B]"]. "<br>";
    }
#2

Using sc_select instead sc_lookup. Sc_lookup returns an array (not associative) while sc_select returns an ADOrecordset

{rs}->Field(‘field02’)

Speaking from memory

#3

I will try, thanks Giu.

Best Regards,
V?tor Pereira

#4

[QUOTE=Giu;39066]Using sc_select instead sc_lookup. Sc_lookup returns an array (not associative) while sc_select returns an ADOrecordset

{rs}->Field(‘field02’)

Speaking from memory[/QUOTE]

Thanks for the help, its {rs}->[B]fields/B

from http://www.scriptcase.com.br/docs/pt_br/macros-scriptcase/macros-scriptcase#sc_select

sc_select(meus_dados, "select clienteid, nomecliente, limitecred from clientes");
if ({meus_dados} === false)
{
echo "Erro de acesso. Mensagem = " . {meus_dados_erro};
}
else
{
while (!$meus_dados->EOF){
{nome_cliente} = [B]$meus_dados->fields['clienteid'];[/B]
$meus_dados->MoveNext();
}
$meus_dados->Close();
}