On 21 Jul 2017 at 10:04, Edmondo Borasio <edmondobora...@gmail.com> wrote:
> Hi Tim.
>
> It *almost* works..
>
> $DbItemNameTest = "new name";
> $hIdTest = "1";
>
> $db->exec ('UPDATE Anagrafica SET name = \'' . $DbItemNameTest .
> '\' WHERE hospital_ID="1"'); //IT WORKS
> $db->exec ('UPDATE Anagrafica SET name = \'' . $DbItemNameTest . '\'
> WHERE hospital_ID=' . $hIdTest); //IT DOESN'T WORK
>
> The second one doesn't work even if I change hIdTest to integer.
>
> $hIdTest = 1;
Well, is hospital_ID stored in your database as a string or as an integer?
If it's an integer, then having $hIdTest as an integer should work. If it's a
string you would leave $hIdTest as a string and change the sql to:
... WHERE hospital_ID=\'' . $hIdTest . '\'');
(I know SQLite can be cleverer than that in doing conversions but I've tried
never to rely on that so am unfamiliar with it)
--
Cheers -- Tim
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
