 |
||
|
Click the "View Animal" to see more details. dbConnection.execCommand(): Error executing supplied SQL. SELECT B1.breed,A.Sex,A.AnimalID,A.name,G.gender,CO.colour From tblAnimal A LEFT OUTER JOIN lookupGender G on A.sex = G.id LEFT OUTER JOIN lookupBreeds B1 on A.breed = B1.ID INNER JOIN lookupAnimalColours CO ON A.colour = CO.id INNER JOIN tblPerson P ON A.personID = P.personID INNER JOIN tblAddress AD ON P.personID = AD.personID AND AD.addressType='R' WHERE dbo.getPublicStatus(A.statusID) = 7) And A.councilID IN (191,138,136) AND dbo.getPublicStatus(A.statusID) NOT IN (SELECT statusID from tblBreedExclude WHERE breedID = A.breed OR breedID = A.breed2) AND A.active>0 AND A.verified>0 order by A.Breed desc, A.animalID Error in DB connection |