Candace, try "ctrl-0" on the columns which are coming up empty, than mouseout to save the nulls and then re-enter your data in the columns and mouseout again Requery the page and cfdump.
There may be some corrupt data. ---------- Original Message ---------------------------------- From: "Candace Cottrell" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Mon, 17 Feb 2003 15:24:07 -0500 >They're coming back as empty strings... > >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:15 PM >>> >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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
