On 13 Dec 2009, at 5:27am, FrankLane wrote:
> $data3 = preg_split('/\t/',$data2[$i]); // tab delimited record data into
> array
>
> $sqlcmd = 'INSERT INTO tab (i0) VALUES ('.$data3[0].')';
Good so far. Now you should know that a normal SQL command to insert a record
would look something li
Well, Im getting closer. I can't seem to get the query function right.
Running the following program gives:
The first record is 1 0 0 0 0 BUSI @TOWB.1@ Ernest Blacksmith Shop
INSERT INTO tab (i0) VALUES (1)
INSERT INTO tab (i0) VALUES (1)
INSERT INTO tab (i0) VALUES (1)
INSERT INTO tab (i0) VALUE
>I believe there is a bug here.
Yes, in I my own head!
We simply need to take care of integral values.
The correct rounding down at 3rd decimal places using SQLite can
be done so:
case
when cast(myValue as text) <> round(myValue) then
round(myValue - 0.0005, 3)
else
My "procedural language" is C#, so that is a can-do situation. But I would
like to get a lot more out of set-based SQLite if possible.
On Fri, Dec 11, 2009 at 11:55 PM, Igor Tandetnik wrote:
> Sqlite Fool wrote:
> > In a previous life, I was able to get the stuff into a MS SQL Server
> > adjancen
[ I apologize if this appears twice on the list ]
Hi,
At 00:11 13/12/2009, you wrote:
>Sir any ida how can value rounddown floor have done
>
>if not possible i have make small code
>i requard make function please say how can add
>
>i send you my rounddown funtion
>
>please
>Cose Exmaple :
>va
Hi,
At 00:11 13/12/2009, you wrote:
>Sir any ida how can value rounddown floor have done
>
>if not possible i have make small code
>i requard make function please say how can add
>
>i send you my rounddown funtion
>
>please
>Cose Exmaple :
>value=10.666
>decimal=1
>Create roundd{value,decimal){
>
Apologies for not answering earlier, I* was away.
I've never used Process Monitor - the whole setup you describing is new to me -
but I will try to do something about it in the coming week. It has to be a
background project for me - I do not use SQLite in production.
-Original Message--
D. Richard Hipp wrote:
> On Dec 8, 2009, at 9:51 AM, Andreas Schwab wrote:
>
>> "D. Richard Hipp" writes:
>>
>>> On Dec 7, 2009, at 8:41 PM, Andreas Schwab wrote:
>>>
D. Richard Hipp writes:
> As always, please let us know if you encounter any difficulties
> with
> this or
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Alexey Pechnikov wrote:
> This is standart for all i18n applications.
The SQLite shell is not an i18n application, and this is deliberate. It is
a developer tool. That is why for example it always uses a dot for a
decimal point and not a comma even
Hello!
On Saturday 12 December 2009 23:39:23 Roger Binns wrote:
> > setlocale(LC_ALL, "");
>
> Why? Yes I know what the call does, but what desirable effect does it have
> on shell input and output? Pretty much all formatted output is done using
> %s. The only float output is for timing comman
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Alexey Pechnikov wrote:
> On unix the shell must do this initialisation:
>
> setlocale(LC_ALL, "");
Why? Yes I know what the call does, but what desirable effect does it have
on shell input and output? Pretty much all formatted output is done using
Hello!
The SQLite History extension
Link: http://mobigroup.ru/files/sqlite-ext/history/
The History SQLite extension may be used for table history logging. This
version can store the user and host information obtained from environment
variables or application-defined functions.
See details he
Hello!
sqlite3-rdiff - compute and apply signature-based row differences for SQLite3
databases
Link: http://mobigroup.ru/files/sqlite-ext/sqlite3-rdiff
Depends: tcl 8.5, sqlite3, murmurhash SQLite extension
Are used the ROWID value as unique key of row and murmurhash for build
signatures for
Hello!
On unix the shell must do this initialisation:
setlocale(LC_ALL, "");
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On 12 Dec 2009, at 5:36pm, FrankLane wrote:
> I have a tab-delimited file that contains all my data, and I would like to
> write a php program which displays on a web page the results of various
> sqlite operations on a table created from that data. I still do not
> understand how to load the fil
Hello Simon - Thank you for your response. I think its clear that I am just
learning php, and I appreciate your help on very basic problems I am having.
I have a tab-delimited file that contains all my data, and I would like to
write a php program which displays on a web page the results of variou
> > hi SQLite Users please i requard floor for make rounddown
> > please help me for how can rounddown
>
>cast(myNumericColumn as integer)
>round(myNumericColumn - 0.5)
SQLite round() with one argument seems to behave just like, say C,
floor() under a different name, but cast(myNumericColumn as
Virendra Agarwal wrote:
> hi SQLite Users please i requard floor for make rounddown
> please help me for how can rounddown
cast(myNumericColumn as integer)
round(myNumericColumn - 0.5)
Igor Tandetnik
___
sqlite-users mailing list
sqlite-users@sqlite.or
hi SQLite Users please i requard floor for make rounddown
please help me for how can rounddown with out this my all reports query are
west please help how can do ?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mail
On 12 Dec 2009, at 5:09am, FrankLane wrote:
Thank you for pasting your code fragment. It makes it easier to help you.
If you have your code check the results of '->errorCode' (and depending on that
'->errorInfo') you will get information about whether each command executed
correctly and what
20 matches
Mail list logo