oh man that worked GREAT! I suppose the issue is that with the left join, there is no dependency on the other database. It just joins the fields. I hope this is a lesson learned.
thank a bunch - very hearty smile here... daniel > > Change it to a LEFT JOIN, which will always pull in the data from the > repair_ticket table, and return NULL in the columns from people_alt if > there is no match... > > <CFQUERY NAME="getSelect" DATASOURCE="dpch"> > SELECT a.repair_ticket_id,a.date_added,a.fname,a.lname,a.department,a. > fix_days, > a.time_of_day,a.technician,a.technician_fname,a.technician_lname,a. > status,a.severity,a ... > description,a.issue_type,a.platform,a.hardware_type,a.model,a.make,a. > operating_syste > m,p.location AS technician_location,p.email AS > technician_email,p.phone AS technician_phone > FROM repair_ticket a LEFT JOIN people_alt p ON a.people_alt_id = a. > technician > WHERE a.repair_ticket_id = #id# > </CFQUERY> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256002 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
