Candace Cottrell wrote: >[EMAIL PROTECTED] 02/17/03 15:11 PM >>> >> 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. > > I KNOW>>> IT HUUUURRRTS ;)
It kills. >>>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? > > 10-31-2002 Schmo, Joe SURGERY MIBG SCAN @0830 937-555-5555 555555 > Broxson So the fields you are missing come from different tables. Is it a coincidence that you have 2 records which appear to be identical except for the date, or are you also getting too many rows returned by the query? (Check the debug output.) Can you query the patients table and the Visit_Type table directly and get something meaningful back? >>Maybe freaky charset issues? > > Freaky charsets are the worst kind... Non-unicode charsets are the worst. But did you set up anything to make sure the charset of the database matches the charset of CF MX? 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 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