SELECT count(*) as counter from test... then output the value of
counter. If its 1, you have 1 row and you're looking at the wrong DB.
Dean H. Saxe, CISSP, CEH
[EMAIL PROTECTED]
"What difference does it make to the dead, the orphans, and the
homeless, whether the mad destruction is wrought under the name of
totalitarianism or the holy name of liberty and democracy? "
--Gandhi
On Oct 3, 2006, at 12:57 PM, Jeff Howard wrote:
I tried something like that. Didn't work. Thanks though.
Dan Kaufman <[EMAIL PROTECTED]> wrote:
How about adding a WHERE clause which is always true for all
records, such as:
WHERE 1 = 1
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff
Howard
Sent: Tuesday, October 03, 2006 9:32 AM
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
-------------------------------------------------------------
All-new Yahoo! Mail - Fire up a more powerful email and get things
done faster.
-------------------------------------------------------------
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
-------------------------------------------------------------