Hello!
I'm trying to write some kind of small accounting software and I got
stuck with the problem that doing a SUM() on values of a DECIMAL(7,2)
row did show problems with (relatively) small values (like 173.58). I
found a message explaining that mysql uses doubles internly to compute
the values
"Louie Miranda" <[EMAIL PROTECTED]> wrote:
> Hi, i have this form that goes directly.. to a database. I have some
> clients who dont use english. If they enter on a form a special
> russion or chinese character will mysql translate it properly?
If you use a Web form, you should try to transform t
Hello Mumba, Hello Barry,
> > How do I select out and filter only rows that match
> > both 16 and 62 in the KEYW_ID col? IE. The query
> > would return only 119 and 108?
>
> I'm sure this could be done more effeciently other ways, possibly with
> a sub select if available, but something like t
Hello,
> mysql> select *from accounting where uid = (select uid
> from user wher gid="apswan");
> ERROR 1064: You have an error in your SQL syntax near
> 'select uid from user wher gid="apswan")' at line 1
> mysql>
Take care, you wrote "wher" instead of "where".
And as Leonardo pointed out, th