RE: A query problem...

2003-03-22 Thread Aziz DURMAZ
` --- 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... But i dont want

A query problem...

2003-03-20 Thread Aziz DURMAZ
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

a problem with sum()

2003-01-01 Thread Aziz Durmaz
Mark0 1030$ 10023 Fred7500$ 0 .. I must send only one query ! Is there any body can help me??? Aziz Durmaz

Problem in BLOB Field with zips

2002-08-13 Thread Aziz Durmaz
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

RE: Problem in BLOB Field with zips

2002-08-13 Thread Aziz Durmaz
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 field has a size limit of 64KB. If your ZIP files are larger, they are being clipped. Use MEDIUMBLOB or whatever is most appropriate