query postgres select does not return results?

Question

I am developing a java app, and I use resultset. I write this query, it works and I get the results

SELECT * 
FROM BD 
WHERE 
    CAST(parent_id AS integer) = " + (Integer.parseInt(arrHeading[0])) + " 
    AND CAST(section AS double precision) = " + Double.parseDouble(arrHeading[1]) + "";

arrHeading is type string, but when I write the query below it does not return any results. cas is type character varying(12). I am having trouble because it's a character, and I dont know why I am not getting any result. I tried with the quotes but still does not work. Any ideas?

SELECT * 
FROM BD 
WHERE 
    CAST(parent_id AS integer) = " + (Integer.parseInt(arrHeading[0])) + " 
    AND CAST(section AS double precision) = " + Double.parseDouble(arrHeading[1]) + "
    AND cas = '" + arrHeading[2] + "'";

coder · Accepted Answer · 2012-05-24 16:17:01Z

3

I will suggest to first replace arrHeading[2] with the actual value in the query, i.e. hardcode cas=" 'your valiue' " and see if the query returns any result

answered May 24, 2012 at 16:17

coder

4,4562 gold badges21 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

bentham Over a year ago

I replace with SELECT * FROM BD WHERE CAST(parent_id AS integer)=" + (Integer.parseInt(arrHeading[0])) + " AND CAST(section AS double precision)=" + Double.parseDouble(arrHeading[1])+ "AND cas='" + "B1"+"'"; and I get results

András Váczi Over a year ago

@bentham - and if you print your query string?

bentham Over a year ago

I get SELECT * FROM BD WHERE CAST(parent_id AS integer)=19 AND CAST(section AS double precision)=1665.0 AND cas='B1 '

coder Over a year ago

it seems arrHeadin[2] have an extra white space, use arrHeading[2].trim()

Collectives™ on Stack Overflow

query postgres select does not return results?

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related