what happens when you cfdump the query? what do you see?
...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping & reporting www.navtrak.net 410.548.2337 -----Original Message----- From: Candace Cottrell [mailto:[EMAIL PROTECTED]] Sent: Monday, February 17, 2003 2:51 PM To: CF-Talk Subject: CFMX Upgrade Woes I upgraded to CFMX from CF 5 last week. Everything seemed to be going ok until today I have gotten a bunch of calls. Here's the problem and I have racked my brain and caused an aneurism trying to figure this out. Setup: Win 2000, CFMX Pro w/updater 1, IIS 5.0, SQL Server 2000 When doing a simple select, certain fields are coming up blank, even though there is data in there. CODE: <cfquery datasource="HEM" name="searchByDate"> Select * from Visit, Visit_Type, Patients, Physicians Where Visit.Patient_ID = Patients.PatientID AND Visit.Visit_Type_ID = Visit_Type.Visit_Type_ID AND Physicians.Physician_ID = Patients.PhysicianID Order BY Visit.Visit_Date </cfquery> <cfoutput query="searchByDate"> <tr> <td>#DateFormat(Visit_Date,"mm-dd-yyyy")#</td> <td>#PatientLName, #Patient_FName#</td> <td>Visit_Type_Name#</td> <td>#Visit_Description</td> <td>#Patient_Phone#</td> <td>#Medical_Record_No#</td> <td>#Physician_LName</td> </tr> </cfoutput> Now, when I go into SQL Enterprise Manager, the data for first and last name and visit type is there, but the data comes back as: 10-30-2002 , MIBG SCAN @0830 937-555-5555 555555 Broxson 10-31-2002 , MIBG SCAN @0830 937-555-5555 555555 Broxson Could this have something to do with an ISAPI filter?? Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4