danielobs Posted April 19, 2010 Share Posted April 19, 2010 Hi,In Input Control (Single-select Query) I have this SQL query: SET transaction READ WRITE;DROP SEQUENCE IF EXISTS kkk;CREATE TEMP SEQUENCE kkk START 1;select kontrahent, nazwa, nip from (select nextval('kkk') as xx, kontrahent, nazwa, nip from kontra_a where nip like '356%' union select nextval('kkk') as xx, -1, 'NO DATA', 'NO DATA') as aa where kontrahent>=0 or (kontrahent=-1 and xx = 1);Unfortunately jasperserver returns error "Request returned no results" and more but the pgAdmin of the same SQL returns the correct result. What could be causing problems on the jasperserver?Best regards,Daniel Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now