nuBuilder Forum

I have a browse form which table content is retreived from diferent tables using the 'Before browse' php section, creating a temporary table wiht the hash variable #TABLE_ID#

Therefore the SQL of the browse form is: SELECT * FROM #TABLE_ID#

This works fine when displaying the browse form. However, when pressing the 'Print' button, the new window only displays the headers of the table.

I checked the vale of 'last.browse_sql' in the nuPrintAction() function, and it is somthing like: SELECT title_01, title_02 FROM ___nu15a87637ede74e___ WHERE 1

This query throws an error becuase the tempory table created 'Before browsing' no longer exists.

Is there any workaround for this?

Kind regrads


Fike

Fike,

At the moment, that is a bug.

A workaround, in the meantime, would be creating a VIEW instead of creating the temp table.

And using that as a TABLE.

Steven

The view worked great!

Thank's a lot Steven!

.

admin wrote:Fike,

At the moment, that is a bug.

A workaround, in the meantime, would be creating a VIEW instead of creating the temp table.

And using that as a TABLE.

Steven

When can we expect a fix? Using a VIEW is no option for me. (need to dynamically create the sql statement). Thank you.

Timo,

The Print Button should now work using #TABLE_ID#


Steven

Thanks! I'll try it out as soon as I have a chance.

.

It works like a charm

.