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.
