08. juni 2006 - 21:12Der er
4 kommentarer og 1 løsning
Hvorfor aeder PHP ikke den her?
SELECT Tenants.TenantName, Individuals.FirstName, Individuals.LastName, EventTypes.EventText FROM Events JOIN Individuals ON Events.Tenantndx = Individuals.Tenantndx AND Events.Indivndx = Individuals.IndivId JOIN Tenants ON Events.TenantNdx = Tenants.TenantId JOIN EventTypes ON Events.EventTypeNdx = EventTypes.EventTypeId WHERE Events.Eventid IN ( SELECT MAX(Events.EventId) AS EventId FROM Events WHERE Events.EventTypeNdx IN (14,15,16,43,44,45,51,52,53,54) GROUP BY Events.TenantNdx, Events.IndivNdx ) AND Events.Eventid NOT IN ( SELECT MAX(Events.EventId) AS EventId FROM Events WHERE Events.EventTypeNdx IN (14,15,16,43,44,45,51,52,53,54) AND Events.PointAddr IN (8341,8853,9365,9877) GROUP BY Events.TenantNdx, Events.IndivNdx ) AND Events.Eventid NOT IN ( SELECT MAX(Events.EventId) AS EventId FROM Events WHERE Events.EventTypeNdx IN (16,44,52,54) AND Events.PointAddr IN (10373,10885) GROUP BY Events.TenantNdx, Events.IndivNdx ) ORDER BY FirstName
Skal virksomheder stå stærkere mod angreb og kunne udvikle sig, skal sikkerhed, drift og forretning tænkes sammen. Det er tanken bag Jysk IT’s ambition om at skabe en “sikker fremtid” for kunderne.
det har det med PHP at gøre at jeg connecter til MSDE via ODBC...
Hvis jeg skriver PRÆCIS dette i et query, virker det fint... Hvis jeg smider det i PHP virker det ikke. Fjerner jeg:
AND Events.Eventid NOT IN ( SELECT MAX(Events.EventId) AS EventId FROM Events WHERE Events.EventTypeNdx IN (16,44,52,54) AND Events.PointAddr IN (10373,10885) GROUP BY Events.TenantNdx, Events.IndivNdx )
$sql = "SELECT Tenants.TenantName, Individuals.FirstName, Individuals.LastName, EventTypes.EventText FROM Events JOIN Individuals ON Events.Tenantndx = Individuals.Tenantndx AND Events.Indivndx = Individuals.IndivId JOIN Tenants ON Events.TenantNdx = Tenants.TenantId JOIN EventTypes ON Events.EventTypeNdx = EventTypes.EventTypeId WHERE Events.Eventid IN ( SELECT MAX(Events.EventId) AS EventId FROM Events WHERE Events.EventTypeNdx IN (14,15,16,43,44,45,51,52,53,54) GROUP BY Events.TenantNdx, Events.IndivNdx ) AND Events.Eventid NOT IN ( SELECT MAX(Events.EventId) AS EventId FROM Events WHERE (Events.EventTypeNdx IN (14,15,16,43,44,45,51,52,53,54) AND Events.PointAddr IN (".$doorsOut.")) OR (Events.EventTypeNdx IN (16,44,52,54) AND Events.PointAddr IN (".$doorsInOut.")) GROUP BY Events.TenantNdx, Events.IndivNdx ) ORDER BY FirstName";
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.