<cfset temp="0">
<cfloop from="1" to="37" index="conteur">
<cfif value is "1"><cfset temp = #temp# + 1>
</cfif>
</cfloop>
> -----Message d'origine-----
> De: Charles James S CONT CNIN [SMTP:[EMAIL PROTECTED]]
> Date: 4 avril, 2000 11:07
> À: '[EMAIL PROTECTED]'
> Objet: LOOPING-PLEASE HELP!!!!
>
> 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.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.