[YAN HONG YE]
sqlite3_exec( db, ???, 0, 0, pErrMsg);
I wanna add this following command into sqlite3_exec func:
sqlite3 -html -header mydzh.db \select * from dhq where ph1510;\ mm.html
like this:
sqlite3_exec( db, -html -header \select * from dhq where ph1510;\
mm.html, 0, 0, pErrMsg);
sqlite3 -html C:\mydatabase\mydzh.db select 'table'mm.html
this command result is not table in the mm.html file, it's this following
text:
TRTDlt;tablegt;/TD
/TR
not I wanted, how to wrie table char in my html file?
___
sqlite-users mailing list
[YAN HONG YE]
sqlite3 -html C:\mydatabase\mydzh.db select 'table'mm.html
this command result is not table in the mm.html file, it's this following
text:
TRTDlt;tablegt;/TD
/TR
not I wanted, how to wrie table char in my html file?
That would create invalid html. lt;tablegt; will be
On Fri, Mar 30, 2012 at 07:38:11PM -0400, Richard Hipp wrote:
It is easy enough for use to just put a patch in the code to fix this. But
we would rather understand what is happening first. Can you recreate the
problem? Can you give us any clues what you are doing in order to make
this
Richard Hipp wrote:
On Thu, Feb 23, 2012 at 12:29 PM, Petite Abeille
petite.abei...@gmail.comwrote:
On Feb 23, 2012, at 6:21 PM, Levi Haskell wrote:
sqlite select 1 from (select *);
Wow, wicked :)
Confirmed on sqlite3 -version
3.7.10 2012-01-16 13:28:40
Yuriy Kaminskiy wrote:
Richard Hipp wrote:
On Thu, Feb 23, 2012 at 12:29 PM, Petite Abeille
petite.abei...@gmail.comwrote:
On Feb 23, 2012, at 6:21 PM, Levi Haskell wrote:
sqlite select 1 from (select *);
Wow, wicked :)
Confirmed on sqlite3 -version
3.7.10 2012-01-16 13:28:40
Hi, while compiling for Android, I ran into the issue where
arm-linux-androideabi is not recognized as a host. Apparently there is an
updated version of config.guess and config.sub (from AutoTools) that
addresses this issue. Recommend an update of these two files in the next
version.
In case
valgrind ./testfixture test/trigger7.test
Note: line numbers below are off-by-2.
trigger7-2.1... Ok
trigger7-2.2...==11533== Invalid read of size 1
==11533==at 0x401FD90: memcpy (mc_replace_strmem.c:482)
==11533==by 0x8098EE2: sqlite3VdbeMemGrow (vdbemem.c:90)
==11533==by 0x80CD503:
On 31 Mar 2012, at 7:55am, YAN HONG YE yanhong...@mpsa.com wrote:
how to wrie table char in my html file?
In Unix,
echo 'table' mm.html
In Windows it is something like
echo 'table' mm.html
Simon.
___
sqlite-users mailing list
Hello!
I just found a typo in http://www.sqlite.org/fileformat.html
Search for stored with the must significant byte first that should read:
stored with the most significant byte first.
A one letter typo, no big deal.
--
Barbu Paul - Gheorghe
Common sense is not so common - Voltaire
Visit My
On 03/31/2012 04:04 PM, Yuriy Kaminskiy wrote:
valgrind ./testfixture test/trigger7.test
Note: line numbers below are off-by-2.
trigger7-2.1... Ok
trigger7-2.2...==11533== Invalid read of size 1
Seems always reproducible.
Thanks for reporting this.
These tests are run with valgrind as part
J Decker wrote:
'1LINK : fatal error LNK1181: cannot open input file
'M:\clapps\xperdex\SQLite\1.0.79.0\SQLite.Interop\..\bin\2010\DebugModule\bi
n\System.Data.SQLite.netmodule''
In your new solution, the SQLite.Interop.* project(s) should have the
System.Data.SQLite.Module.* project
What you want is the system() function which will execute a shell command.
But you still need to add your own HTML around it to be displayed by a browser
as it's missing the rest of the story.
system(echo HTML mm.html); // first one creates mm.html
system(echo TABLE BORDER=1 mm.html); //
Hello,
I would like to report a sqlite problem:
Covering indices are preferred over indices covering more terms in a join.
This leads to a suboptimal query plan.
In the example below index idx_tableB_full is used instead of
idx_tableB_partial,
even though the partial index covers
On Sat, Mar 31, 2012 at 2:55 AM, YAN HONG YE yanhong...@mpsa.com wrote:
sqlite3 -html C:\mydatabase\mydzh.db select 'table'mm.html
this command result is not table in the mm.html file, it's this following
text:
TRTDlt;tablegt;/TD
/TR
not I wanted, how to wrie table char in my html file?
On Fri, Mar 30, 2012 at 9:42 AM, Reinco Hof reinco@mapscape.eu wrote:
Hello,
I would like to report a sqlite problem:
Covering indices are preferred over indices covering more terms in a join.
This leads to a suboptimal query plan.
I think that in this case, SQLite is choosing
On 31 Mar 2012, at 12:48pm, Black, Michael (IS) michael.bla...@ngc.com
wrote:
What you want is the system() function which will execute a shell command.
But you still need to add your own HTML around it to be displayed by a
browser as it's missing the rest of the story.
Arrrgghhh...that's what I get for coding off the top of my head.
As somebody else pointed out Window escapes are different than Unix.
So these work (and have been tested now on Windows XP and Redhat).
Windows
main()
{
system(echo ^HTML^ mm.html);
}
Unix
system(echo \HTML\
Hi all!
Sqlite version 3.7.11 on Windows cause error in my program. Some of my
pending statements are aborted by a nested savepoint transaction. See:
SAVEPOINT x1;
SELECT * FROM sometable; //just open statement and left it opened!
SAVEPOINT x2;
RELEASE x2;
... call sqlite3_step on previously
Dan Kennedy wrote:
On 03/31/2012 04:04 PM, Yuriy Kaminskiy wrote:
valgrind ./testfixture test/trigger7.test
Note: line numbers below are off-by-2.
trigger7-2.1... Ok
trigger7-2.2...==11533== Invalid read of size 1
Seems always reproducible.
Thanks for reporting this.
These tests are
On Sat, Mar 31, 2012 at 12:07 PM, Lukas Gebauer gebyl...@mlp.cz wrote:
Hi all!
Sqlite version 3.7.11 on Windows cause error in my program. Some of my
pending statements are aborted by a nested savepoint transaction. See:
SAVEPOINT x1;
SELECT * FROM sometable; //just open statement and left
System.Data.SQLite version 1.0.80.0 (with SQLite 3.7.11) is now available on
the System.Data.SQLite website:
http://system.data.sqlite.org/
Further information about this release can be seen at
http://system.data.sqlite.org/index.html/doc/trunk/www/news.wiki
Please post on the
Hi
Can the date time functions in SQLite correctly interpret a date string
like '20120331'? Is there a format or modifier that will help the
function interpret/convert that as '2012-03-31'?
I don't see anything myself at the moment but thought I should ask
before working out other solutions
John li...@jspect.fastmail.fm wrote:
Can the date time functions in SQLite correctly interpret a date string
like '20120331'?
No. Recognized formats are documented here:
http://sqlite.org/lang_datefunc.html
Is there a format or modifier that will help the function interpret/convert
On 1 Apr 2012, at 3:05am, John li...@jspect.fastmail.fm wrote:
Can the date time functions in SQLite correctly interpret a date string like
'20120331'? Is there a format or modifier that will help the function
interpret/convert that as '2012-03-31'?
I don't see anything myself
25 matches
Mail list logo