Candace Cottrell wrote: > > Here's the problem and I have racked my brain and caused an aneurism > trying to figure this out.
You should be carefull with those. > Setup: Win 2000, CFMX Pro w/updater 1, IIS 5.0, SQL Server 2000 Why not Updater 2? > <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> Missing many #'s here. > 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 How should it come back? > Could this have something to do with an ISAPI filter?? I doubt it. ISAPI filter is between CF MX and the browser, not between CF MX and the database. So if you do a Len() on the database field and the result is 0, an ISAPI filter is not the problem. Maybe freaky charset issues? Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4