I need colect the data from a database.
I have 3 tables with 80000, 8713 and 2046 rows each. I did a sql string to join them and show the result, but when I run in planet press return a low memory message, but my pc has 4Gb ram...
So I need now if I can pass a varible in the sql string inside planet press, this away I can cut it in parts.
something like it: 'select * from table where var=&planet_variable'.

Thanks

I've never returned that large of a data set, but have used the select statement frequently.

Make sure variables in the WHERE clause are notated correctly... i.e. var=%{planet_variable}

(it must have the %{variablename} notation)

nth

I created a new tabe to join all data and call this table in planet press.

Now I have a new doubt.
I have a job with 4 pages. I need print the 2 first, but the other only if a database value change.

like it.

value = 1234

do

page 1 and 2 any time

until value =4321

do page 3 and 4 of 1234 value

after it do page 1 and 2 of 4321 value.

I need do it until end of data rows.