| 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: 12 let
|
|||
0