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
                                

Reply via email to