RE: [ACFUG Discuss] Issue with return from cfquery

[Jeff Howard]

Ok, the new issue is it all of a sudden started working again.  I didn't change any settings anywhere or even change my script.  All I did was eat a sandwich and hit refresh on the page and it started working.

 

This is obviously not a good situation once the project I'm working on is live.

 

Any new ideas on why it would all of a sudden start only returning 1 record instead of multiple records and then fix itself to start returning all records?

 

I am the only one here today working on this server or with these scripts.

 

Ideas?

Charlie Arehart <[EMAIL PROTECTED]> wrote:

Besides the other helpful suggestions so far, do you have debugging turned on, to see how many records are being returned in the resultset?

 

More important, If the issue is really that it's just returning 1 record, then the question could be one of security and authorization, in SQL I mean. I'm pretty sure it's possible to restrict people to see only the records they're authorized to see. When you login to Enterprise Manager, do you log in with the same account as is being used in the setup of this datasource in the CF Admin console?

 

If you have no control over the DSN setup, since you do have access to Enterprise Manager, turn on the SQL Profiler to see what authentication is being used when the request comes into SQL Server from CF. And do the same to watch the Query Analyzer request you make. It may tell you where and why things are different.

 

/charlie

http://www.carehart.org/blog/

 

---

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Howard
Sent: Tuesday, October 03, 2006 12:32 PM
To: discussion@acfug.org
Subject: [ACFUG Discuss] Issue with return from cfquery

Does anyone know what could be causing the following issue:

 

 

I have a very simple query:

 

<CFQUERY name="getIDs" datasource="sysmods" >
   SELECT ID
   FROM test
</CFQUERY>

 

The DB has 1 column named ID and 10 rows numbered 1-10.  I built this table to try and figure out what is happening to a more complex table that is having the same issue.

 

When I run this in a browser it is only returning the first record.  When I copy and paste the query into Enterprise Manager and Query Analyzer and it returns all 10 rows.

 

The script I was running when this problem first surface ran fine several times this morning and all of a sudden it quit working.  It was returning all records from the table and then I ran it again and this problem popped up.  I couldn't figure out what was happening so I built a little test table and test script and I'm getting the same problems.  This makes me believe it is a CF problem and not a SQL Server problem.

 

Any ideas?

 

From what I've gathered since joining a few months ago, someone always knows the answer in this group.

 

Thanks,

Jeff Howard

---

Do you Yahoo!?
Everyone is raving about the all-new Yahoo! Mail.
-------------------------------------------------------------
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
-------------------------------------------------------------
-------------------------------------------------------------
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
-------------------------------------------------------------

---

Get your own web address for just $1.99/1st yr. We'll help. Yahoo! Small Business.
-------------------------------------------------------------
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
-------------------------------------------------------------