Radicore Forum: Transaction Patterns » PopUp

Home » RADICORE development » Transaction Patterns » PopUp - Link1 table

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

Re: PopUp - Link1 table [message #5572 is a reply to message #5567]

Thu, 26 May 2016 12:58

htManager
Messages: 434
Registered: May 2014

Senior Member

I read FAQ08 and FAQ84 but I struggle all day long with the SQL syntax and I don't know what I am doing wrong. I try to improve my SQL skills (as you suggested) but this is at the moment obiously too much for me.

This component script of the popup2 will show no entries.

$outer_table = 'training_plan_uebungskategorie'; // name of outer (parent) table
$inner_table = 'training_plan_uebungen_kategorie'; // name of inner (child) table
$screen = 'training_plan_uebungen_kategorie.popup2.screen.inc'; // file identifying screen structure

// customise the SQL SELECT statement
$outer_sql_select = null;

$inner_sql_select = null;
$inner_sql_from = 'training_plan_uebungen_kategorie '
. 'LEFT JOIN training_plan_uebungen ON ('
. 'training_plan_uebungen.training_plan_uebung_no = training_plan_uebungen_kategorie.u_training_plan_uebung_no AND '
. 'training_plan_uebungen.rdcaccount_id = training_plan_uebungen_kategorie.u_rdcaccount_id) ';
$inner_sql_where = null;

require 'std.list2.popup.inc'; // activate page controller

The following error message and the SQL statement will be shown if the default sort order of the link table is a field value of one of the parent tables (linked with a relationship).

Fatal Error: MySQL: Unknown column 'training_plan_kategorie_desc' in 'order clause' (# 1054)

SQL query: SELECT SQL_CALC_FOUND_ROWS * FROM training_plan_uebungen_kategorie LEFT JOIN training_plan_uebungen ON (training_plan_uebungen.training_plan_uebung_no = training_plan_uebungen_kategorie.u_training_plan_uebung_no AND training_plan_uebungen.rdcaccount_id = training_plan_uebungen_kategorie.u_rdcaccount_id) WHERE

training_plan_uebungen.rdcaccount_id='1'

AND training_plan_uebungen_kategorie.k_training_plan_kategorie_i d='ABW-GRDU' AND training_plan_uebungen_kategorie.k_rdcaccount_id='1' ORDER BY training_plan_kategorie_desc asc LIMIT 10 OFFSET 0

The expression "training_plan_uebungen.rdcaccount_id='1'" is obviously inserted by the framework. If I change the values of rdcaccount_id to 1, the records will not be shown.
Do I have to change the where clause, too?

Report message to a moderator

[Message index]

		PopUp - Link1 table By: htManager on Mon, 23 May 2016 04:44
		Re: PopUp - Link1 table By: AJM on Mon, 23 May 2016 05:59
		Re: PopUp - Link1 table By: htManager on Tue, 24 May 2016 10:37
		Re: PopUp - Link1 table By: AJM on Wed, 25 May 2016 04:39
		Re: PopUp - Link1 table By: htManager on Wed, 25 May 2016 06:21
		Re: PopUp - Link1 table By: AJM on Wed, 25 May 2016 07:28
		Re: PopUp - Link1 table By: htManager on Wed, 25 May 2016 09:57
		Re: PopUp - Link1 table By: AJM on Wed, 25 May 2016 10:12
		Re: PopUp - Link1 table By: htManager on Thu, 26 May 2016 12:58
		Re: PopUp - Link1 table By: AJM on Thu, 26 May 2016 14:48
		Re: PopUp - Link1 table By: htManager on Fri, 27 May 2016 03:09
		Re: PopUp - Link1 table By: AJM on Fri, 27 May 2016 05:41
		Re: PopUp - Link1 table By: htManager on Fri, 27 May 2016 10:00
		Re: PopUp - Link1 table By: AJM on Sat, 28 May 2016 05:09
		Re: PopUp - Link1 table By: htManager on Tue, 31 May 2016 05:00
		Re: PopUp - Link1 table By: AJM on Wed, 01 June 2016 05:18
		Re: PopUp - Link1 table By: htManager on Sun, 15 March 2020 05:59
		Re: PopUp - Link1 table By: AJM on Sun, 15 March 2020 12:51
		Re: PopUp - Link1 table By: htManager on Sun, 15 March 2020 15:16
		Re: PopUp - Link1 table By: AJM on Mon, 16 March 2020 13:02
		Re: PopUp - Link1 table By: htManager on Tue, 17 March 2020 07:45
		Re: PopUp - Link1 table By: AJM on Wed, 18 March 2020 06:28
		Re: PopUp - Link1 table By: htManager on Wed, 18 March 2020 12:23
		Re: PopUp - Link1 table By: AJM on Thu, 19 March 2020 05:23
		Re: PopUp - Link1 table By: htManager on Fri, 20 March 2020 08:31
		Re: PopUp - Link1 table By: AJM on Sat, 21 March 2020 07:52
		Re: PopUp - Link1 table By: htManager on Sun, 22 March 2020 04:45
		Re: PopUp - Link1 table By: AJM on Sun, 22 March 2020 05:19
		Re: PopUp - Link1 table By: htManager on Sun, 22 March 2020 09:41
		Re: PopUp - Link1 table By: AJM on Mon, 23 March 2020 06:47
		Re: PopUp - Link1 table By: htManager on Mon, 23 March 2020 16:57
		Re: PopUp - Link1 table By: htManager on Wed, 12 August 2020 06:54
		Re: PopUp - Link1 table By: AJM on Sat, 15 August 2020 04:38

Previous Topic:	Filepicker - choose Null button
Next Topic:	List view (List3)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Nov 24 21:56:09 EST 2024

Total time taken to generate the page: 0.01443 seconds