Sc_lookup problem in script

Scriptcase 9 General
, ,
#1

Hello,

I’m using sc_lookup in a script on several time.
I must make a mistake because each time I use the sc_lookup function it return a Null answer or a wrong answer come from nowhere

Example given:

// Requête pour récupérer l’ID du code postal en fonction du code postal
$sqlSelectCP_client = "
SELECT ID
FROM CP
WHERE CP = $cp_client
";
$resultCP_client = sc_lookup(ds, $sqlSelectCP_client);
// Vérification des résultats de la requête
if (!empty($resultCP_client)) {
$cpID_client = $resultCP_client[0][0]; // ID du code postal
} else {
echo “Erreur : Aucun ID trouvé pour le code postal $cp_client
”;
This text will be hidden
}
} else {
echo “Erreur : Impossible d’extraire le code postal et la ville depuis $colR2
”;
}

I’m sure that $cp_client is 1000 and I’m sure that in my DB I have a line with ID=2 CP=1000 VILLE=Bruxelles meanwhile the $cpID_client gives a NULL answer instead of 2

(pdo-mysql): SELECT ID FROM CP WHERE CP = 1000(pdo-mysql): INSERT INTO Client (Societe, Mail, Telephone, Rue, Numero, CP) VALUES (‘Bernard NENIN’, ‘nenin.bernard@gmail.com’, ‘0475 20 14 69’, ‘Rue Saint-Rock’, ‘0039’, ’ ')1366: Incorrect integer value: ’ ’ for column ‘CP’ at row 1

Second case

$sqlLastClientID = “SELECT LAST_INSERT_ID() AS lastClientID”;
$resultClient = sc_lookup(ds, $sqlLastClientID);
$newClientID = $resultClient[0][0];

$NewClientID returns the letter S

(pdo-mysql): SELECT LAST_INSERT_ID() AS lastClientID(pdo-mysql): INSERT INTO Mission ( Reference, Ref_assureur, Date_reception, Date_sinistre, Couverture_batiment, Couverture_contenu, Circonstances, AssureurID, Rue_sinistre, N_sinistre, cp_sinistreID, ClientID ) VALUES ( ‘SI1298242424’, ‘SI1298242424’, NOW(), ‘25-11-24’, ‘521070.69’, ‘151900.67’, ‘Surtension au niveau du coffret électrique. Le fil du neutre était détaché a cause de la tempête. Frigo + congel + chaudière + four micro onde + éclairage + vidéophone qui ne fonctionnent plus.’, ‘2’, ‘Rue Saint-Roch’, ‘39’, ‘2’, ‘S’ )1366: Incorrect integer value: ‘S’ for column ‘ClientID’ at row 1

or the last line is this one in the DB

26 Bernard NENIN NULL Rue Saint-Rock 0039 2 0475 20 14 69 à remplir à remplir 0 nenin.xxxxx@gmail.com

#2

maybe try:
$sqlSelectCP_client = "SELECT ID FROM CP WHERE CP = " . $cp_client;

#3

That send back S as answer like the last example

$sqlLastMissionID = “SELECT LAST_INSERT_ID() AS lastMissionID”;
$resultMission = sc_lookup(ds, $sqlLastMissionID);
$newMissionID = $resultMission[0][0];

I tried the SQL request in PHP My Admin and it returns 2 (what is the correct answer I want)
So I supposed it’s the way sc_lookup treat the answer that mismatch somewhere…
I assumer it’s the S of Select :face_with_monocle:

#4

So if you do $sqlLastClientID = “SELECT LAST_INSERT_ID()";
sc_lookup(ds, $sqlLastClientID);
$newClientID={ds[0][0]};

echo $newClientID;

What do you get?

#5

hello indeed I had to wrote the solution but lake of time…
Functionnal code

            sc_lookup(ds3, "SELECT LAST_INSERT_ID() AS lastClientID");

            $newClientID = {ds3[0][0]};