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