Issues with undefined variable (Not showing up)
Hi!
I'm having an issue with joining/merging two different databases. I'm receiving all of the variables from one Datasource, but one variable is not showing up from the other DataSource.
Both of them are related to the "IDInquiry" field, but even after relating the two its not showing up.
Attached is my code:
<cfquery datasource="Portal" name="GetNoms">
SELECT IDStudent, NameFull, School_Name_Previous, InqContactPhone, P1_full, P1_phone_H, P1_city, IDINQUIRY
FROM Inquiries WHERE Inquiry = 1 AND Adm_Record_Status = 'Active' AND (Application IS NULL OR Application = 0)
AND Adm_Enr_Status = 'Inquired' AND P1_phone_H IS NOT NULL
AND P1_city IS NOT NULL AND YOE = '#YOE#'
ORDER BY P1_city ASC</
cfquery>
<cfquery datasource="Portal" name="GetPercentage">
SELECT IDInquiry, PercentComplete_display
FROM inq_PWSINPUT</cfquery>
<cfquery dbtype="query" name="FinalMix">
SELECT * FROM GetNoms, GetPercentage
WHERE GetNoms.IdInquiry = GetPercentage.IDINQUIRY
</cfquery>
What its telling me, is that my PercentComplete_display is undefined.
Any help would be appreciated!
