<cfoutput query="getIDs">
#getIDs.recordcount# --# ID#< br>
</cfoutput>
Teddy
On 10/3/06, Jeff Howard <[EMAIL PROTECTED]> wrote:
No offense taken, I thought I explained it fairly clearly. In any case, maybe this will help clarify the issue.
Teddy Payne <[EMAIL PROTECTED]> wrote:
Jeff,
Saying that "it worked this morning" is not really the information needed to troubleshoot a problem remotely. Plase take no offense by that statement if it sounded harsh.
From this thread, I have seen about three people ask if you have opened up the database and the values in the table you are querying has more than 1 value?
Yes, by working I meant that it accessed the table and returned all the rows I requested. Thus, all connections were correct and functioning this morning.
Then all of sudden it started returning just 1 record instead of the multiple records it was returning a half-hour earlier. No change to the .cfm file, just a change in the output.
When this app quit working I created a new table called "Test" with one column called "ID" and 10 rows with a value of "1-10" for ID.
<CFQUERY name="getIDs" datasource="sysmods" >
SELECT ID
FROM test
</CFQUERY>
<cfoutput query="getIDs">
#getIDs.recordcount# --# ID#< br>
</cfoutput>
I had the same issue with this table that I created just to test if there was something I was missing in my other app. I broke it down to 1 extremely simple table with 1 extremely simple query and still only got the 1st record.
This "test app" all of a sudden started functioning properly as well when I hit refresh on the browser after lunch.
So my issue now is, what are possible causes of this behavior?
The reason also that it sounds incredulous to most of us is that CF really makes it easy to query a database if you have the correct database connection set up in your CF Administrator.
We are just looking for more information to assist you,
Teddy
On 10/3/06, Jeff Howard <[EMAIL PROTECTED]> wrote: Yes, absolutely positive. I am getting a return, just 1 row instead of 10 and it was working this morning.
"Dean H. Saxe" < [EMAIL PROTECTED]> wrote: And are you sure Sysmods is the correct DB? Are you connecting to
the same DB with enterprise manager?
-dhs
Dean H. Saxe, CISSP, CEH
[EMAIL PROTECTED]
"Great spirits have often encountered violent opposition from weak
minds."
--Einstein
On Oct 3, 2006, at 12:53 PM, Jeff Howard wrote:
> Thanks, but still only getting one record returned and a
> recordcount of 1.
>
> [EMAIL PROTECTED] wrote:
> Maybe try this:
> SELECT [id] from test
> -----Original Message-----
> 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:
>
>
> SELECT ID
> FROM test
>
>
> 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
> -------------------------------------------------------------
>
> Stay in the know. Pulse on the new Yahoo.com . Check it out.
> -------------------------------------------------------------
> 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 http://www.fusionlink.com
-------------------------------------------------------------
---------------------------------
Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great rates starting at 1¢/min.
-------------------------------------------------------------
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
-------------------------------------------------------------
--
<cf_payne />
Blog: http://cfpayne.wordpress.com/
Atlanta CFUG: http://www.acfug.org n¶ëN‹§²æìr¸›yúèšØb²X¬¶f§j²¢ê鮇â•æëj
-------------------------------------------------------------
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 http://www.fusionlink.com
-------------------------------------------------------------
--
<cf_payne />
Blog: http://cfpayne.wordpress.com/
Atlanta CFUG: http://www.acfug.org
