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