Re: [ACFUG Discuss] Issue with return from cfquery

[Jeff Howard]

I've tried both ways and they both produce the same result.

Precia <[EMAIL PROTECTED]> wrote:

ARe you placing your output as such....

 

<cfoutput query="getIDs">

  #ID#

</cfoutput>

 

or

 

<cfoutput>

  #getIDs.ID#

</cfoutput>

 

or some other way?

 

The first example will return all rows.  The second example will return one row.

 

Precia

 

On 10/3/06, Jeff Howard <[EMAIL PROTECTED]> wrote:

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

---

Do you Yahoo!?
Get on board. You're invited to try the 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
-------------------------------------------------------------