Hello all,
Having a loop with let say three values coming from read database action . data provider is for exemple :{var:read_data_base}
In the body loop another read data action get correctly the first loop parameter into the WHERE condition , and then stay stuck with that value. The loop runs correctly.
If using php condition instead of WHERE condition , parameter pass correctly.
Schematically as follows
READ DATABASE
LOOP
READ DATABASE (stuck with the first parameter of the loop when using WHERE CONDITIONS)
READ DATABASE (Correct if using PHP CONDITIONS)
any thoughts ?
Having a loop with let say three values coming from read database action . data provider is for exemple :{var:read_data_base}
In the body loop another read data action get correctly the first loop parameter into the WHERE condition , and then stay stuck with that value. The loop runs correctly.
If using php condition instead of WHERE condition , parameter pass correctly.
Schematically as follows
READ DATABASE
LOOP
READ DATABASE (stuck with the first parameter of the loop when using WHERE CONDITIONS)
READ DATABASE (Correct if using PHP CONDITIONS)
any thoughts ?
Hi
I think in this case it's better to use Data Base Table relations if your tables are a common field...
I think in this case it's better to use Data Base Table relations if your tables are a common field...
Hi Colnem,
Probably i missexplained.
The problem is a probable a bug as READ DATABASE is meant for the same action which works well when using "PHP conditions" and get stuck when using "WHERE Conditions".
READ DATABASE (remain stuck with the first loop parameter when using WHERE CONDITIONS)
and the same action
READ DATABASE (uses the correct parameter (coming from the loop) when using PHP CONDITIONS)
To my understanding using WHERE Conditions box or PHP Conditions box should give the same outcome for the READ DATABASE (unless i missed something) .....
rgds,
Probably i missexplained.
The problem is a probable a bug as READ DATABASE is meant for the same action which works well when using "PHP conditions" and get stuck when using "WHERE Conditions".
READ DATABASE (remain stuck with the first loop parameter when using WHERE CONDITIONS)
and the same action
READ DATABASE (uses the correct parameter (coming from the loop) when using PHP CONDITIONS)
To my understanding using WHERE Conditions box or PHP Conditions box should give the same outcome for the READ DATABASE (unless i missed something) .....
rgds,
You need to login to be able to post a reply.