Ok, I saw it return all records the first couple of times I looked at it when I was trying to figure it out. Then it started returning one record while I was toying with it trying to figure out what was what.
As far as what account is being used, all I see is a "LoginName" on the screen that I'm looking at and it is 'sysmod' which is the DB name. Any more detail you could provide me with here would help since this is my first time using Profiler.
Thanks, once again.
jeff
Charlie Arehart <[EMAIL PROTECTED]> wrote:
Charlie Arehart <[EMAIL PROTECTED]> wrote:
Great. Thanks for sharing. Just didn't know if the earlier message was missed.OK, so if it is really querying the database, how many records do you see it returning? 1 or 10? Are you back to this circumstance where the problem is happening again? And recall I had also asked a question about security. Now, since you said this is coming and going, I'm less inclined to think it's about security. The credentials used in the DSN or in your login to enterprise manager (and records authorized to that account) shouldn't be changing much, but it seems worth at least double-checking.Again, rather than wait until you have access to the Admin, this is something that SQL Profiler should be able to tell you (what account is being used to access records). Hope all that gets you further down the field./charliehttp://www.carehart.org/blog/
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Howard
Sent: Tuesday, October 03, 2006 4:40 PM
To: discussion@acfug.org
Subject: RE: [ACFUG Discuss] Issue with return from cfqueryCharlie,I appreciate the help.I have not used SQL Profiler before. I have been looking at it and can see it "really is querying the database". Once again, I've never used SQL Profiler but I'm pretty positive that I've figured this part out.As far as the CF debugging tool, we had a problem with the email server and my login was in an email that was deleted off the server and I can't get to the CF Admin right now. As soon as I get the login I can take that step.I was hoping that maybe somebody has had this issue and had a fix/advice on how to correct/remedy the problem.Once again, thanks.Jeff
-------------------------------------------------------------
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by FusionLink
-------------------------------------------------------------
Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2ยข/min or less.
-------------------------------------------------------------
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by FusionLink
-------------------------------------------------------------
