Re: [sqlite] Statement is not executing

2011/7/3 Simon Slavin > > On 3 Jul 2011, at 12:19am, Cecil Westerhof wrote: > > > I am not sure if it is a SQLite problem, or a Java problem. > > > > While filling a table I get an error "Statement is not executing". It > > happens in the following code: > >

[sqlite] Help needed for SQLite PHP

However, no matter how I tried, it give me "HTTP 500 internal server error", I checked the Nanoweb error log, found below message: 20110703:054052 WARN: function 'pcntl_fork' not available 20110703:054052 WARN: function 'posix_setuid' not available   Do I missed anything?   Your help is

Re: [sqlite] Help needed for SQLite PHP

On 3 Jul 2011, at 2:47pm, James_21th wrote: > 20110703:054052 WARN: function 'pcntl_fork' not available > 20110703:054052 WARN: function 'posix_setuid' not available These functions aren't available under Windows. I'm guessing from the context that the SQLite API you're using depends o

Re: [sqlite] Help needed for SQLite PHP

imple: > >$db = new SQLiteDatabase('test.db');  >echo "SQLite successfully opened"; >?> > >However, no matter how I tried, it give me "HTTP 500 internal server error", >I checked the Nanoweb error log, found below message: > >20110703:054052 WARN: func

[sqlite] Java and accented characters

Hello, I'm having problem with accented characters when getting text data from sqlite3 with Java (sqlite jdbc). When i query in command line, the result came correct with accentuation. For example: *sqlite> select nom_pais from pais ; Itália Rússia * But, when I query from java app, it's work

[sqlite] Invitation to connect on LinkedIn

LinkedIn Gaurav Srivastava requested to add you as a connection on LinkedIn: -- Zarko, I'd like to add you to my professional network on LinkedIn. - Gaurav Accept invitation from Gaurav Srivastava

[sqlite] optimizing an update

I have a select statement that is calculating the subTotal, Tax, and grand total: UPDATE Invoice SET Sub_Total = (select sum(PRICE * QTY) from INVOICE_ITEM where INVOICE_ID = @invoiceId), Tax = (select round( sum(PRICE * QTY) * ( @tax / 100) + .005, 2) from INVOICE_ITEM where INVOICE_ID

[sqlite] Compound update isn't working as I expect

It is very clear to me that my expectations are wrong, please enlighten me... Here is the query: update INVOICE set SUB_TOTAL = (select sum(PRICE * QTY) from INVOICE_ITEM ii where ii.INVOICE_ID = *INVOICE_ID*), TAX = (select round( sum(PRICE * QTY) * ( 8.25 / 100) + .005, 2) from

Re: [sqlite] Compound update isn't working as I expect

Sam Carleton wrote: > It is very clear to me that my expectations are wrong, please enlighten > me... > > Here is the query: > > update INVOICE > set SUB_TOTAL = (select sum(PRICE * QTY) from INVOICE_ITEM ii where > ii.INVOICE_ID = *INVOICE_ID*), where

Re: [sqlite] optimizing an update

Sam Carleton wrote: > I have a select statement that is calculating the subTotal, Tax, and grand > total: > > UPDATE Invoice > SET Sub_Total = (select sum(PRICE * QTY) from INVOICE_ITEM where > INVOICE_ID = @invoiceId), > Tax = (select round( sum(PRICE * QTY)

Re: [sqlite] Compound update isn't working as I expect

Sam Carleton wrote: > It is very clear to me that my expectations are wrong, please enlighten > me... > > Here is the query: > > update INVOICE >set SUB_TOTAL = (select sum(PRICE * QTY) from INVOICE_ITEM ii where > ii.INVOICE_ID = *INVOICE_ID*), >TAX =

Re: [sqlite] Java and accented characters

> Any idea? Please, anyone can help me? How did you put your data into database? I guess you did that with command line utility. And as your console wasn't set to have UTF-8 charset then contents of pais now is not in UTF-8. But jdbc driver tries to treat it as UTF-8 and so you don't see what you