I have the following query in a custom rule which returns records as
expected in Query Analyzer:
SELECT csg_farcry.pwPosition.*, csg_farcry.pwEmployer.Company
FROM csg_farcry.pwPosition INNER JOIN
csg_farcry.pwEmployer ON
csg_farcry.pwPosition.Employer = csg_farcry.pwEmployer.ObjectID
WHERE (csg_farcry.pwPosition.status IN ('approved'))
ORDER BY csg_farcry.pwPosition.label
However, when the rule runs in code, the "company" column is not
passed (everything out of the pwPosition table is there). I copied the
news rule originally and just replaced the object names as necessary.
Is there any FarCry reason why the join wouldn't work? It's odd
because outside of FarCry, the joined field is returned. But the same
SQL code copied and pasted into my rule doesn't work. I've commented
out all other code in the execute method so I'm positive that this is
where the problem is.
I'm just not having a good day with databases! The client's sysadmin
has yet to get back to me with the results of the re-owning exericise,
for any CFTalkers or CFAussie peeps who are following the daily soap
opera that is my development life :D
--
Kay Smoljak
http://kay.zombiecoder.com/
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"farcry-dev" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/farcry-dev
-~----------~----~----~----~------~----~------~--~---
