By the way, the code shoud read:
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>#Patient_LName#, #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>
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 14:55 PM >>>
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.
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
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
