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.
/charlie
http://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 cfquery
Charlie,
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
-------------------------------------------------------------