Hi Shamil,
yes, John's is more concise and better still, it works:
my use of [list insert ...] caused the last element to be delimited by
{} as it contains spaces.
Regards,
Arjen
On 2011-12-08 05:06, Shamil F. Daghestani wrote:
Thanks. It works even with my original list: set roads [list {Mil
Thanks. It works even with my original list: set roads [list {Miller lane}
{Pine street} {Wilson blvd}]
/sd
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of John Gillespie
Sent: Wednesday, December 07, 2011 5:22 PM
To: Genera
Try
set roads {"Miller lane" "Pine street" "Wilson blvd"}
set SQL "insert into myTable VALUES( '[join $road "','"]' )"
db eval $SQL
# note the single quotes on each side of the join command
# and the argument to the join command.
JG
___
sqlite-users mai
Thanks for your response, Arjen.
I tried:
##
set roads [list {Miller lane} {Pine street} {Wilson blvd}]
package require sqlite
sqlite db [file join c:/test.sql]
set sqlRoads {}
foreach road $roads {
lappend sqlRoads "'$road'"
}
db eval [list insert into myTable VALUES([join $sqlRoads
Do like a lot of us do and forget the DLL and just put sqlite3.c/h into your
project.
Then you can build and forget about it and it will always work in your project
(barring any future 32/64 incompatibilities). And you don't have to worry about
who's testing what bitset as it's completely sel
On a Windows 7 64 bit desktop machine we downloaded the 64-bit SQlite dll.
As can be seen at
http://www.imagsts.com/BeisaTechnical.html
we had to change a parameter in Visual Studio 2010 for the application to run
inside Visual Studio (typical debugging mode). All seemed well until we went to
buil
On 7/12/2011 6:33 AM, Simon Slavin wrote:
Right. One way to do it is to have a table in the database used to point to
the next database. Normally that table has zero rows in it. You can check it
with
SELECT COUNT(*) FROM databaseObsolete
when an entry does appear in it the count switches t
On Wed, Dec 7, 2011 at 2:48 AM, Max Vlasov wrote:
>
> btw, could not find exact steps for getting trunk amalgamation.
> Is it :
> - get
> http://www.sqlite.org/src/tarball/sqlite-latest-trunk.tar.gz?uuid=trunk
> - extract on a unix-compatible machine
> - ./configure
> - make sqlite3.c
>
You buil
Hi,
I am pleased to announce the release of ODB 1.7.0.
ODB is an open-source object-relational mapping (ORM) system for C++. It
allows you to persist C++ objects to a relational database without having
to deal with tables, columns, or SQL and without manually writing any of
the mapping code.
Maj
Hi Shamil,
I am not an expert in SQL, but how about:
set sqlRoads {}
foreach road $roads {
lappend sqlRoads "'$road'"
}
db eval [list insert into myTable VALUES([join $sqlRoads ,])]
That way, the values are properly formatted, delimited by single quotes
and separated by commas.
Regards,
Ar
10 matches
Mail list logo