Error encountered while building page:
type:Database
call stack: CFOUTPUT,CFINCLUDE,CFINCLUDE,CFSAVECONTENT,CFINCLUDE,CFINCLUDE,CFINCLUDE,CFSAVECONTENT,CFINCLUDE,CFINCLUDE

1 CFQUERY (13,0) /web/prod/colby/itscustomcf/GetName.cfm

2 CFMODULE (15,0) /web/prod/colby/templates/directory_head.cfm

3 CFINCLUDE (45,0) /web/prod/commonspot/utilities/invoke-dynamic-module.cfm

4 CFINCLUDE (6,0) /web/prod/commonspot/utilities/invoke-dynamic-cfml.cfm

5 CFMODULE (46,0) /web/prod/colby/templates/template-basepage.head

6 CFINCLUDE (238,0) /web/prod/commonspot/render-head.cfm

7 CFINCLUDE (169,0) /web/prod/commonspot/render-page-meat.cfm

8 CF_RENDER-PAGE-MEAT (7,0) /web/prod/commonspot/render-page-meat.cfm

9 CF_RENDER-PAGE-MEAT (1,0) /web/prod/commonspot/render-page-meat.cfm

10 CFINCLUDE (36,0) /web/prod/commonspot/render-page.cfm

11 CFINCLUDE (22,0) /web/prod/commonspot/master-render.cfm

12 CFINCLUDE (189,0) /web/prod/commonspot/uncached-master.cfm

13 CFINCLUDE (162,0) /web/prod/commonspot/utilities/cached-page-render.cfm

14 CFINCLUDE (185,0) /web/prod/commonspot/master.cfm

15 CF_MASTER (1,0) /web/prod/commonspot/master.cfm

16 CFINCLUDE (76,0) /web/prod/colby/directory_cs/directoryview.cfm

nativeError:-201
sqlState:42000
SQL: SELECT id_rec.id, id_rec.fullname, id_rec.addr_line1, id_rec.addr_line2, id_rec.city, id_rec.st, id_rec.zip, id_rec.phone, id_rec.ctry, cuser_rec.login, cuser_rec.class, cuser_rec.stat, addree_rec.alt_name FROM informix.id_rec, outer informix.cuser_rec, outer addree_rec WHERE id_rec.id = and cuser_rec.id = id_rec.id and id_rec.id = addree_rec.prim_id and addree_rec.style = 'P' and addree_rec.id_used_by in (59123, 59143) and (addree_rec.inactive_date is NULL or addree_rec.inactive_date > today)
CFQueryParam values:
message:Error Executing Database Query.
detail:[Macromedia][Informix JDBC Driver][Informix]A syntax error has occurred.