No luck with this approach either.
The thing is, the query actually was working this morning. I was getting all rows returned and then it all of a sudden started returning only 1 row.
I have no idea what would make this happen. I re-booted. Tried a different browser.
"Dean H. Saxe" <[EMAIL PROTECTED]> wrote:
"Dean H. Saxe" <[EMAIL PROTECTED]> wrote:
Totally WAG, but try "select id as my_id from...". The column name
may be the problem you're having. You'd then output #my_id# in theblock.
-dhs
Dean H. Saxe, CISSP, CEH
[EMAIL PROTECTED]
Here in America everything is bought and sold, you can get anything
for little bits of gold.
We'll rape the earth and ruin the air, cut down every tree from here
to there.
-- Donna The Buffalo "America"
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] 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
-------------------------------------------------------------
Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2ยข/min or less.
-------------------------------------------------------------
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
-------------------------------------------------------------
