Radicore Forum: How To » How to filter by a parent field in a link1 transaction

Home » RADICORE » How To » How to filter by a parent field in a link1 transaction

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

Re: How to filter by a parent field in a link1 transaction [message #1505 is a reply to message #1486]

Fri, 18 July 2008 06:17

bonzo_bcn
Messages: 152
Registered: June 2008

Senior Member

Thant worked great if I only select one team, but in the case I select two teams and open the link1 transaction, the first team is shown ok, but when I click the 'next' link I get an error, because the sql statement seems to be different:

Fatal Error: MySQL error: 1054 - Unknown column 'equipo.categoria_id' in 'on clause' (# 1054).

SQL query: SELECT SQL_CALC_FOUND_ROWS part_equipo_xref.*, participante.catsalut, participante.nombre, 
participante.apellido1, participante.apellido2,
categoria.fecini, categoria.fecfin 
FROM part_equipo_xref LEFT JOIN participante ON 
(participante.participante_id=part_equipo_xref.participante_id) 
LEFT JOIN categoria ON (categoria.categoria_id=equipo.categoria_id) 
WHERE part_equipo_xref.participante_id IN (SELECT participante_id FROM part_ent_xref WHERE entidad_id=2) 
AND participante.fecnac between categoria.fecini
 AND categoria.fecfin LIMIT 10 OFFSET 0

At this pont it doesn't perform the join with 'equipo'.

Report message to a moderator

[Message index]

		How to filter by a parent field in a link1 transaction By: bonzo_bcn on Wed, 16 July 2008 13:24
		Re: How to filter by a parent field in a link1 transaction By: AJM on Wed, 16 July 2008 14:57
		Re: How to filter by a parent field in a link1 transaction By: bonzo_bcn on Wed, 16 July 2008 15:21
		Re: How to filter by a parent field in a link1 transaction By: AJM on Wed, 16 July 2008 16:30
		Re: How to filter by a parent field in a link1 transaction By: bonzo_bcn on Thu, 17 July 2008 15:15
		Re: How to filter by a parent field in a link1 transaction By: AJM on Thu, 17 July 2008 15:49
		Re: How to filter by a parent field in a link1 transaction By: bonzo_bcn on Thu, 17 July 2008 15:58
		Re: How to filter by a parent field in a link1 transaction By: AJM on Thu, 17 July 2008 16:49
		Re: How to filter by a parent field in a link1 transaction By: bonzo_bcn on Thu, 17 July 2008 17:09
		Re: How to filter by a parent field in a link1 transaction By: AJM on Thu, 17 July 2008 18:10
		Re: How to filter by a parent field in a link1 transaction By: bonzo_bcn on Fri, 18 July 2008 02:19
		Re: How to filter by a parent field in a link1 transaction By: AJM on Fri, 18 July 2008 05:05
		Re: How to filter by a parent field in a link1 transaction By: bonzo_bcn on Fri, 18 July 2008 05:25
		Re: How to filter by a parent field in a link1 transaction By: AJM on Fri, 18 July 2008 06:07
		Re: How to filter by a parent field in a link1 transaction By: bonzo_bcn on Fri, 18 July 2008 06:17
		Re: How to filter by a parent field in a link1 transaction By: AJM on Fri, 18 July 2008 06:33

Previous Topic:	override noedit on foreign field in multi2
Next Topic:	How ro remove the 'page created in' message

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Mon Nov 18 12:19:08 EST 2024

Total time taken to generate the page: 0.01156 seconds