Hi everyone
I've got a strange problem with a button added to one of my pages, the said button is used to re-compute some fields using a stored procedure (the procedure works no problem here), in order to call the proc I need a couple of extra value that I get by calling CustomQuery() and the $keys array on the server side of the button.
I've done it before on some others pages and it works fine, but here I've a problem with one of the key field, it looks like this '.\3249', when displayed on the list page's main table it looks fine but when added to the user message variable (for test purpose with $keys[$i]["IDPIECE"]) it look like this '.%5C3249'
here is the server side of the button
if(count($keys) != 0){
$result = "meh ";
$nbKeys = count($keys);
for($i=0; $i<$nbKeys; $i++){
$rs2 = CustomQuery("SELECT pa.DECRIPTIONPREV,pt.TOTALAIMBRIQUE from piecetole pt, piece_addon pa WHERE pa.ID='" . $keys[$i]["IDPIECE"] . "' AND pt.IDPIECE = pa.ID AND pt.REFTOLE='" . $keys[$i]["REFTOLE"] . "'" );
$data2 = db_fetch_array($rs2);
$result = $result . " " . $keys[$i]["IDPIECE"];
CustomQuery("Insert into test_debug(meh) VALUES ('" . $keys[$i]["IDPIECE"] . "')");
//CustomQuery("CALL parseDescription('" .$keys[$i]["IDPIECE"]. "','". $data2["DECRIPTIONPREV"] . "'," .$data2["TOTALAIMBRIQUE"]. ",'" .$keys[$i]["REFTOLE"]. "')");
}
As you can see I also tried to insert the key in a test table, I still have the same result, it's probably just an encryption problem but since I'm pretty bad with php I don't know what I can do, can anybody help ?
Thanks in advance