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.
