Hi Kay,

from memory - the rule execute method populates an array (aInvocations).

If you are doing soething real fancy, look at the calendar rule.
A news rule spats one object at at time. Whereas the calendar rule stores up all the objects and does one splat at the end.

On 2/21/06, Kay Smoljak <[EMAIL PROTECTED]> wrote:

Hi Chris,

On 2/20/06, Chris Bauer <[EMAIL PROTECTED]> wrote:
> Have you dumped the query?

I've tested some more and can refine the problem a little more now. In
the execute method, if I dump the query straight after it executes,
the column is present. However, in the webskin/display method
template, the #stObj# structure which holds the data does not contain
the column.

As I've simply copied the news rule and modified what I need to
without fully understanding what's going on, I think that's where the
error stems from. I've realised that (I think, anyway) the query I've
modded is just to find the relevant ObjectIDs, and that the query to
actually pull the data out of the table for each objectid is
elsewhere. Would that be correct? Any idea where? I'm digging more
now, but the debug output on a FarCry app is *terrifying*.

> Also, if the sysadmin really has put your user in the db_owner role, you
> should be able to change ownership of objects in the database. In EM,
> right-click -> Design View on a table. Then in Properties, you can select a
> new owner (either an actual user in the database, a security group, or the
> built-in literal dbo). It can be slow, but saves time waiting for someone
> else (or searching for the right syntax to do it in QA). ;)

The problem is a little more complex - EM states that the user *is* in
the dbowner role, yet when trying to select it's not behaving as
though it is, which some people have said is a symptom of a mucked-up
backup restore. I'm waiting for the sysadmin to do the re-owning as I
don't have the SA password, hopefully he'll get around to doing that
today.

Thanks for your help, and I love your sample query columns :)




--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to