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