THIS works:
<cfquery name="GetAll" datasource="PaceCareData" maxrows=10>
SELECT BasicInfo.*, Identity.*, Enrollment.*
FROM BasicInfo
INNER JOIN Identity ON BasicInfo.IDID = Identity.ID
INNER JOIN Enrollment ON BasicInfo.IDID = Enrollment.IDID
ORDER BY LastName ASC, FirstName ASC
</cfquery>
#GetAll.RecordCount# Clients found with recert dates between
#DateFormat(MAStartDate,"MM/DD/YYYY")# and
#DateFormat(MAEndDate,"MM/DD/YYYY")#<br><br>
<cfloop query="GetAll">
#Trim(GetAll.LastName)#, #Trim(GetAll.FirstName)# #Trim(GetAll.MI)#
#DateFormat(GetAll.mcaidrecda,"MM/DD/YYYY")#<br>
</CFLOOP>
Note that I refer to mcaidrecda in my CFLOOP at the end of the code shown
above, and it displays accurately in the output.
THIS Fails:
<cfquery name="GetAll" datasource="PaceCareData" maxrows=10>
SELECT BasicInfo.mcaidrecda, Identity.*, Enrollment.*
FROM BasicInfo
INNER JOIN Identity ON BasicInfo.IDID = Identity.ID
INNER JOIN Enrollment ON BasicInfo.IDID = Enrollment.IDID
ORDER BY LastName ASC, FirstName ASC
</cfquery>
The specific error is as follows:
Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC
Socket][Microsoft][ODBC Visual FoxPro Driver]SQL: Column 'MCAIDRECDA' is not
found.
#GetAll.RecordCount# Clients found with recert dates between
#DateFormat(MAStartDate,"MM/DD/YYYY")# and
#DateFormat(MAEndDate,"MM/DD/YYYY")#<br><br>
<cfloop query="GetAll">
#Trim(GetAll.LastName)#, #Trim(GetAll.FirstName)# #Trim(GetAll.MI)#
#DateFormat(GetAll.mcaidrecda,"MM/DD/YYYY")#<br>
</CFLOOP>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311378
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
