ODBC problemer efter MSDE SP4
Jeg korer:PHP 5.1.4
Apache 2.0.55
MSDE SP4
Windows XP
Efter at have opdateret til MSDE SP4, har jeg faaet problemer med mit script.
Det virkede fint for jeg installerede MSDE SP4, men nu er der noget der ikke virker. Hvis jeg korer det samme query som jeg korer i PHP fra en query analyzer, for jeg korrekt resultat tilbage, men i min PHP er der intet resultat.
Nogen idéer?
SELECT * FROM IDWorksView WHERE (LastName LIKE 'ben%' OR FirstName LIKE 'ben%') AND TenantName = 'Tenant 1' ORDER BY FirstName
I en query analyzer giver det:
IndividualId TenantName GroupName FirstName LastName CardText TempStart TempStop APBtype IamGraced IamDisabled TempStartDate TempStartTime TempStopDate TempStopTime RecType IssueLevel ImagePath CustomTitle01 Custom01 CustomTitle02 Custom02 CustomTitle03 Custom03 CustomTitle04 Custom04 CustomTitle05 Custom05 CustomTitle06 Custom06 CustomTitle07 Custom07 CustomTitle08 Custom08 CustomTitle09 Custom09 CustomTitle10 Custom10 CustomTitle11 Custom11 CustomTitle12 Custom12 CustomTitle13 Custom13 CustomTitle14 Custom14 CustomTitle15 Custom15 CustomTitle16 Custom16
2 Tenant 1 24h Benji the Kid 000000000064007B 27/06/2006 0:00:00 01/01/1900 0:00:00 1 0 0 06/27/2006 00:00:00 01/01/1900 00:00:00 P 1 (NULL) Field 1 Field 2 Field 3 Field 4 Field 5 Field 6 Field 7 Field 8 Field 9 Field 10 Field 11 Field 12 Field 13 Field 14 Fecha Field 16
(1 row(s) affected)
I mit script, faar jeg ingenting.
Det her virker i midlertid fint begge steder...
SELECT * FROM IDWorksView WHERE TenantName = 'Tenant 1' ORDER BY TempStart DESC
