Hi all, I just moved my box to another domain in another network but the actual box stayed the same and contains CF 4.5, Oracle 8i and IIS.
I tried to run one of my reports and I get the following error: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC driver for Oracle][Oracle]ORA-00936: missing expression SQL = "select q.incident,(q.calldate||' '|| q.calltime) as create_time, min(c.calldate||' '|| c.calltime) as action_time, sysdate from cnotes c, question q where c.incident=q.incident and =2.12452406865E-314 and =q.incident and (c.callgroup is not null) group by q.incident,q.calldate||' '|| q.calltime" The actual query is: select q.incident as incident, (q.calldate||' '|| q.calltime) as create_time, min(to_char((to_date((c.calldate||' '|| c.calltime),'DD-MON-YY HH24:MI:SS') - to_date((q.calldate||' '|| q.calltime),'DD-MON-YY HH24:MI:SS'))*24,'0000.00')) AS difference, sysdate from cnotes c,question q where c.incident=q.incident and q.calldate >= sysdate-#Actionrange# and c.calldate is not null and (c.callgroup is not null) and q.incident not in (select incident from cnotes where callnote like '%Case taken from @Cus Support+Knowledge Base%') group by q.incident,q.calldate||' '|| q.calltime Actionrange is a variable set to 8 by default. I'm thinking the problem is related to the greater than sign, but am not sure. The report worked fine up until the move and the box itself is the same as it was before, only the domain is different. Please help, I am completely stumped. Even if you can just give me some idea where the 2.12452406865E-314 is coming from I'd appreciate it. Running the query in native SQL has no problems even on that box. Thanks in advance, Margaret ______________________________________________________________________ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
