Please help me, how to fix this: ODBC Error Code = S1000 (General error) [MERANT][ODBC SQL Server Driver]Unicode conversion failed SQL = "select count(distinct tracker_id) as sessions, min(datetimestamp), case Referrer when '' then 'No Referrer' else Referrer end as ref_site from SiteTracker log1 with (NOLOCK) where Convert(datetime, datetimestamp) >= {ts '2001-07-28 00:00:00'} and Convert(datetime, datetimestamp) <= {ts '2001-08-29 00:00:00'} group by case Referrer when '' then 'No Referrer' else Referrer end order by count(distinct tracker_id) desc" thanks ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists