Hello, I have made a construction with EOQualifier here is my QualifierString: (languagesavedtemplate.language=%@) and ((name caseInsensitiveLike %@) OR (languagesavedtemplate.savedtemplatedescription caseInsensitiveLike %@)) AND (usersavedtemplate.user=%@) AND (usersavedtemplate.user.usernode.node=savedtemplatenode.node) <------------- and this is the SQL-statment that is generated: "SELECT t0."approvaluser_id", t0."ctime", t0."mtime", t0."name", t0."ordercomment", t0."orderref", t0."previewfile", t0."savedtemplate_id", t0."status", t0."template_id", t0."thumb", t0."user_id" FROM "savedtemplate" t0, "language_savedtemplate" T2, "user_savedtemplate" T1 WHERE ((1=1) <----------------- AND T1."user_id" = 1000000 AND (t0."name" LIKE '%test%' COLLATE INFORMATION_SCHEMA.CASE_INSENSITIVE OR T2."savedtemplatedescription" LIKE '%test%' COLLATE INFORMATION_SCHEMA.CASE_INSENSITIVE) AND T2."language_id" = 1000000) AND t0."savedtemplate_id" = T2."savetemplate_id" AND t0."savedtemplate_id" = T1."savedtemplate_id" ORDER BY t0."name" COLLATE INFORMATION_SCHEMA.CASE_INSENSITIVE ASC" Why is this not working and is: (usersavedtemplate.user.usernode.node=savedtemplatenode.node) generating: (1=1) Is it possible to work with relations that way? Thanks, Met vriendelijke groeten - Kind Regards Frank Stock Net & Storage Solutions nv Tieltstraat 167 8740 Pittem Belgium T ++32 51 424 010 F ++32 51 402 922 |
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to archive@mail-archive.com
