Re: CFMX Upgrade Woes - Bryan

2003-02-17 Thread Candace Cottrell 
Thanks Bryan, I fixed those. (I had copied those out of the original
page and made a new test page) It seems like a behind the scenes problem
versus a code problem because the app has worked great for a year, then
all of a sudden it's broken (after I upgraded).

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:26 PM >>>
Check your syntax.

You missed a few pounds

 
 
  #DateFormat(Visit_Date,"mm-dd-")# 
  #PatientLName, #Patient_FName# 
  Visit_Type_Name# 
  #Visit_Description 
  #Patient_Phone# 
  #Medical_Record_No# 
  #Physician_LName 
 
  

should be

 
 
  #DateFormat(Visit_Date,"mm-dd-")# 
  #PatientLName#, #Patient_FName# 
  #Visit_Type_Name# 
  #Visit_Description 
  #Patient_Phone# 
  #Medical_Record_No# 
  #Physician_LName# 
 
  

-- Original Message --
From: "Candace Cottrell" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date:  Mon, 17 Feb 2003 14:51:25 -0500

>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:
>
>
>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
>
>
>  
> 
>  #DateFormat(Visit_Date,"mm-dd-")#
>  #PatientLName, #Patient_FName#
>  Visit_Type_Name#
>  #Visit_Description
>  #Patient_Phone#
>  #Medical_Record_No#
>  #Physician_LName
>
>   
>
>
>
>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=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

RE: CFMX Upgrade Woes - Bryan

2003-02-17 Thread Candace Cottrell 
No luck... thanks for the response though :)

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 16:27 PM >>>
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:
>
>
>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
>
>
>  
> 
>  #DateFormat(Visit_Date,"mm-dd-")#
>  #PatientLName, #Patient_FName#
>  Visit_Type_Name#
>  #Visit_Description
>  #Patient_Phone#
>  #Medical_Record_No#
>  #Physician_LName
>
>   
>
>
>
>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=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