It's a straight up table. I dont get it because the other info from the table is selecting. (ie. phone number, medical record number) Just the first and last names and the view type are out of whack.
Thanks for the response :) 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] >>> [EMAIL PROTECTED] 02/17/03 15:05 PM >>> Is your query on a table or a view? Views can get out of whack (I believe that's the technical term) if the underlying tables are modified. Solution is to open and resave them. ----- Original Message ----- From: "Candace Cottrell" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, February 18, 2003 8:51 AM 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
