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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
