[ danield @ 18.04.2011. 17:54 ] @
Postovani,

Da li je ogranicen broj INNER JOIN-a? Imam sledeci SQL upit, koji nece da se izvrsi, da li neko ima resenje?
Code:
SELECT a.*, b.*, c.*, d.*, f.*, g.*, h.*, i.*, j.*, k.*, l.*, lj.*, m.*, n.*, nj.*, o.*, p.*, r.* FROM `loans`  AS a 
                                                        INNER JOIN `banks` AS b ON a.bankID = b.bankID
                                                        INNER JOIN `loanType` AS c ON a.loansType = c.idloanType
                                                        INNER JOIN `currency` AS d ON a.currency = d.idCurrency
                                                        INNER JOIN `loans_Repayment` as f ON a.loansID = f.loansID
                                                        INNER JOIN `loans_nominalInterestRate` as g ON a.loansID = g.loansID
                                                        INNER JOIN `loans_depositInterestRate` as h ON a.loansID = h.loansID
                                                        INNER JOIN `loans_methodOfCalculatingAnnuities` as i ON a.loansID = i.loansID
                                                        INNER JOIN `loans_creditRating` as j ON a.loansID = j.loansID
                                                        INNER JOIN `loans_annualFeeForAdministrationOfLoans` as k ON a.loansID = k.loansID
                                                        INNER JOIN `loans_SingleFeeForProcessing` as l ON a.loansID = l.loansID
                                                        INNER JOIN `loans_costOfAppraisalAndPersonalProperty` as lj ON a.loansID = lj.loansID
                                                        INNER JOIN `loans_insurancePremiumsOrOther` as m ON a.loansID = m.loansID
                                                        INNER JOIN `loans_costsOfRegistrationInTheRegister` as n ON a.loansID = n.loansID
                                                        INNER JOIN `loans_costsOfAcquiringOfLandRegistry` as nj ON a.loansID = nj.loansID
                                                        INNER JOIN `loans_costOfObtainingCertificatesAndOther` as o ON a.loansID = o.loansID
                                                        INNER JOIN `loans_costOfCreditBureau` as p ON a.loansID = p.loansID
                                                        INNER JOIN `loans_otherExpenses` as r ON a.loansID = r.loansID
                                                        WHERE b.visible=1 AND
                                                        d.markCurrency = 'EUR' AND
                                                        a.bankID IN(1,2,3,4,5,6,7,8,9,10)
                                                        ORDER BY b.bankName ASC

Kao rezultat dobijem gresku:
Code:
(Object)#0
  message = "faultCode:INVALID_AMF_MESSAGE faultString:'Invalid AMF message' faultDetail:''"
  name = "Error"
  rootCause = (null)



Unapred hvala,

Daniel Dulic
[ mish_ns @ 18.04.2011. 18:20 ] @
Cini mi se da ti je greska vezana za sintaksu tj. za navodnike. Ali ne vidim da si nesto pogresio.
Jel to koristis amfphp?
daj kod pa da vidimo...
Pozdrav!

[ agvozden @ 18.04.2011. 20:07 ] @
sta dobijas kada pokrenes ovaj upit u mysql konzoli?
[ bogdan.kecman @ 18.04.2011. 21:49 ] @
rekoh ti jos u mail-u

pusti taj upit iz konzoile (ili phpmyadmina ili sta vec imas) samo dodaj pre SELECT jedan EXPLAIN i daj rezultat
[ Shadowed @ 18.04.2011. 22:44 ] @
Citat:
mish_ns: Cini mi se da ti je greska vezana za sintaksu tj. za navodnike.

Hm, nemam pojma ima li to veze u MySQL-u, ali ovde su mu navodnici tj. apostrofi oni naopaki (sto je gore levo na tastaturi, ne oni kod enter-a).
[ bogdan.kecman @ 19.04.2011. 07:08 ] @
imena tabela i kolona se zatvaraju u te "naopake navodnike" (backticks == ` ) a stringovi u normalne (ticks == ' )

ali bez EXPLAIN rezultata tesko da cemo da "nabodemo" sta je greska, posebno sto se ovde greska parsira kroz neki php framework (koji i generise ovaj odvratni upit)