Jump to content
We've recently updated our Privacy Statement, available here ×

how do i get rid of error "no viable alternative at input '!'"?


Recommended Posts

My query runs fine under pgadmin query tool but the dataset and query dialog wizard gives the error.  Here's the query

 

select f.filer_ident, f.filer_info_id, r.report_info_ident, r.report_type_cd, r.info_only_flag, 
      to_char(c.contribution_dt,'fmMonth dd, yyyy') as cdate, c.contribution_amount, c.contribution_descr,
      concat(p.name_last,concat(',',p.name_first)) as name, p.name_organization, p.employer, p.occupation, p.job_title,
      a.city,a.state_cd, a.postal_code
from filer_info f
     left join report_info r on f.filer_info_id = r.filer_info_id and r.info_only_flag != 'Y' and (r.report_type_cd !='SS' and r.report_type_cd not like 'DAILY%')
     left join contribution_info c on r.report_info_id = c.report_info_id and c.itemize_flag = 'Y'
     left join contribution_persent cp on c.contribution_info_id=cp.contribution_info_id 
     left join persent_info p on cp.persent_info_id=p.persent_info_id
     left join persent_address pa on cp.persent_info_id=pa.persent_info_id
     left join address_info a on pa.address_info_id=a.address_info_id
where f.filer_info_id=$P{FilerInfoID} order by name
Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...