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:
> >System.out.printf("%d,
owever, 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 anyt
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 SQL
>$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 WA
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 wr
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
http://www.linkedin.com/e/-62mihx-
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
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
INVOIC
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 ii.INVOICE_ID = INVOICE.INVOICE_ID
--
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) * ( @tax / 100) + .005, 2) fr
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 = (select round( sum(PRICE * QTY)
> 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
12 matches
Mail list logo