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
