Hi Dick, It's Tim. I don't know what is causing your problem, but from the information you gave, it looks like your sql query is not complete. Look in the subquery "(SELECT id FROM IOC. )" after the "IOC.", I believe there should be some table name which the "id" data should be selected from. If this is the problem, then the subquery is not being built correctly.
--Tim Dick Calhoun wrote: > Hi Folks, > Our production version of Mail Manager 2.0 on Windows server-2000; PostgreSQL > 8.0.7 has been working OK until recently. When we attempt to do a "Search", > delete & archive, or enter the "Reports" page, we get a programming error as > follows: (from Zope ZMI error_log) > > ERROR: invalid input syntax for type timestamp with time zone: "2006/11/01 > 23:59:59 US/Eastern" SELECT COUNT(1) AS count FROM IOC.mm_ticket WHERE id IN > (SELECT id FROM IOC. ) > > I can think of nothing we consciensly did to cause this? Have tried to > delete the old instance and create a new one but I am sure that all I did was > copy the problem into the new instance. > > Any ideas on how to cure this?? > > Dick Calhoun > InterMedi@ Marketing Solutions > Ofc. Ph: 610-701-9654 > > > ------------------------------------------------------------------------- > Using Tomcat but need to do more? Need to support web services, security? > Get stuff done quickly with pre-integrated technology to make your job easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > _______________________________________________ > Mailmanager-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/mailmanager-users ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Mailmanager-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/mailmanager-users
