Bob 3015$
0
10022 Mark0
1030$
10023 Fred7500$
0
..
this is my query:
SELECT urun.`StokKodu`,
urun.`Isim`,
(SUM((depo.EvrakYonu)*depo.Miktar)-SUM((1-depo.EvrakYonu)*depo.Miktar)) AS
`Mevcut Miktar`
FROM rootdata.urun AS urun,
seconddata.depohareket AS depo
WHERE urun.`ID` = depo.`UrunID`
AND depo.`Iptal` = 0
AND urun.`HizmetUrunu` = 0
GROUP
un.`ID`
---
Th error says : Invalid use of group function.
Can you help me??
-Original Message-
From: Uttam [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 20, 2003 4:06 PM
To: 'Aziz DURMAZ'; [EMAIL PROTECTED]
Subject: RE: A query problem...
>
How we can import a zip file into the blob field ?
I can import zip file into mysql but when i export it. The zip files doesnt
works. And its size becames smaller.
Is there anybody can help me???
-
Before posting, please ch
--
---
-Original Message-
From: Tim Endres [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 13, 2002 6:19 PM
To: Aziz Durmaz; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Problem in BLOB Field with zips
What size are the ZIP files? The default BLOB
