[Home] [Downloads] [Search] [Help/forum]

Gammon Forum

See www.mushclient.com/spam for dealing with forum spam. Please read the MUSHclient FAQ!

[Folder]  Entire forum
-> [Folder]  MUSHclient
. -> [Folder]  General
. . -> [Subject]  Binding SQLite3 parameters
Home  |  Users  |  Search  |  FAQ
Username:
Register forum user name
Password:
Forgotten password?

Binding SQLite3 parameters

It is now over 60 days since the last post. This thread is closed.     [Refresh] Refresh page


Posted by Artel   USA  (65 posts)  [Biography] bio
Date Mon 10 Oct 2016 08:36 PM (UTC)
Message
Is there a MUSHclient database function that binds values to a SQLite prepared statement? I.e., something that corresponds to the sqlite3_bind_*() functions in the SQLite3 C api.

Here are the other related methods in MUSHclient (from https://www.gammon.com.au/forum/?id=9262). I was expecting to find a DatabaseBind(BSTR Name, ...) or similar, but I can't find it.

long DatabasePrepare(BSTR Name, BSTR Sql);
long DatabaseStep(BSTR Name);
long DatabaseFinalize(BSTR Name);
long DatabaseReset(BSTR Name);

Artel.
[Go to top] top

Posted by Nick Gammon   Australia  (21,322 posts)  [Biography] bio   Forum Administrator
Date Reply #1 on Mon 10 Oct 2016 08:53 PM (UTC)
Message
You can do it with the Lua SQLite3 interface rather than the generic one. The generic interface would be fiddly to implement because of the different data types, but in Lua you can pass different types down to a function.


http://www.gammon.com.au/scripts/doc.php?lua=stmt:bind

http://www.gammon.com.au/scripts/doc.php?lua=stmt:bind_names

http://www.gammon.com.au/scripts/doc.php?lua=stmt:bind_values

- Nick Gammon

www.gammon.com.au, www.mushclient.com
[Go to top] top

Posted by Artel   USA  (65 posts)  [Biography] bio
Date Reply #2 on Mon 10 Oct 2016 09:37 PM (UTC)

Amended on Mon 10 Oct 2016 09:41 PM (UTC) by Artel

Message
Thanks! That's working perfectly.

Edit: added example snippet for reference


  local target_query = 'thalos'
  local select_statement = assert(db:prepare([[SELECT keyword FROM areas
    WHERE keyword LIKE ?]]))

  select_statement:bind_values(target_query)

  for row in select_statement:nrows() do
    -- do stuff
  end

Artel.
[Go to top] top

The dates and times for posts above are shown in Universal Co-ordinated Time (UTC).

To show them in your local time you can join the forum, and then set the 'time correction' field in your profile to the number of hours difference between your location and UTC time.


1,496 views.

It is now over 60 days since the last post. This thread is closed.     [Refresh] Refresh page

Go to topic:           Search the forum


[Go to top] top

Quick links: MUSHclient. MUSHclient help. Forum shortcuts. Posting templates. Lua modules. Lua documentation.

Information and images on this site are licensed under the Creative Commons Attribution 3.0 Australia License unless stated otherwise.

[Home]


Written by Nick Gammon - 5K   profile for Nick Gammon on Stack Exchange, a network of free, community-driven Q&A sites   Marriage equality

Comments to: Gammon Software support
[RH click to get RSS URL] Forum RSS feed ( https://gammon.com.au/rss/forum.xml )

[Best viewed with any browser - 2K]    [Hosted at FutureQuest]