We have a call center server doing queries against UV via JDBC, and are having trouble with one of the queries. I'm not a SQL syntax expert, but this query is OK as far as I can tell:
SELECT EMAIL.ADDRESS, LEN.OF.KEY, Q1, Q2, Q3, Q4, PRIORITY, SIC.CODE, SLS.NO, CUST.NO, CUST.NAME, TERRITORY.REP, PRIMARY.PHONE FROM EMAIL.CX WHERE EMAIL.ADDRESS = '$fromEmail' or (DOMAIN = '$fromDomain' and DOMAIN.FLAG = 'Y') ORDER BY LEN.OF.KEY DESC; Can anyone else see any problems there? TIA, John _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
