Can anyone help me

Scriptcase 8 Discussion
#1

I have a code like this

sc_lookup(dataset,“select ID, SCTS_D, NOOA, UD from inbox where ISPROCESSED = ‘0’”);

$id = {dataset[0][0]};
$tgl = {dataset[0][1]};
$member = {dataset[0][2]};
$pesan = {dataset[0][3]};
$split = explode(".",$pesan);
$split1 = $split[0];
$split2 = $split[1];
$split3 = $split[2];

sc_exec_sql("INSERT INTO transaksi (IDI,tgl,member,kode,produk,idpel) VALUES ($id,$tgl,$member,$split1,$split2,$split3) ");

sc_exec_sql("UPDATE inbox SET ISPROCESSED = ‘1’ WHERE ID = ‘$id’ ");

I have check many times in my opinion there is nothing wrong, but why an error message ?

#2

[QUOTE=adityaarnugraha;41660]I have a code like this

sc_lookup(dataset,“select ID, SCTS_D, NOOA, UD from inbox where ISPROCESSED = ‘0’”);

$id = {dataset[0][0]};
$tgl = {dataset[0][1]};
$member = {dataset[0][2]};
$pesan = {dataset[0][3]};
$split = explode(".",$pesan);
$split1 = $split[0];
$split2 = $split[1];
$split3 = $split[2];

sc_exec_sql("INSERT INTO transaksi (IDI,tgl,member,kode,produk,idpel) VALUES ($id,$tgl,$member,$split1,$split2,$split3) ");

sc_exec_sql("UPDATE inbox SET ISPROCESSED = ‘1’ WHERE ID = ‘$id’ ");

I have check many times in my opinion there is nothing wrong, but why an error message ?[/QUOTE]

after I check the variable
$split1 = $split[0];
$split2 = $split[1];
$split3 = $split[2];
can not be entered into sc_exec_sql
I do not know why this happened, no one can help me ?

#3

What’s the error message?

AFAIK, it should be written like this

sc_exec_sql("INSERT INTO transaksi (IDI,tgl,member,kode,produk,idpel) VALUES ('".$id."','".$tgl."','".$member."','".$split1."','".$split2."','".$split3."') ");
#4

[QUOTE=anjellz;41664]What’s the error message?

AFAIK, it should be written like this

sc_exec_sql("INSERT INTO transaksi (IDI,tgl,member,kode,produk,idpel) VALUES ('".$id."','".$tgl."','".$member."','".$split1."','".$split2."','".$split3."') ");

[/QUOTE]

ok thanks, proplem solve