Autor | Zpráva | ||
---|---|---|---|
Enko Profil |
#1 · Zasláno: 25. 4. 2014, 14:13:00
Ahoj,
mám v Dibi zápisu toto: $result = dibi::test(" SELECT Hardware.Name AS Name, Hardware.Serial_Num AS Serial_Num, Hardware.Product AS Product, Assets.Warranty_Exp AS Warranty_Exp FROM Hardware LEFT JOIN Assets ON Hardware.Owner_ID=Assets.Owner_ID AND Hardware.Serial_Num=Assets.Serial_Num WHERE Hardware.Serial_Num LIKE %~like~", $sn, "; SELECT Computers.Name AS Name, Computers.Serial_Num AS Serial_Num, Computers.Model AS Product, Assets.Warranty_Exp AS Warranty_Exp FROM Computers LEFT JOIN Assets ON Computers.Owner_ID=Computers.Owner_ID AND Assets.Asset_Tag=Computers.Serial_Num WHERE Computers.Serial_Num LIKE %~like~", $sn, "; "); A na stránku mi to vytiskne toto: SELECT Hardware.Name AS Name,Hardware.Serial_Num AS Serial_Num,Hardware.Product AS Product,Assets.Warranty_Exp AS Warranty_Exp FROM Hardware LEFT JOIN Assets ON Hardware.Owner_ID=Assets.Owner_ID AND Hardware.Serial_Num=Assets.Serial_Num WHERE Hardware.Serial_Num LIKE '%34d3%' ;SELECT Computers.Name AS Name,Computers.Serial_Num AS Serial_Num, Computers.Model AS Product,Assets.Warranty_Exp AS Warranty_Exp FROM Computers LEFT JOIN Assets ON Computers.Owner_ID=Computers.Owner_ID AND Assets.Asset_Tag=Computers.Serial_Num WHERE Computers.Serial_Num LIKE '%34d3%' ; |
||
Časová prodleva: 3 dny
|
|||
Jan Tvrdík Profil |
#2 · Zasláno: 28. 4. 2014, 23:39:50
Enko:
Vícenásobný select pokud vím dibi neumí. Nehledáš náhodou UNION ALL ?
|
||
Enko Profil |
#3 · Zasláno: 30. 4. 2014, 01:18:46
Jan Tvrdík:
Ano, už jsem to taky dohledal a vypadá to, že neumí. Funguje to vždy jen s jedním SELECTem. Tak jsem to nakonec přepsal do dvou samostatných a funguje, tak jak potřebuji. Přesto děkuji |
||
Časová prodleva: 10 let
|
0