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-)#/td td#PatientLName, #Patient_FName#/td tdVisit_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- 55 Broxson 10-31-2002 , MIBG SCAN @0830 937-555- 55 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=subscribeforumid=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
RE: CFMX Upgrade Woes - Tony
and from query analyzer they come back as values? ...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 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-)#/td td#PatientLName, #Patient_FName#/td tdVisit_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- 55 Broxson 10-31-2002 , MIBG SCAN @0830 937-555- 55 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=subscribeforumid=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
RE: CFMX Upgrade Woes - Tony
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-)#/td td#PatientLName, #Patient_FName#/td tdVisit_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- 55 Broxson 10-31-2002 , MIBG SCAN @0830 937-555- 55 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=subscribeforumid=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
RE: CFMX Upgrade Woes - Tony
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-)#/td : td#PatientLName, #Patient_FName#/td : tdVisit_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- 55 Broxson : : 10-31-2002 , MIBG SCAN @0830 937-555- 55 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=subscribeforumid=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
RE: CFMX Upgrade Woes - Tony
You got it 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:43 PM and from query analyzer they come back as values? ...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 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-)#/td td#PatientLName, #Patient_FName#/td tdVisit_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- 55 Broxson 10-31-2002 , MIBG SCAN @0830 937-555- 55 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=subscribeforumid=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