Is the missing data stored in text fields? If so, is the flag for returning long data set in the CF Admin? Other than the missing #s, it's all I can think of offhand.
-- Ben Doom Programmer & General Lackey Moonbow Software, Inc : -----Original Message----- : From: Candace Cottrell [mailto:[EMAIL PROTECTED]] : Sent: Monday, February 17, 2003 3:24 PM : To: CF-Talk : Subject: RE: CFMX Upgrade Woes - Tony : : : 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4