Hi,
Ok, if you would, here is my dilemma:
I have 37 questions. I have 2000 people answering these questions on base.
What I want to do is COUNT all the 1's in question 1, all the 1's in
question 2.....etc to 37.
I have to do this for 5 different numbers (1 thru 5): for example:
COUNT all the 2's in question 1, COUNT all the 2's in question 2 .....etc to
37
Any suggestions????!!!!?????? Any help would be GREATLY appreciated!!!!
>Jim Charles
>Dyntel Corp.
>Code 06 Computer Support - Building 1
>Naval Surface Warfare Center
>(812) 854-3207
>[EMAIL PROTECTED]
-----Original Message-----
From: Chris Evans [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 04, 2000 9:30 AM
To: [EMAIL PROTECTED]
Subject: RE: CFLOOP Error???????
You can't have multiple selects within a single CFQUERY. It
is hard to tell
from that small snippet of code what you are trying to do,
but I'm guessing
there may be a more efficient way to get the data you need
without having to
run 37 queries.
Chris Evans
[EMAIL PROTECTED]
http://www.fuseware.com
-----Original Message-----
From: Charles James S CONT CNIN
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 04, 2000 7:23 AM
To: '[EMAIL PROTECTED]'
Subject: CFLOOP Error???????
Can you please tell me WHY this CFLOOP is not working??? The
code I am using
is at the bottom, and right below is the error message!
Thanks!!!!
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC Microsoft Access Driver] Syntax error. in
query expression
'q1=1 SELECT Count (q2) AS cnnt2 FROM sres where nme =
'Nancy Maegerlein''.
Data Source = "localFeedback"
SQL = "SELECT Count (q1) AS cnnt1 FROM sres where nme =
'Nancy Maegerlein'
HAVING q1=1 SELECT Count (q2) AS cnnt2 FROM sres where nme =
'Nancy
Maegerlein' HAVING q2=1 SELECT Count (q3) AS cnnt3 FROM sres
where nme =
'Nancy Maegerlein' HAVING q3=1 SELECT Count (q4) AS cnnt4
FROM sres where
nme = 'Nancy Maegerlein' HAVING q4=1
<CFQUERY Name = "GetquesCount" DATASOURCE="localFeedback">
<CFLOOP index="cnt" from="1" to="37" step="1">
SELECT Count (q#cnt#) AS cnnt#cnt#
FROM sres where nme = '#assnme#'
HAVING q#cnt#=1
</CFLOOP>
</CFQUERY>
>Jim Charles
>Dyntel Corp.
>Code 06 Computer Support - Building 1
>Naval Surface Warfare Center
>(812) 854-3207
>[EMAIL PROTECTED]
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with
'unsubscribe' in
the body.
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
