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
