On Fri Jul 21, 2017 at 06:33:55AM +0000, Edmondo Borasio wrote:
> I am updating a record of a SQLite database as follows:
>
> $db->exec('UPDATE Movies SET name = "new movie" WHERE ID="4"');
>
> but instead of using name and ID I want to use some variables, $NewItemName
> and $hId.
>
> Entering the variables as they are won't work. Neither using escape
> characters like \"$DbItemName\" and \"$hId\".
>
> Any idea of the right syntax pls?
It appears that you are using something like Perl or Ruby to access
your database? If that is the case, then you will find that the
concept of "placeholders" is what you are looking for.
Typically you specify a "?" (without the quotes) where you want your
variables to be, and then "bind" the variables to those positions
either before or during the exec call.
Here is the Perl documentation on that topic:
https://metacpan.org/pod/DBI#Placeholders-and-Bind-Values
I suggest you look up the equivalent in whatever language you are
using.
--
Mark Lawrence
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
