6.13.tar.gz, from
http://www.sqlite.org/download.html
Regards,
Eugene Wee
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
t would be more like copying Boost.Format.)
Regards,
Eugene Wee
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
.
> I may be using sqlite3 in wrong way?
Instead of using sqlite3_mprintf() and sqlite3_exec() for your insert
statements, try using prepared statements.
Regards,
Eugene Wee
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org
o incremented ,0);
>
> 2-take the phone id value in integer variable
> integer phoneid=value;
>
> 3-pass this value in to address table
> insert into address(phoneid)values(phoneid);
You are probably looking to use sqlite3
On Tue, Apr 21, 2009 at 1:43 PM, Ravi Thapliyal
<thapliyal.r...@gmail.com> wrote:
> Thanks Ken for replying, but I will appreciate if you brief me the process
> of encryption.
Check out the SQLite Encryption Extension
http://www.hwaci.com/sw/sqlite/see.html
Regards
t;:
http://www.sqlite.org/limits.html
It looks like the limit is more on database page size and number of
pages in the database file.
Regards,
Eugene Wee
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
.6 + 0.336 * 7.5 = 9.5584
This rounds to 9.6, which corresponds to:
All tables and indices
Fragmentation......... 9.6%
Regards,
Eugene Wee
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Additionally, double quotes do have a "special meaning" in that they are
used to delimit identifiers.
Regards,
Eugene
On Mon, Dec 15, 2008 at 3:15 PM, John Stanton wrote:
> Single quotes are SQL, as chosen by he designers. It is good practice
> to stick to the standard
article, if it is
applicable:
http://www.sqlite.org/cvstrac/wiki?p=ScrollingCursor
Regards,
Eugene Wee
On Sun, Nov 23, 2008 at 4:16 PM, Gilles Ganault <[EMAIL PROTECTED]>wrote:
>
>> Hello
>>
>>I tried a few things, but I still can't find how to do this: The
>>
Hi,
It sounds like you want a GROUP BY clause, e.g.,
SELECT code, COUNT(code) AS code_count FROM companies GROUP BY code ORDER BY
code_count DESC;
Regards,
Eugene Wee
On Sun, Nov 23, 2008 at 4:16 PM, Gilles Ganault <[EMAIL PROTECTED]>wrote:
> Hello
>
>I tried a few thin
the other is the corresponding string output function?
Thanks,
Eugene Wee
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Hi,
palmer ristevski wrote:
> He is my vote.
> I like the fact that conventions #1 and #2 make things compatible with other
> databases.
> Does #3, by chance, do the same with another database not mentioned
> (eg. Oracle).
>
> If it does not have any compatibility with any other database,
> ONLY
ply apply
PDO::quote to x, y, z (and the rest) individually.
Regards,
Eugene Wee
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
base during demos or testing" use on the "Appropriate
Uses For SQLite" page:
http://www.sqlite.org/whentouse.html
That said, the other uses listed seem to make it clear that SQLite is
indeed suitable for production use.
Regards,
Eugene Wee
_
Hi,
If you want the command line program for working with SQLite 3
databases, then sqlite3.exe is what you are looking for. Placing it in
the system path will do if you want to use it from everywhere.
Regards,
Eugene Wee
On Wed, 2008-04-16 at 20:06 -0400, Robert L Cochran wrote:
> Where exac
12-31. Please
consider upgrading to PHP 5.2."
Regards,
Eugene Wee
[EMAIL PROTECTED] wrote:
> Hello
> I must use SQLite functions of PHP 4, but it seems that these functions
> doesn't works with SQLite 3.
>
> What can I do?
>
> bes
en/ref.pdo-sqlite.php
Regards,
Eugene Wee
Aharon (Rony) Shapira wrote:
> I tried using PDO as follows :
> // create a SQLite3 database file with PDO and return a database handle
>
> try{
>
> $dbHandle = new
> PDO('sqlite:'.$_SERVER['DOCUMENT_ROOT'].'/../pdoTutorial.sqlit
orks fine
>
> Select count(DISTINCT Name) from TableA -- doesn't work, Any reason?
The thing is, it should work.
Regards,
Eugene Wee
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Hi,
What is the error?
It seems to me that both of these should work:
select count(DISTINCT Name) from TableA
select count(DISTINCT Name) as nameCount from TableA
Regards,
Eugene Wee
Bharath Booshan L wrote:
> Thanks for your quick response,
>
>> select count(DISTINCT Name) na
Hi Angela,
Did you wrap the inserts in a transaction?
Regards,
Eugene Wee
Angela Kramer wrote:
> Hi,
>
> I've written a java programm which reads data from a file and inserts
> them into a sqlite database. In order to speed up this process I use
> PreparedStatement.
>
Hi Kirrthana,
you can open an in-memory database by using ":memory:" as the filename.
Read: http://www.sqlite.org/capi3ref.html#sqlite3_open
Regards,
Eugene Wee
Kirrthana.M wrote:
> Hi all,
>
> I just want to know wheather it is possible to create Sqlite3 database in
>
ments and stored
procedures". For further reading:
http://www.php.net/manual/en/function.PDO-prepare.php
http://www.php.net/manual/en/function.PDOStatement-bindParam.php
Regards,
Eugene Wee
Sam Carleton wrote:
> This might be a really basic question and it might be PHP related, not
> SQLit
Hi,
MySQL 5.0.41 and Postgresql 8.2.5 work as you described in their
treatment of NULL. There were some minor syntax tweaks for CREATE TABLE
and the second SELECT EXISTS, but other than that it was true for the
first SELECT EXISTS and false for the second SELECT EXISTS.
Regards,
Eugene Wee
. If not, how does Sqlite3 knows it has to
reissue the query.
You would use sqlite3_reset() or its equivalent in your wrapper's API.
Regards,
Eugene Wee
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
faces", but such an incompatible change to existing interfaces
would be best done in such a version number jump if it is ever intended.
Regards,
Eugene Wee
[EMAIL PROTECTED] wrote:
The transition from 3.4.2 to 3.5.0 will perhaps be the
largest single change to SQLite sinc
You are probably looking for sqlite3_create_function:
http://www.sqlite.org/capi3ref.html#sqlite3_create_function
Regards,
Eugene Wee
Chase wrote:
i need a trigger to create and insert a new guid into a table, but
apparently there is no built-in function for creating guids in sqlite.
i can
ACTION;", 0, 0, 0);
Regards,
Eugene Wee
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
Hi Stev,
Why not just use prepared statements?
Regards,
Eugene Wee
Stephen Sutherland wrote:
Hi ;
I am trying to treat a string before passing it through my SQL statement into the database.
I know that a single apostrophe will break the SQL statement.
So I have to replace them
Hi Bruno,
Why not declare repres_id as INTEGER PRIMARY KEY? You can refer to the
documentation on CREATE TABLE:
http://www.sqlite.org/lang_createtable.html
Regards,
Eugene Wee
Bruno S. Oliveira wrote:
Hi all,
I'm having some trouble in inserting data into a table which its
primary key
Hi,
Well, another way to stand on the shoulders of giants is to use the work of
those giants to build up your own.
Regards,
Eugene Wee
John Stanton wrote:
Both Knuth and Wirth use the approach of a language of their own design
to teach algorithms (and more). Cesar, like Newton, will see
Hi Richard,
Send an email to [EMAIL PROTECTED]
Actually, I sent an email to:
[EMAIL PROTECTED]
Hopefully it has resulted in an unsubscribe confirmation message sent to you,
and replying to that email should unsubscribe you from this list.
Regards,
Eugene Wee
Richard Battagline wrote:
How
]
Regards,
Eugene Wee
John Newby wrote:
whats with all these unsubscribe messages, they're beginning to do my head
in now!!!
On 31/05/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]>
wrote:
unsuscribe
sts that I
subscribe to.
Regards,
Eugene Wee
[EMAIL PROTECTED] wrote:
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
dilettantes remain rude.Where we can almost borrow money from our
earring.Hugo, the friend of Hugo and earns frequent flier miles
with power drill near.
In order t
te "select a from tab1 where a < 10
order by a"
You could take a look at:
http://www.sqlite.org/tclsqlite.html#complete
Basically, it does not validate the syntax, only checks that the SQL statement
is complete (i.e. has a terminating semi-colon).
Regards,
Eugene Wee
Hi,
a look through openoffice howto docs reveals:
http://documentation.openoffice.org/HOW_TO/data_source/SQLite.pdf
Regards,
Eugene Wee
Jay Sprenkle wrote:
Yes, I saw a driver in the programmers documentation section
On 1/28/06, Tomàs Eroles i Forner <[EMAIL PROTECTED]> wrote:
Hel
-VERS--"
to
#define SQLITE_VERSION "3.2.6"
and
#define SQLITE_VERSION_NUMBER --VERSION-NUMBER--
to
#define SQLITE_VERSION_NUMBER 3002006
Regards,
Eugene Wee
Bradley Small wrote:
Thanks for the answers. I will for now assume that I can just take SQLITE.H.IN and rename it to sqli
: *** No rule to make target `doc'. Stop.
How then should I obtain the documentation, aside from that provided online, and
by manually sifting through the source? I'm on MS Windows XP, using MinGW +
MSYS. make doc was run through MSYS.
Thanks,
Eugene Wee
[EMAIL PROTECTED] wrote:
Try 'make doc
in a
transaction, right?
> And, why does adding a begin: / end:commit: around the whole loop speed
> up the operations so drastically???
You need to read the wiki:
http://www.sqlite.org/cvstrac/wiki?p=PerformanceTuning
Eugene Wee
Hi,
On Windows XP testing for SQLite 3.2.5:
:.0 when using the sqlite3 executable downloaded
9.9 when running a program linked to an SQlite3 static library compiled by the
MinGW port of GCC 3.4.2
Eugene Wee
Edzard Pasma wrote:
I found a number where the ROUND () function goes wrong:
SQLite
Hi,
Why not construct the SQL statement dynamically in the C/C++ code? That way your
statement(s) would have variable column names before compilation.
Eugene Wee
Brown, Dave wrote:
Actually I doubt it can - since without the column name it can't create the
prepared statement byte code
urned."
Unfortunately, the implementation of the function is rather opaque to me at this
point, so I really have no idea how to use it, and would like to find out.
Thanks,
Eugene Wee
Hi,
You probably neglected to link to the dll.
What compiler are you using? GCC (i.e. g++)?
Eugene Wee
[EMAIL PROTECTED] wrote:
Hello,
I'd like to use the SQLite Library now for the first time, for my programs
which should run under Linux and Windows.
But I've got problems with the lib
may still be a feasible option.
Eugene Wee
whether for license nor for warranty aspects.
Yeah, there was a discussion on the differences in law in some European
countries and the U.S. and similiar systems at the Open Source Initiative
license discuss mailing list, but I wasnt paying attention :|
Eugene Wee
Disclaimer: I am not a lawyer
-lawyer) that
Larry Rosen's AFL would provide better protection against patent problems - but
then whether or not it really would affect GPLed code is debatable, and that's
not fun if you're just interested in coding.
Eugene Wee
Darren Duncan wrote:
Considering everything brought forth here, can
actually used from the source was sqlite3.h
I have no idea how standard my method is, though.
Eugene Wee
Clay Dowling wrote:
I highly suspect that I'm being a dolt here, but I'm not seeing the
obvious thing. I downloaded the preprocessed Win32 source code in hopes
of compiling a static library
cpp
g++ -o test.exe main.o -lsqlite3
test
Hope someone can point out my mistakes, and point me in the right direction.
Thanks,
Eugene Wee
#include
#include
using std::cout;
using std::cerr;
using std::endl;
int main() {
sqlite3* db;
if (sqlite3_open("mytest.db&q
Hi,
have you considered using UPX to reduce the executable filesize?
http://upx.sourceforge.net
Eugene Wee
Cariotoglou Mike wrote:
1.1 mb I used the [EMAIL PROTECTED] devExpress grid, which is great
functionality-wise but bloats the
Exe.
-Original Message-
From: D. Richard Hipp [mailto
() returns 1, since you cant change magic_quotes_gpc
at runtime.
Alternatively, you can alter php.ini, but that's usually not practical.
Eugene Wee
Peter Jay Salzman wrote:
I've nearly completed converting Wheatblog to sqlite. It's been quite a
learning experience! I've come across a problem I
, and
SQLite Analyzer at
http://www.kraslabs.com/sqlite_analyzer.html
Thanks,
Eugene Wee
50 matches
Mail list logo