Radicore Forum: How To » convert_parent_id_to_child

Home » RADICORE » How To » convert_parent_id_to_child_id

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: convert_parent_id_to_child_id [message #7261 is a reply to message #7257]

Thu, 07 February 2019 08:35

pdv
Messages: 15
Registered: January 2019

Junior Member

Tony,

I have a simple one-to-many relationship like department(id,...) <-->> employee(id,department_id,...).
I inserted a button on the department(list1) to list the employee(list2).

So far so good but this returned nothing, although there are matching rows. When looking at the query:

SET search_path TO 'public';
SELECT count(*) FROM employee
LEFT JOIN department ON (department.id=employee.department_id)
WHERE employee.id= '1' AND employee.department_id= '1'

I conclude that the first employee.id in the WHERE clause should have been department.id and then both clauses are redundant.
By debugging the code I've found that in convert_parent_id_to_child_id a comparison was made between 'department' and "='department'". The latter contains the operator because where2array(....,false) was called.
With where2array(...,true) the proper WHERE clause is returned and it works.

Regards,

Patrick

Report message to a moderator

[Message index]

		convert_parent_id_to_child_id By: pdv on Wed, 06 February 2019 14:18
		Re: convert_parent_id_to_child_id By: AJM on Thu, 07 February 2019 05:10
		Re: convert_parent_id_to_child_id By: pdv on Thu, 07 February 2019 08:35
		Re: convert_parent_id_to_child_id By: AJM on Fri, 08 February 2019 04:50
		Re: convert_parent_id_to_child_id By: pdv on Sat, 09 February 2019 14:23
		Re: convert_parent_id_to_child_id By: AJM on Sun, 10 February 2019 05:02
		Re: convert_parent_id_to_child_id By: pdv on Sat, 23 February 2019 05:37
		Re: convert_parent_id_to_child_id By: AJM on Sun, 24 February 2019 05:12

Previous Topic:	Multi servers and PostgreSQL
Next Topic:	Check for empty $schema in dml.psql.class.inc

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Oct 06 07:20:09 EDT 2024

Total time taken to generate the page: 0.01105 seconds